PHP Classes

AJAX pagination: Display paginated MySQL results updated using AJAX

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 59%Total: 2,896 All time: 1,296 This week: 57Up
Version License PHP version Categories
ajax-pagination 1.0.0Free for non-comm...5.0Databases, AJAX
Description 

Author

This class can be used to display paginated MySQL query results updated using AJAX requests.

It can execute a given MySQL query and generate a response to update a page that shows different pages of query results using AJAX to avoid page reloading.

Picture of Ihor Khomyn
Name: Ihor Khomyn <contact>
Classes: 3 packages by
Country: Ukraine Ukraine
Innovation award
Innovation award
Nominee: 2x

Details

This class intended to allow to show the paginated representation of MySQL table data on the html page the simpliest way the possible from the php/html coding point of view. It uses MooTools library (http://mootools.net/) to make AJAX data requests and page data update. The usage of this class demonstrated with the simple demo included, along with much advanced example provided by SourceForge project http://geonotes.sourceforge.net/ To install and use demo you should: 1. Upload all the files to the web server keeping the folders structure. mootools.js and mootools-more.js file should be placed in the includes folder. You can get them at the http://mootools.net/ 2. Create MySQL database and import ajaxpagination.sql file to it 3. Edit index.php lines 15 & 16 to set corresponding values 4. Run open index.php via browser /***************************************************************************************/ /** **/ /** Copyright (c)'2010 by Igor Homyn **/ /** **/ /** hoorkeet@gmail.com **/ /** **/ /** http://www.phpclasses.org/package/6689-PHP-Dynamic-pagination-of-MySQL-table.html **/ /** **/ /***************************************************************************************/

  Files folder image Files (15)  
File Role Description
Files folder imageimages (9 files)
Files folder imageincludes (1 file)
Plain text file AJAXpagination.php Class Main class file
Plain text file ajaxpagination.sql Data demo MySQL data set
Plain text file index.php Example demo script
Plain text file readme.txt Doc. a simple readme
Image file screenshot.jpg Screen just a simple demo of pagination

  Files folder image Files (15)  /  images  
File Role Description
  Image file 1w.gif Icon no picture substitution image
  Image file DmytroDoncov.jpg Photo demo data set image
  Image file GrygoriiSkovoroda.jpg Photo demo data set image
  Image file IvanMazepa.jpg Photo demo data set image
  Image file LubomyrGuzar.jpg Photo demo data set image
  Image file RomanShukhevych.jpg Photo demo data set image
  Image file spinner.gif Icon AJAX spinner
  Image file TarasShevchenko.jpg Photo demo data set image
  Image file VolodymyrIvasyuk.jpg Photo demo data set image

  Files folder image Files (15)  /  includes  
File Role Description
  Plain text file mootools.txt Data placeholder for MooTools library

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,896
This week:0
All time:1,296
This week:57Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:77%StarStarStarStar
Documentation:69%StarStarStarStar
Examples:72%StarStarStarStar
Tests:-
Videos:-
Overall:59%StarStarStar
Rank:1304
 
This a very good and useful class !
14 years ago (José Filipe Lopes Santos)
80%StarStarStarStarStar