PHP Classes

Perfect MySQL Paging: Display links to browse MySQL query results

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 65%Total: 812 All time: 4,247 This week: 49Up
Version Licenses PHP version Categories
perfect_mysql_paging 1.0Freely Distributable4.0HTML, Databases
Description 

Author

Khurram Noorani

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
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 (1)  
  • screenshot.png
  Files folder image Files (6)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadperfect_mysql_paging-2009-08-03.zip 45KB
Downloadperfect_mysql_paging-2009-08-03.tar.gz 44KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:812
This week:0
All time:4,247
This week:49Up
User Ratings User Comments (1)
 All time
Utility:83%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:75%StarStarStarStar
Examples:83%StarStarStarStarStar
Tests:-
Videos:-
Overall:65%StarStarStarStar
Rank:592
 
Thats a very good and useful class .
15 years ago (José Filipe Lopes Santos)		80%StarStarStarStarStar
 

  Applications that use this package  
Twitterface is a web-based, personally-branded, multi-account Twitter interface

Add link image If you know an application of this package, send a message to the author to add a link here.