Databases: MySQL Pagination
Alexandru Aliu (contact me)
This class can be used to retrieve and display MySQL query results and display them in multiple pages.
It can determines the number of rows returned by a query to calculate the total number of pages splitting the listing of records with a given limit per page.
The class can also generate a navigation bar with links to go to each of the listing pages.
It also executes the query returning an array with only the records to be displayed in a given listing page.
Click here for detailed information about this class on phpclasses.org