This class can be used to split MySQL database query listings between multiple pages.
It takes as parameters a SQL query, the limit number of result rows to display per page, and the number of the listing page being displayed.
The class executes the query to retrieve the results of the current page and stores the result handle in a class variable.
The class also generates HTML with links to go to the first, last, next, previous and any intermediate page of the listing.
It also generates HTML to display the current page being display and the total number of rows in the result set.
The links trigger the call of a Javascript function that will switch to the page associated with the link. |
