News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

PHPFreaks.com:
Basic Pagination
June 19, 2008 @ 08:47:56

A new tutorial has been posted on the PHPFreaks.com site today dealing with paginating your data (in their example, info from a database).

It makes way more sense to break up your list into page-sized chunks, and only query your database one chunk at a time. This drastically reduces server processing time and page load time, as well as gives your user smaller pieces of info to digest, so he doesn't choke on whatever crap you're trying to feed him. The act of doing this is called pagination.

They include the full script for those that want to jump right in and the detailed info in the rest of the tutorial for those that need a little more insight. The script gets a count of the results first then uses the LIMIT format for MySQL to restrict the number of rows returned each time and where to start those returned rows from.

1 comment voice your opinion now!
pagination tutorial mysql database limit


blog comments powered by Disqus

Similar Posts

PHPMaster.com: Automatic CSS3 Prefixer and Compressor

HowTo Forge: Fedora 8 Server Setup - LAMP, Email, DNS, FTP, ISPConfig - Page 6

SitePoint PHP Blog: Getting Started with Laravel on Nitrous.io

PacktPub.com: Develop PHP Web Applications with NetBeans, VirtualBox and Turnkey LAMP Appliance

Vid Luther's Blog: Installing the PHP SSH2 extension in Snow Leopard (10.6)


Community Events

Don't see your event here?
Let us know!


laravel framework community extension series introduction php7 install conference podcast performance api release symfony2 interview opinion library version voicesoftheelephpant example

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework