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

Sameer Borate: Sentiment Analysis of Twitter feeds

Internet.com: Plotting Map Markers Dynamically Using the Google Maps API, jQuery, PHP, and MySQL

PEAR Blog: PEAR 1.9.5 is out

Jani Hartikainen's Blog: Refactoring explained to an absolute beginner

David Coallier's Blog: PEAR is using jQuery et new features


Community Events





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


language release introduction list series install deployment zendserver podcast api interview opinion package laravel update tips framework library symfony community

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