Home arrow PHP arrow Paginating MySQL Data with PHP

Paginating MySQL Data with PHP

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.

  1. Paginating MySQL Data with PHP
  2. Getting Started
  3. Making a Connection
  4. Limiting the Dataset
  5. Conclusion
By: Adrian Portsmouth
Rating: starstarstarstarstar / 53
March 27, 2003

print this article


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.

>>> More PHP Articles          >>> More By Adrian Portsmouth

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: