As PHP developers, we can develop pretty much anything that we can think of: database driven sites, complete GUI applications with PHP-GTK, XML based representations of our data, chat applications, search engines, etc.
To create applications like those mentioned above we need a diverse range of tools in our toolkit. By tools, I mean pieces of code or programs that help us develop these applications quicker and easier, such as classes, functions, IDE's and the like. One handy class that I always keep in my PHP toolbox is my custom MySQL recorset paging class, which I developed about 5 months ago. Time and time again I've found myself using this class to develop web sites for my clients, and today I'm going to show you how I created the class.
In this article we're going to work through a step-by-step format to create a highly generic, customizable MySQL recordset paging class with PHP. The class accepts custom queries and options such as the layout of the results and the number of results per page can be changed easily.
To work with the class we're about to create, you should have PHP and MySQL installed on either a Windows or Linux PC. You should also have intermediate knowledge of PHP, regular expressions and MySQL.
|Time Is Money Part 1 of 2 - Designing and implementing a Web-based application|
Categories : PHP, Databases, MySQL, Complete Programs
|Date Arithmetic With MySQL|
Categories : PHP, Databases, MySQL, Date Time
|PHP and MySQL News with Comments|
Categories : PHP, Databases, MySQL
|User identification using cookies in PHP and MySQL|
Categories : PHP, Databases, MySQL, Cookies
Categories : Databases, MySQL, PHP, PHP Functions
|Saving Images in MySQL|
Categories : MySQL, PHP, Graphics, Databases
|Watching The Web|
Categories : PHP, Databases, MySQL, HTTP, MD5
|How To add paging (Pagination) with PHP and MySQL|
Categories : PHP, Beginner Guides, Databases, MySQL, HTML and PHP
Categories : PHP, MySQL, HTTP, Databases
|Beginners guide to PHP and MySQL|
Categories : PHP, Beginner Guides, Databases, MySQL, Installation
|Descriptions of Common Data Types|
Categories : MySQL, Databases, PHP, PHP options/info, General
|Creating an IE-Only Database Driven Menu System With PHP, MySQL and DHTML|
Categories : PHP, MySQL, Databases, DHTML
|Building A Persistent Shopping Cart With PHP and MySQL|
Categories : PHP, MySQL, Databases, Ecommerce
|Case Study: Handling MySQL Growth With a PHP Class|
Categories : Databases, MySQL, PHP
|PHP, MySQL and Authentication 101|
Categories : PHP, Databases, MySQL, Authentication