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

DevShed: Using Static Methods to Validate Data with Helpers in PHP 5

Mike Willbanks's Blog: Building and Maintaining a PEAR Server with Pirum

Query7.com: Writing a module for Kohana3

Jason Grimes' Blog: Using Doctrine 2 in Zend Framework 2

Codewalkers.com: The PAVISE of Security


Community Events





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


podcast laravel code release unittest wordpress series library threedevsandamaybe configure api language install community introduction application interview homestead developer list

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