PHP Classes

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

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
StarStarStar 48%Total: 861 All time: 4,066 This week: 455Up
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

 

Screenshots (1)  
  • screenshot.jpg
  Files folder image Files (6)  
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

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
 Version Control Unique User Downloads Download Rankings  
 0%
Total:861
This week:0
All time:4,066
This week:455Up
User Ratings User Comments (1)
 All time
Utility:58%StarStarStar
Consistency:58%StarStarStar
Documentation:75%StarStarStarStar
Examples:58%StarStarStar
Tests:-
Videos:-
Overall:48%StarStarStar
Rank:2984
 
Easy to implement into your existing code.
17 years ago (Mario Measor)
80%StarStarStarStarStar