PHP Classes

Perfect MySQL Paging: Display links to browse MySQL query results

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2009-08-03 (6 years ago) RSS 2.0 feedNot enough user ratingsTotal: 791 All time: 4,045 This week: 1,136Up
Version Licenses PHP version Categories  
perfect_mysql_paging 1.0Freely Distributable4.0HTML, Databases
Description Author  

This class can be used to display links to browse MySQL query results split in multiple pages.

It takes an SQL query string and counts the number of result rows.

The class can generate links to browse multiple pages among which the query results will be split. The presentation of the links is configurable using CSS styles.

The limit number of results to display per page, the limit of links to display and the base link URL are configurable details.

Picture of Khurram Adeeb Noorani
Name: Khurram Adeeb Noorani <contact>
Classes: 2 packages by
Country: Pakistan Pakistan
Age: 29
All time rank: 197025 in Pakistan Pakistan
Week rank: 1497 Up29 in Pakistan Pakistan Down
Innovation award
Innovation award
Nominee: 1x

Details provided by the author  
Perfect MySQL Paging

1. Create a database named "paging" (or any other name of your choice) in your MySQL.
2. Dump "paging.sql" on the newly created database.
3. Open "database.php" in an editor and make necessary changes on line numbers 15, 16, 17 and 18.
4. Deploy all the php files on your web server.
5. Finally run "index.php" in your browser.
  • screenshot.png
  Files folder image Files  
File Role Description
Plain text file class.paging.php Class main class file
Plain text file database.php Conf. database connection
Plain text file index.php Example paging example
Plain text file paging.sql Data SQL dump
Plain text file readme.txt Doc. documentation

 Version Control Unique User Downloads Download Rankings  
 0%Total:791All time:4,045
 This week:0This week:1,136Up
 User Comments (1)  
Thats a very good and useful class .
6 years ago (Josť Filipe Lopes Santos)