PHP Classes
elePHPant
Icontem

Database Pagination: Paginate database 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 (3)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2013-05-14 (2 years ago) RSS 2.0 feedStarStarStar 45%Total: 750 This week: 2All time: 4,228 This week: 672Up
Version License PHP version Categories  
db-pagination 1.0GNU General Publi...5.1HTML, PHP 5, Databases
Description Author  

This class can paginate database query result listings.

The main pagination class can call a database access class which uses PDO to retrieve the total number of records for database query to a given table matching a given condition.

The pagination class can generate HTML for links to go to the next, previous, first, last and any intermediate pages of the listing the query results.

The number of the current page and the search results order is retrieved from a GET request parameter. The limit of records to list per page is configurable.

The class can also execute the query to retrieve into an array the records to display in the current page.

Picture of Ron Darby
  Performance   Level  
Name: Ron Darby <contact>
Classes: 4 packages by
Country: South Africa South Africa
Age: 34
All time rank: 99810 in South Africa South Africa
Week rank: 449 Up4 in South Africa South Africa Up

  Files folder image Files  
File Role Description
Plain text file db.class.php Class database connection class
Accessible without login Plain text file index.php Example Sample usage
Plain text file pagination.class.php Class pagination class

 Version Control Unique User Downloads Download Rankings  
 0%Total:750All time:4,228
 This week:2This week:672Up
User Ratings User Comments (3)  
 All time
Utility:66%StarStarStarStar
Consistency:75%StarStarStarStar
Documentation:-
Examples:50%StarStarStar
Tests:-
Videos:-
Overall:45%StarStarStar
Rank:2016
 
Super handy class, so easy to use.
2 years ago (John Drummer)
70%StarStarStarStar
wasted my time, got error.
2 years ago (Frank DeCicco)
2%Star
This is a very good and useful class ! :-D
2 years ago (Josť Filipe Lopes Santos)
70%StarStarStarStar