Paginating MySQL Data with PHP (
Page 1 of 5 )
Have a large MySQL dataset that you would like to display on your website, but
don't want to bog down your users' connections with large HTML renderings? Try
paginating your data.As a PHP and MySQL Developer I browse around many forums and one of the more
common questions being asked is 'How do I Add Next / Prev Links to my Pages?'.
Even I asked this very question a long time ago when I was beginning to learn
PHP. I decided to write this article because despite learning how to do this myself,
I never really found a decent article on the Internet that was geared more towards
a beginner and that was suitable for PHP Installations that are now configured
with Register Globals Off.
I have attempted to write an article that explains even the basic areas, that
walks through every line of the code explaining what it does and why it is there,
so this is what I have attempted to do with this article. Hopefully by the time
you reach the end you will feel confident enough to write your own code without
even using this article as a reference guide.
The article is based on a MySQL database and assumes a basic knowledge of constructing
SQL Queries. I will go through connecting and disconnecting from the database
and some other clauses and statements. This should be fairly easy to port to other
database platforms if required.
/ 47 
