1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / gceburdwan / public_html / Online_Admission / studentpoint /
Filename : pagination.php
back
<?php
/**
 * @author Jooria Refresh Your Website <www.jooria.com>
 * @copyright 2010
 */
function Pages($tbl_name,$limit,$path,$conn)
{
	$query = "SELECT COUNT(*) as num FROM $tbl_name ".$conn;
	$row = mysql_fetch_array(mysql_query($query));
	$total_pages = $row['num'];
	$adjacents = "2";
	$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
	$page = ($page == 0 ? 1 : $page);
	if($page)
	$start = ($page - 1) * $limit;
	else
	$start = 0;
$sql = "SELECT id FROM $tbl_name LIMIT $start, $limit";
$result = mysql_query($sql);
	$prev = $page - 1;
	$next = $page + 1;
	
	$lastpage = ceil($total_pages/$limit);
	$lpm1 = $lastpage - 1;
	$pagination = "";
if($lastpage > 1)
{   
	$pagination .= "<div class='pagination'>";
if ($page > 1)
	$pagination.= "<a href='".$path."page=$prev'><font  style=font-size:14px><< </font> previous</a>";
else
	$pagination.= "<span class='disabled'><font  style=font-size:14px><< </font> previous</span>";   
if ($lastpage < 7 + ($adjacents * 2))
{   
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
	$pagination.= "<span class='current'>$counter</span>";
else
	$pagination.= "<a href='".$path."page=$counter'>$counter</a>";                   
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
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='".$path."page=$counter'>$counter</a>";                   
}
	$pagination.= "...";
	$pagination.= "<a href='".$path."page=$lpm1'>$lpm1</a>";
	$pagination.= "<a href='".$path."page=$lastpage'>$lastpage</a>";       
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
	$pagination.= "<a href='".$path."page=1'>1</a>";
	$pagination.= "<a href='".$path."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='".$path."page=$counter'>$counter</a>";                   
}
	$pagination.= "..";
	$pagination.= "<a href='".$path."page=$lpm1'>$lpm1</a>";
	$pagination.= "<a href='".$path."page=$lastpage'>$lastpage</a>";       
}
else
{
	$pagination.= "<a href='".$path."page=1'>1</a>";
	$pagination.= "<a href='".$path."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='".$path."page=$counter'>$counter</a>";                   
}
}
}
if ($page < $counter - 1)
	$pagination.= "<a href='".$path."page=$next'>next  <font  style=font-size:14px>>> </font></a>";
else
	$pagination.= "<span class='disabled'>next  <font  style=font-size:14px>>> </font> </span>";
	$pagination.= "</div>\n";       
}
return $pagination;
}
?>