News Feed
Sections




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

PHPBuilder.com:
Using the PEAR Pager Package to Paginate MySQL Results
April 13, 2011 @ 10:35:40

On PHPBuilder.com today there's a new tutorial about using the PEAR Pager package to paginate through results from a MySQL query. The package makes it easy to pass in a data set and handle the pagination requests and interface.

Fortunately a great solution [for paginating data] is at your disposal which has been created expressly for this purchase. The PEAR Pager package will not only handle all of the gory tracking details for you, but it can also create a linked navigation list which you can embed into the page as a navigational aide for the user. In this article I'll show you how to use Pager to easily paginate your database results in a structured and coherent way.

He walks you through installing the packaged (thankfully easy with the PEAR installer) and how to use it on a simple array dataset of college names. From there he moves into the database realm, creating a simple table that stores the same information and pulling the results out and into the Pager functionality.

0 comments voice your opinion now!
mysql paginate pear pager package tutorial


blog comments powered by Disqus

Similar Posts

Andrew Johnstone's Blog: Vagrant, Automating PHP/MySQL Installation with bash/slack

Stefan Mischook's Blog: PHP Sessions Video Tutorials - Part 1

AnyExample.com: Bar chart HTML generator

Internet Super Hero: PHP: mysqlnd can't do wonders

Eran Galperin's Blog: Multiple row operations in MySQL / PHP


Community Events

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


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

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