PHP Classes

SPA Simple Paging Class: Display MySQL query results split in pages

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 860 All time: 4,053 This week: 292Up
Version License PHP version Categories
phppaging 2.0GNU General Publi...5HTML, PHP 5, Databases
Description Author

This class can be used to display MySQL query results split in multiple Web pages.

It can take a given SQL query or the name of a table to be queried and computes the total number of results that it would return.

The class takes the limit of query results to display and the number of the current listing page, and returns the SQL query string with a limit clause to retrieve only the range of records that should be listed in the current page.

The class also generates links to browse between the different query results listing pages.

Picture of Prakash A Bhat
Name: Prakash A Bhat <contact>
Classes: 1 package by
Country: India India
Age: 45
All time rank: 2546152 in India India
Week rank: 595 Up44 in India India Up

  • screenshot.jpg
  Files folder image Files  
File Role Description
HTML file documentation.htm Doc. Documentation
Plain text file paging.class.php Class The Paging Class
Plain text file paging.css Aux. The CSS file for the paging class
Plain text file paging.php Example Paging Implemetation
Image file PagingClass2.jpg Photo Screenshot2

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:4,053
This week:292Up
User Comments (1)
Easy to implement into your existing code.
14 years ago (Mario Measor)
For more information send a message to info at phpclasses dot org.