PHP Classes

Split Result: Split MySQL query results between pages

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
StarStarStar 56%Total: 1,288 All time: 2,991 This week: 455Up
Version License Categories
splitresult 1.0GNU General Publi...HTML, Databases
Description 

Author

Gaidar

This class is meant to split the presentation of a MySQL database query results between multiple pages.

The class takes a MySQL query result set handler value and generate navigation HTML links between pages of result pages given the limit number of query result rows to display, the number of rows in the result set and the number of the current results page to display.

Picture of Gaidar
Name: Gaidar <contact>
Classes: 1 package by
Country: Russian Federation Russian Federation
Age: ???
All time rank: 202959 in Russian Federation Russian Federation
Week rank: 227 Up15 in Russian Federation Russian Federation Up

Details


Description
===========

SplitRerult is a very simple, but easy to use splitter class for MySQL
server database. It works with all server's versions.
Look through the sample to found out how to use the class. 


Sample
======

To use included sample create mysql database, name it, for instance,
'test_db'. (If you decide to use another names, correct $mysql_db in
'config.php')

	mysqladmin create test_db

Correct config.php to match your system configuration. 
After that, install data using mysql client. Like that:

	mysql test_db < mysql_db.sql

Copy files to your web-server directory and point your browser to 
file usage.php.

	http://yourhost/usage.php

Enjoy!


Author
======

Gaidar Magdanurov [gaidar@vbstreets.ru]
ICQ: 167656859

  Files folder image Files (5)  
File Role Description
Accessible without login Plain text file config.php Conf. Configuration file for the sample.
Accessible without login Plain text file mysql_db.sql Data SQL data
Accessible without login Plain text file README.TXT Doc. Documentation
Plain text file split_result.php Class SplitResult class
Accessible without login Plain text file usage.php Example Example of using SplitResult

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
Downloadsplitresult-2005-07-31.zip 2KB
Downloadsplitresult-2005-07-31.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,288
This week:0
All time:2,991
This week:455Up
 User Ratings  
 
 All time
Utility:67%StarStarStarStar
Consistency:71%StarStarStarStar
Documentation:82%StarStarStarStarStar
Examples:71%StarStarStarStar
Tests:-
Videos:-
Overall:56%StarStarStar
Rank:1815
  

  Applications that use this package  
No pages of applications that use this class were specified.

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