PHP Classes

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    
Ratings Unique User Downloads Download Rankings
StarStarStar 59%Total: 2,887 This week: 1All time: 1,300 This week: 560Up
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 is available for providing paid consulting. Contact Ihor Khomyn .
Classes: 3 packages by
Country: Ukraine Ukraine
Age: 51
All time rank: 99917 in Ukraine Ukraine
Week rank: 411 Up8 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,887
This week:1
All time:1,300
This week:560Up
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:1282
 
This a very good and useful class !
13 years ago (José Filipe Lopes Santos)
80%StarStarStarStarStar