PHP Classes

Classes of Kelvin Ma

Recommend this page to a friend!
  All class groups  >  All authors  >  Classes of Kelvin Ma (1)  >  Mission progress status  >  Reputation  
Picture of Kelvin Ma
Name: Kelvin Ma <contact>
Classes: 1
Country: Canada Canada
Age: ???
All time rank: 313467 in Canada Canada
Week rank: 195 Up5 in Canada Canada Up
All time users: 569
Week users: 0
 
  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  
  Files folder image SplitPageResult  
Splitting pages in Interbase/non MySQL DB
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).


  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z