Login   Register  
PHP Classes
elePHPant
Icontem

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

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   Screenshots Screenshots   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2008-02-10 (6 years ago) RSS 2.0 feedNot enough user ratingsTotal: 832 All time: 3,821 This week: 1,459Up
Version License PHP version Categories  
phppaging 2.0GNU General Public Lice...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: 37
All time rank: 2335147 in India India
Week rank: 1862 Up135 in India India Up

Screenshots  
  • 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  
 0%Total:832All time:3,821
 This week:0This week:1,459Up
 User Comments (1)  
 
Easy to implement into your existing code.
6 years ago (Mario Measor)
80%StarStarStarStarStar