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: Working with PHP and MySQL

HowToForge.com: Installing Lighttpd With PHP5 And MySQL Support On OpenSUSE 11.1

Bshensky\'s LiveJournal: Oracle Support without a Recompile

Zend: Roll Your Own Search Engine with Zend_Search_Lucene

Asvin Balloo's Blog: Geolocate your visitors with PHP (part 2)


Community Events

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


introduction symfony opinion application language part2 laravel testing composer framework api yii2 example series list community podcast interview php7 project

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