SplitPageResult 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.
SplitPageResult 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).
More popular HTML
- 8.9 KB
- 10/23/2005 13:18:00