PHP Classes

Perfect MySQL Paging: Display links to browse MySQL query results

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 809 All time: 4,235 This week: 257Up
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 Noorani
Name: Khurram Noorani <contact>
Classes: 2 packages by
Country: Australia Australia
Age: 36
All time rank: 209230 in Australia Australia
Week rank: 587 Up7 in Australia Australia Up
Innovation award
Innovation award
Nominee: 1x

==================== 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  
This week:0
All time:4,235
This week:257Up
User Comments (1)
Thats a very good and useful class .
13 years ago (Josť Filipe Lopes Santos)