Code Examples -> Paginator - a class that can help you to split MySQL database query result sets to pages.

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Resources
	Web Development Content
	Internet Security Software

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	Paginator - a class that can help you to split MySQL database query result sets to pages.
Categories :	MySQL, Databases, HTML, PHP	Ted Kappes
Date :	Jul 31st 2003
Grade :	2 of 5 (graded 7 times)
Viewed :	9398
File :	3707.zip
Images :	No Images for this code example.

Search :	More code by Ted Kappes
Action :	Grade This Code Example
Tools :	My Examples List

Code

Examples and documentation is in the download.
Paginator is a class that can help you to split MySQL database query result sets to pages.

Paginator will return a number that can be used to set your start result row and a number to use as
an offset.

The class methods return values that you can use to create your navigation links. The values it
presently returns are:

* First of in a series
* Second of in a series
* Total items in a series
* Total Pages
* First page
* Last page
* Previous page
* Next page
* Current page
* A set of numbered links
* The name of the current page.

There is also Paginator_html which is an extension to the Paginator class. It includes methods that
supply a pre-defined HTML links like in these examples:

5 of 8 of 25 First | Prev | Next | Last |

Previous 1 2 3 4 5 6 7 Next

Related Code Examples

	Newbie Notes #10 - Generating drop downs Categories : PHP, MySQL, HTML, Beginner Guides, Databases
	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	color codes for positive and negative numbers Categories : PHP, MySQL, Databases, HTML
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	Mimic ASP's GetString function with PHP Categories : PHP, Databases, MySQL, Strings
	Data Retrieve from Mysql using AJAX with PHP Categories : PHP, AJAX, Date Time, Databases, MySQL
	Simple PHP Form Auto Generation based on MySQL query Categories : PHP, Form Processing, Databases, MySQL, Sessions
	Implementing a Members ONLY area Categories : PHP, MySQL, Databases, Authentication
	This functions makes it easy to use session-variables known from ASP. With one Cookie the array "session" will save and restore from a db-record. In this version MySQL is used but it's should very easy to change Categories : PHP, Arrays, Cookies, MySQL, Databases
	Making a simple Hit-Log using PHP and MySql Categories : PHP, Log Files, Beginner Guides, Databases, MySQL
	Database resultset navigation Categories : PHP, HTML and PHP, Databases, MySQL, Navigation
	complete, simple, working example of a login screen/system using php functions, cookies, and a mysql database for begginers. Categories : Authentication, Complete Programs, PHP, MySQL, Databases
	A Simple Script to randomly select a CSS from MySQL Categories : PHP, Databases, MySQL, CSS
	MySQL or SQL Query to XML Output Categories : PHP, MySQL, XML, Databases
	Building dynamic menus with PHP & MySQL (ADO), JavaScript and CSS Categories : PHP, Databases, MySQL, Java Script, User Interface

User Comments

	kenji wrote : 1000 I`d love to see this. Is there any chance of fixing the download?
	Ted Kappes wrote : 1001 `If you are having trouble downloading from here you can try from here: www.tkap.org/paginator/download1.php`
	Boaz Yahav wrote : 1002 `What is wrong with the download? it seems to work fine for me.`
	Tim Morton wrote :1003 Absolutely wonderful! I can`t wait to retrofit some of my pages-- this is well thought out and quite flexible. Thank you for sharing this :)