PHP Classes

Paginations: Split MySQL query result listings

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 69%Total: 3,373 All time: 1,020 This week: 488Up
Version License PHP version Categories
paginations 1.0.0Freeware3.0HTML, Databases
Description 

Author

Reneesh T K

This class can be used to split MySQL database query listings between multiple pages.

It takes as parameters a SQL query, the limit number of result rows to display per page, and the number of the listing page being displayed.

The class executes the query to retrieve the results of the current page and stores the result handle in a class variable.

The class also generates HTML with links to go to the first, last, next, previous and any intermediate page of the listing.

It also generates HTML to display the current page being display and the total number of rows in the result set.

The links trigger the call of a Javascript function that will switch to the page associated with the link.

Picture of Reneesh T K
Name: Reneesh T K <contact>
Classes: 2 packages by
Country: India India
Age: 43
All time rank: 24715 in India India
Week rank: 195 Up19 in India India Down

Details

Developed by Reneesh T.K
[email protected]

You can use it with out any worries...It is free for you..It will display the out put like:

First | Previous | 3 | 4 | 5 | 6 | 7| 8 | 9 | 10 | Next | Last
Page : 7  Of  10 . Total Records Found: 20

Just pass the query ,records per page and starting from the page you want to display the pagination.

Advantage: It is connected to search process in the example and you may extend this feature as you like..It can also use in ajax by putting the contents of the javascript function in the ajaxfunction used for ajax.

You can see some useful functions in the site http://reneeshtk.000a.biz and if you interested you can donate some amount to me :)

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file readme Doc. readme
Accessible without login Plain text file testpage.php Example test page
Plain text file pagination_class.php Class class 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
Downloadpaginations-2010-05-13.zip 2KB
Downloadpaginations-2010-05-13.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,373
This week:0
All time:1,020
This week:488Up
User Ratings User Comments (4)
 All time
Utility:87%StarStarStarStarStar
Consistency:80%StarStarStarStarStar
Documentation:82%StarStarStarStarStar
Examples:92%StarStarStarStarStar
Tests:-
Videos:-
Overall:69%StarStarStarStar
Rank:352
 
Useful and straightforward.
14 years ago (Tom Carnevale)		65%StarStarStarStar
Very simple and easy to use :)
14 years ago (Denis Dantas Uyeda)		75%StarStarStarStar
A realy nice and valuable class for pagination Hats off reneesh
16 years ago (jobanjohn)		80%StarStarStarStarStar
Simple and good
17 years ago (bipin)		60%StarStarStarStar
 

  Applications that use this package  
Latest job openigs

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


  Related pages  
Latest job openigs