Code Examples -> Database resultset navigation

	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 :	Database resultset navigation
Categories :	PHP, HTML and PHP, Databases, MySQL, Navigation	Olaf Lederer
Date :	Dec 03rd 2005
Grade :	2 of 5 (graded 3 times)
Viewed :	15995
File :	No file for this code example.
Images :	No Images for this code example.

Search :	More code by Olaf Lederer
Action :	Grade This Code Example
Tools :	My Examples List

Code

Use this small function to create page links for your (MySQL) database resultset. This PHP function is all you need to create forward / backward links (paging) for the records in a database resultset. The setup is very easy, just call the function at the place where the links to have appear. Then create a variable for the current limit inside your SQL and create a variable with the total number of records in your resultset. The function takes care about an existing query string and creates the whole html code you need for the page navigation.

<?php
// example variable
$sql_limit = (isset($_GET['limit'])) ? $_GET['limit'] : 0;

function navigation_links($curr_limit, $num_records, $limit_val, $limit_var = "limit", $next = "next >", $prev = "< prev", $seperator = "|") {
// rebuild query string
if (!empty($_SERVER['QUERY_STRING'])) {
$parts = explode("&", $_SERVER['QUERY_STRING']);
$newParts = array();
foreach ($parts as $val) {
if (stristr($val, $limit_var) == false) array_push($newParts, $val);
}
$qs = (count($newParts) > 0) ? "&".implode("&", $newParts) : "";
} else {
$qs = "";
}
$navi = "";
if ($curr_limit > 0) {
$navi .= "<a href=\"".$_SERVER['PHP_SELF']."?".$limit_var. "=".($curr_limit-$limit_val).$qs."\">".$prev."</a>";
}
$navi .= " ".$seperator." ";
if ($curr_limit < ($num_records-$limit_val)) {
$navi .= "<a href=\"".$_SERVER['PHP_SELF']."?".$limit_var. "=".($curr_limit+$limit_val).$qs."\">".$next."</a>";
}
return trim($navi, " | ");
}

// example placing links ($num_all is the value of all records in you result set)
echo navigation_links($sql_limit, $num_all, 10);
?>

Related Code Examples

	Record Set Paging with PHP (RSP) Categories : PHP, MySQL, Navigation, Databases, HTML and PHP
	Paginating the mySQL data Categories : PHP, Algorithms, Databases, MySQL, HTML and PHP
	Required form fields that pull from MySQL database Categories : PHP, HTML and PHP, Databases, MySQL
	Storing / Retrieving pictures from database This can be used for banner / ads exchange. very useful for people developing big portal with ads in the site........ Categories : PHP, MySQL, Databases, HTML and PHP
	Editing the virtusertable and sendmail.cw via PHP3.0 and Mysql Categories : MySQL, HTML and PHP, PHP, Databases
	Powerful php/mysql Pagination for up to 6 URL Params Categories : PHP, PHP Classes, Databases, MySQL, Navigation
	This function will populate the options in a drop down HTML select list in a form from a database query. Categories : MySQL, General SQL, PHP, HTML and PHP, Databases
	PHP and MySQL scripting for Muyltiple CheckBoxes Categories : HTML and PHP, MySQL, Databases, PHP
	html split bar used to split in multiple pages a database result Categories : HTML and PHP, Databases, MySQL, PHP
	This program will take data from a user via a web based form, validate it, show it to the user for re-validation, and finally insert it into the database. Plenty of sanity checking on the fields in the form. Categories : MySQL, HTML and PHP, PHP, Complete Programs, Databases
	Automatically printing the contents of an sql table in MySQL. Categories : MySQL, PHP, HTML and PHP, Databases
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL
	How can i Preload a 'SELECT MULTIPLE'? Categories : HTML and PHP, PHP, MySQL, Databases
	dynamic table columns Categories : PHP, HTML and PHP, Arrays, Databases, MySQL