Paginate your web pages with PHP and MySQL

A usual problem facing new Web Developers is how to split a Database query over several pages (paginate).  The example following is in a basic form so will not contain code or methods for content filtering or to allow dynamic options for the pagination but should give a good base to build from.

For this example we are going to use OOP and create a class.  This will enable an easy way to plug this code into existing database queries and to make it unobtrusive so that it can be modified and extended at any time.
Read more