Better PDO Pagination: Display pagination links for SQL queries using PDO

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (4)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 69%Total: 2,509 All time: 1,520 This week: 247Up
Version License PHP version Categories
better-pdopagination 2.0Free To Use But R...5HTML, PHP 5, Databases
Description Author

This class can display pagination links for SQL queries using PDO.

It takes a PDO object with database connection already opened and a SQL query as parameters to count the total number of result set rows.

The class can generate HTML links to browse the between the pages of the listing of results assuming a given the number of the current page, the limit number of results to display per page and a limit number of result page browsing links.

Recommendations

Pagination for content
Divide content into pages

Picture of Gilberto Albino
Name: Gilberto Albino <contact>
Classes: 5 packages by
Country: Brazil Brazil

Screenshots  
  • screenshot.PNG
  Files folder image Files  
File Role Description
Files folder imagelibs (1 directory)
Files folder imagetest (1 file)
Accessible without login HTML file demo.html Data Try a demo online
Accessible without login Plain text file database.sql Data The database SQL for mysql used in the test

  Files folder image Files  /  libs  
File Role Description
Files folder imagePDO_Pagination (1 file)

  Files folder image Files  /  libs  /  PDO_Pagination  
File Role Description
  Plain text file Pdo_pagination.php Class Main class

  Files folder image Files  /  test  
File Role Description
  Accessible without login Plain text file index.php Example Test file

 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,509
This week:0
All time:1,520
This week:247Up
User Ratings User Comments (4)
 All time
Utility:100%StarStarStarStarStarStar
Consistency:95%StarStarStarStarStar
Documentation:-
Examples:95%StarStarStarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:475
 
Have tried so many scripts but this class is really awesome f...
4 years ago (Daryl Stone)
70%StarStarStarStar
Good
4 years ago (Mostafa Elsayh)
70%StarStarStarStar
Good
4 years ago (Mostafa Elsayh)
70%StarStarStarStar
This is a good, useful and very organized class ! :-) Usualy...
8 years ago (José Filipe Lopes Santos)
70%StarStarStarStar
 

For more information send a message to info at phpclasses dot org.