Login   Register  
PHP Classes
elePHPant
Icontem

Paginations: Split MySQL query result listings

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-05-13 (4 years ago) RSS 2.0 feedStarStarStarStar 72%Total: 3,281 This week: 1All time: 983 This week: 1,435Down
Version License PHP version Categories  
paginations 1.0Freeware3.0HTML, Databases
Description Author  

This class can be used to split MySQL database query listings between multiple pages.

It takes as parameters a SQL query, the limit number of result rows to display per page, and the number of the listing page being displayed.

The class executes the query to retrieve the results of the current page and stores the result handle in a class variable.

The class also generates HTML with links to go to the first, last, next, previous and any intermediate page of the listing.

It also generates HTML to display the current page being display and the total number of rows in the result set.

The links trigger the call of a Javascript function that will switch to the page associated with the link.

Picture of Reneesh T K
Name: Reneesh T K <contact>
Classes: 2 packages by
Country: India India
Age: 32
All time rank: 23613 in India India
Week rank: 229 Up25 in India India Down

  Files folder image Files  
File Role Description
Accessible without login Plain text file readme Doc. readme
Accessible without login Plain text file testpage.php Example test page
Plain text file pagination_class.php Class class file

 Version Control Unique User Downloads Download Rankings  
 0%Total:3,281All time:983
 This week:1This week:1,435Down
User Ratings User Comments (4)  
 All time
Utility:91%StarStarStarStarStar
Consistency:83%StarStarStarStarStar
Documentation:86%StarStarStarStarStar
Examples:97%StarStarStarStarStar
Tests:-
Videos:-
Overall:72%StarStarStarStar
Rank:132
 
Useful and straightforward.
3 years ago (Tom Carnevale)
65%StarStarStarStar
Very simple and easy to use :)
3 years ago (Denis Dantas Uyeda)
75%StarStarStarStar
A realy nice and valuable class for pagination Hats off reneesh
6 years ago (jobanjohn)
80%StarStarStarStarStar
Simple and good
6 years ago (bipin)
60%StarStarStarStar