display records page wise PHP code I got it

[kashif farooq]

// display records page wise code starts:

$adjacents = 3;
$tbl_name="feedback";

//	$display = "SELECT COUNT(*) as num FROM $tbl_name";

$display = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($display));
$total_pages = $total_pages[num];

/* Setup vars for query. */

$targetpage = "dispfeed.php"; 	//your file name  (the name of this file)
$limit = 5; 			//how many items to show per page
$page = $_GET['page'];

if($page) 
	$start = ($page - 1) * $limit; //first item to display on this page
else
	$start = 0;		//if no page var is given, set start to 0

/* Get data. */
//	$sql = "SELECT column_name FROM $tbl_name LIMIT $start, $limit";

$display = "SELECT * FROM $tbl_name order by id desc LIMIT $start, $limit";
$rs = mysql_query($display);
	
/* Setup page vars for display. */
if ($page == 0) $page = 1;		//if no page var is given, default to 1.
$prev = $page - 1;			//previous page is page - 1
$next = $page + 1;			//next page is page + 1
$lastpage = ceil($total_pages/$limit);	//lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1;		//last page minus 1
	
/* 
	Now we apply our rules and draw the pagination object. 
	We're actually saving the code to a variable in case we want to draw it more than once.
*/

$pagination = "";
if($lastpage > 1)
{	
	$pagination .= "<div class=\"pagination\">";

	//previous button
	if ($page > 1) 
//		$pagination.= "<a href=\"$targetpage?page=$prev\">« previous</a>"; (if display by asc...)
		$pagination.= "<a href=\"$targetpage?page=$prev\">« NEXT</a>";
	else
//		$pagination.= "<span class=\"disabled\">« previous</span>"; (if display by asc...)
		$pagination.= "<span class=\"disabled\">« NEXT</span>";	


	//pages

	if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page)
				$pagination.= "<span class=\"current\">$counter</span>";
			else
				$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
		}
	}

	elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
	{
		//close to beginning; only hide later pages
		if($page < 1 + ($adjacents * 2))		
		{
			for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
			}
			$pagination.= "...";
			$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
			$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
		}
		//in middle; hide some front and some back

		elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
		{
			$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
			$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
			$pagination.= "...";
			for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
			$pagination.= "...";
			$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
			$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
		}
		//close to end; only hide early pages
		else
		{
			$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
			$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
			$pagination.= "...";
			for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
		}
	}
		
	//next button
	if ($page < $counter - 1) 
//		$pagination.= "<a href=\"$targetpage?page=$next\">next »</a>"; (if display by asc...)
		$pagination.= "<a href=\"$targetpage?page=$next\">PREV »</a>";
	else
//		$pagination.= "<span class=\"disabled\">next »</span>"; (if display by asc...)
		$pagination.= "<span class=\"disabled\">PREV »</span>";

	$pagination.= "</div>\n";		
}

// display records page wise code ends:

//to display record with in table from db:

if (mysql_num_rows($rs)>0)
{

	while($row=mysql_fetch_array($rs))
	{

[kashif farooq]

For This Display Code of PHP Pagewise this is the Style sheet file please note it carefully:

div.pagination {padding: 1px;margin: 1px;}
div.pagination a {padding: 1px 2px 1px 2px; margin: 1px; border: 1px solid #AAAADD; text-decoration: none; font-size: 12px; color: #000099;}

div.pagination a:hover, div.pagination a:active {border: 1px solid #000099; color: #000;}

div.pagination span.current {padding: 1px 2px 1px 2px; margin: 1px; border: 1px solid #000099; font-weight: bold; font-size: 12px;background-color: #000099;color: #FFF;}

div.pagination span.disabled {padding: 1px 2px 1px 2px;margin: 1px;border: 1px solid #EEE;font-size: 12px;color: #DDD;}

[kashif farooq]

There are tons of pages, I'm not in favor of the display page numbers in PHP like that << <1 2 3 4.... 100 > >>. I like the drop down menu for page numbers, next page previous link, and Pages 1 2 3 ... 10 are in a drop down menu, and a list of page titles that is: 10 records per page, 20 records per page, should also be shown in drop down menu...

Please follow this link for help and see the paged results in PHP : http://computer-tricks.net/how-to-paginate-data-with-php

and

http://net.tutsplus.com/tutorials/php/how-to-paginate-data-with-php/

CAN U DO IT... FOR ME... REPLY AT: kashiffarooq_5 @ hotmail . com

[dineshkumar R]

this is very useful to me....