Introduction

In this tutorial I will show you how to create your own paging system for a MySQL database table using PHP. You will learn how to have a list of pages automatically generated from the total row count on your table based on the limit of results to be displayed per page.

There are many reasons why someone would want to do this and the most common one is to simply lessen the load on their database by not calling every row in one shot because if your database table has more than 100 rows this can be a large strain on the server. Say that you have 10 people calling the same page that returns all of the 100 rows from the database table; this is the same as calling 1,000 rows at once, now you see the problem.

Prerequisites
If you are here I am assuming you have a fair to moderate understanding of PHP and MySQL

discuss this topic to forum