PHP Classes
elePHPant
Icontem

AJAX pagination: Display paginated MySQL results updated using AJAX

Recommend this page to a friend!
  Info   View files View files (15)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2010-12-24 (6 years ago) RSS 2.0 feedStarStarStar 59%Total: 2,747 This week: 2All time: 1,338 This week: 403Up
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.

Name: Ihor Khomyn is available for providing paid consulting. Contact Ihor Khomyn .
Classes: 3 packages by
Country: Ukraine Ukraine
Age: 44
All time rank: 100617 in Ukraine Ukraine
Week rank: 369 Up9 in Ukraine Ukraine Up
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  
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  /  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  /  includes  
File Role Description
  Plain text file mootools.txt Data placeholder for MooTools library

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,747
This week:2
All time:1,338
This week:403Up
User Ratings User Comments (1)
 All time
Utility:75%StarStarStarStar
Consistency:78%StarStarStarStar
Documentation:71%StarStarStarStar
Examples:71%StarStarStarStar
Tests:-
Videos:-
Overall:59%StarStarStar
Rank:1251
 
This a very good and useful class !
6 years ago (Josť Filipe Lopes Santos)
80%StarStarStarStarStar