PHP Classes

File: mySQL.txt

Recommend this page to a friend!
  Classes of ted kappes   Paginator   mySQL.txt   Download  
File: mySQL.txt
Role: Documentation
Content type: text/plain
Description: mySQL Instructions
Class: Paginator
Spliting database query result sets between pages.
Author: By
Last change:
Date: 19 years ago
Size: 2,002 bytes


Class file image Download
Using Paginator with mySQL Paginator works very well with Mysql. You can easily use the base record and the offset with LIMIT. Paginator comes with an extension, Paginator_html, that at the moment provides a couple of pre-made link sets. To divide mySQL result sets into pages you may do the following. I assume you have made a connection to your database. Include the Paginator class. include("include/paginator.php"); If you are using Paginator_html include that also. include("include/paginator_html.php"); Make a query to get the number of rows in your database. You might use something like this. $num_rows = mysql_result(mysql_query("SELECT COUNT(*) FROM your table"),0); Make a new Paginator object $a =& new Paginator($_GET['page'],$num_rows); If you are using Paginator_html make a new new Paginator_html object instead of a Paginator object. $a =& new Paginator_html($_GET['page'],$num_rows); Set the number of records to be displayed $a->set_Limit(4); If using numbered links this will set the number before and behind the current page. $a->set_Links(3); Get the starting point. $limit1 = $a->getRange1(); Get the number of items displayed on page. $limit2 = $a->getRange2(); Make your query using LIMIT $result=mysql_query("SELECT * FROM your table LIMIT $limit1, $limit2"); Output your results in your preferred manner If you are using Paginator alone you will need to create your links here using the methods from Paginator. See example3.php, example4.php. If you are using Paginator_html you add the methods to add your links here $a->firstLast(); Will make a set of links like this: 5 of 8 of 25 First | Prev | Next | Last | $a->previousNext(); Will make a set of links like this: Previous 1 2 3 4 5 6 7 Next