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.
|Case Study: Handling MySQL Growth With a PHP Class|
Categories : Databases, MySQL, PHP
|PHP, MySQL and Authentication 101|
Categories : PHP, Databases, MySQL, Authentication
|Building A Persistent Shopping Cart With PHP and MySQL|
Categories : PHP, MySQL, Databases, Ecommerce
|Practical Date and Time examples with PHP and MySQL|
Categories : Databases, MySQL, PHP, Date/time
|Simple Connection to MySQL with PHP|
Categories : PHP, MySQL, Databases
|Alternating row colors with PHP and mySQL|
Categories : PHP, Databases, MySQL, HTML and PHP
|Miles To Go Before I Sleep...|
Categories : PHP, Calendar, Databases, MySQL
|Multicolumn Output from a Database with PHP|
Categories : PHP, Databases, HTML and PHP, MySQL
|Date Arithmetic With MySQL|
Categories : PHP, Databases, MySQL, Date Time
|Time Is Money Part 1 of 2 - Designing and implementing a Web-based application|
Categories : PHP, Databases, MySQL, Complete Programs
|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