PHP Classes

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

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 64%Total: 2,529 All time: 1,522 This week: 57Up
Version License PHP version Categories
better-pdopagination 2.0Free To Use But R...5HTML, PHP 5, Databases
Description 

Author

Gilberto Albino

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

Recommendations

Pagination for content
Divide content into pages

Screenshots (1)  
  • screenshot.PNG
  Files folder image Files (5)  
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 (5)  /  libs  
File Role Description
Files folder imagePDO_Pagination (1 file)

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

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

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
Downloadbetter-pdopagination-2012-07-09.zip 36KB
Downloadbetter-pdopagination-2012-07-09.tar.gz 37KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,529
This week:0
All time:1,522
This week:57Up
User Ratings User Comments (4)
 All time
Utility:92%StarStarStarStarStar
Consistency:89%StarStarStarStarStar
Documentation:-
Examples:89%StarStarStarStarStar
Tests:-
Videos:-
Overall:64%StarStarStarStar
Rank:722
 
Have tried so many scripts but this class is really awesome f...
9 years ago (Daryl Stone)		70%StarStarStarStar
Good
9 years ago (Mostafa Elsayh)		70%StarStarStarStar
Good
9 years ago (Mostafa Elsayh)		70%StarStarStarStar
This is a good, useful and very organized class ! :-) Usualy...
12 years ago (José Filipe Lopes Santos)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

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