Pagination in php

[jagadeesh]

When we have a large list of items, we can display them grouped in pages and presents navigational elements to move from one page to another. This code creates a pagination for listing the page per 10 records.

<?php

$con = mysql_connect('localhost','ramakrishnan','raman') or die(mysql_error()); ;
mysql_select_db('rama_db',$con) or die(mysql_error()); ;

$page = $_REQUEST['page'];
if($page == "" || $page == null ) {
$page = 1;
} else {
$page = $page;
}

//setting the limit for fetching the records.
$per_page_limit = 10;
if($page >1) {
$start_limit = ($page-1)*$per_page_limit;
} else {
$start_limit = 0;
}

//getting the records by limits
$query = "SELECT id, name, qualification FROM emplouee WHERE salary > 10000 ORDER by salary LIMIT " .$start_limit. ','.$per_page_limit;
$results=mysql_query($query);
print_r($results);
$num_rows = mysql_num_rows($results);
while($row=mysql_fetch_array($results))
{
echo "<div class = 'emp_id'>";
echo $row['id'];
echo "</div>";
echo "<div class = 'emp_name'>";
echo $row['name'];
echo "</div>";
echo "<div class = 'emp_qualify'>";
echo $row['qualification'];
echo "</div>";
}
<!-- pagination for listing posts/articles-->

$myabsoluteurl = "http://" . $_SERVER['HTTP_HOST']."/your foldername";

if($num_rows > 0)
{
$start=1;
$prev = $page - 1; //previous page is page - 1
$next = $page + 1;
$total_page=ceil($$num_rows/$per_page_limit);
$lastpage=$total_page;


if($total_page > 1) {
echo "<div class='pagination'>";
//start page
if($page == 1)
echo "<span>«« Start</span>".' ';
else
echo '<a href="'.$url.$start.'" >«« Start</a>'.' ';

//previous page
if ($page > 1)
echo '<a href="'.$url.$prev.'" >« Previous</a>'.' ';
else
echo "<span>« Previous</span>".' ';

for($i=1; $i<=$total_page; $i++) {
if($i == $page)
echo "<span>[".$i."]</span>";
else
echo '<a href="'.$url.$i.'">['.$i.']</a>'.' ';
}


if ($page < $lastpage)
echo '<a href="'.$url.$next.'" >Next » </a>'. ' ';
else
echo "<span>Next » </span>".' ';


//last page start
if($page != $total_page)
echo '<a href="'.$url.$lastpage.'">Last »» </a>'.' ';
else
echo "<span>Last »» </span>".' ';
//last page end
echo "</div>";
}
}
?>