|Info||View files (1)||Download .zip||Reputation||Support forum||Blog|
|Last Updated||Ratings||Unique User Downloads||Download Rankings|
|2003-07-12 (11 years ago)||Not enough user ratings||Total: 557||All time: 4,924 This week: 1,597|
|splitpageresult 1.0||GNU General Public Lice...||Databases|
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).
|class_splitpage.php||Class||source code and example|
|Version Control||Unique User Downloads||Download Rankings|
|This week:||0||This week:||1,597|