PHP Classes

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 64%Total: 2,525 This week: 1All time: 1,525 This week: 560Up
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.

Picture of Gilberto Albino
Name: Gilberto Albino <contact>
Classes: 5 packages by
Country: Brazil Brazil
Age: 43
All time rank: 55540 in Brazil Brazil
Week rank: 106 Up7 in Brazil Brazil Up

Recommendations

Pagination for content
Divide content into pages

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,525
This week:1
All time:1,525
This week:560Up
User Ratings User Comments (4)
 All time
Utility:92%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:-
Examples:89%StarStarStarStarStar
Tests:-
Videos:-
Overall:64%StarStarStarStar
Rank:714
 
Have tried so many scripts but this class is really awesome f...
8 years ago (Daryl Stone)
70%StarStarStarStar
Good
8 years ago (Mostafa Elsayh)
70%StarStarStarStar
Good
8 years ago (Mostafa Elsayh)
70%StarStarStarStar
This is a good, useful and very organized class ! :-) Usualy...
11 years ago (José Filipe Lopes Santos)
70%StarStarStarStar