PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2009-08-03 (7 years ago) RSS 2.0 feedNot enough user ratingsTotal: 800 All time: 4,144 This week: 781Up
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.

Name: Khurram Noorani <contact>
Classes: 2 packages by
Country: Australia Australia
Innovation award
Innovation award
Nominee: 1x

Details
====================
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.
Screenshots  
  • 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:800
This week:0
All time:4,144
This week:781Up
User Comments (1)
Thats a very good and useful class .
7 years ago (José Filipe Lopes Santos)
80%StarStarStarStarStar