PHP Classes

MySQL Pagination: Retrieve and display MySQL query split in pages

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 2,644 All time: 1,445 This week: 488Up
Version License PHP version Categories
paginationclass 1.0GNU General Publi...3HTML, Databases


This class can be used to retrieve and display MySQL query results and display them in multiple pages.

It can determines the number of rows returned by a query to calculate the total number of pages splitting the listing of records with a given limit per page.

The class can also generate a navigation bar with links to go to each of the listing pages.

It also executes the query returning an array with only the records to be displayed in a given listing page.

Picture of Alexandru Aliu
Name: Alexandru Aliu <contact>
Classes: 1 package by
Country: Romania Romania
Age: 44
All time rank: 119931 in Romania Romania
Week rank: 216 Up6 in Romania Romania Up

  Files folder image Files  
File Role Description
Accessible without login Plain text file class_rs.txt Doc. Short user manual for this class
Plain text file class_rs.php Class The source

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:1,445
This week:488Up