Login   Register  
PHP Classes
elePHPant
Icontem

SplitPageResult: Splitting pages in Interbase/non MySQL DB

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2003-07-12 (11 years ago) RSS 2.0 feedNot enough user ratingsTotal: 558 All time: 4,983 This week: 1,428Up
Version License Categories  
splitpageresult 1.0GNU General Public Lice...Databases
Description Author  

This is a class for splitting Interbase/Firebird/non MySQL database query results in multiple pages.

As you may know, with the 'LIMIT' clause supported in MySQL SQL syntax, it is easy to paginate data. Since other databases do not support this clause, it is difficult to split large query result sets.

This class uses a loop to skip result set rows according to the number of the that is specified, so you can get the desire result set rows.

If your database is not Interbase, the class may also be used just by making a litte modification (it only uses PHP standard database functions of your DB to change ibase_query, ibase_fetch_row, ibase_fetch_object).

Picture of Kelvin Ma
Name: Kelvin Ma <contact>
Classes: 1 package by
Country: Canada Canada
Age: ???
All time rank: 282564 in Canada Canada
Week rank: 1763 Up39 in Canada Canada Up

  Files folder image Files  
File Role Description
Plain text file class_splitpage.php Class source code and example

 Version Control Unique User Downloads Download Rankings  
 0%Total:558All time:4,983
 This week:0This week:1,428Up