paging using php
<?
//pagging info
// how many rows to show per page
$rowsPerPage = 2;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
//here u can see the $offset, $rowsPerPage is used to control the result
$chkCat = "SELECT * FROM `complaint_category` WHERE `pid` = 0 LIMIT $offset, $rowsPerPage";
$chkCatExe = mysql_query("$chkCat");
// how many rows we have in database
$query = "SELECT * FROM `complaint_category` WHERE `pid` = 0";
$result = mysql_query($query);
$row = mysql_num_rows($result);
$numrows = $row ;
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
$maxPage = 50;
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$nav = '';
$maxPageNext = $pageNum + 5;
$maxPageBefore = $pageNum - 5;
$nav = "$pageNum ";
for($page = $pageNum+1; $page <= $maxPageNext; $page++)
{
if($page <= $maxPage)
{
$navafter .= " <a href=\"$self?page=$page\" class=\"PrevNext\">$page</a> ";
}
}
for($page = $pageNum-5; $page < $pageNum; $page++)
{
if($page >= 1)
{
$navbefore .= " <a href=\"$self?page=$page\" class=\"PrevNext\">$page</a> ";
}
}
$nav = $navbefore . $nav . $navafter ;
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\" class=\"activePrevNext\">[Prev]</a> ";
$first = " <a href=\"$self?page=1\" class=\"activePrevNext\">[First Page]</a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\" class=\"activePrevNext\">[Next]</a> ";
$last = " <a href=\"$self?page=$maxPage\" class=\"activePrevNext\">[Last Page]</a> ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
echo $first . $prev . $nav . $next . $last;
?>
See the above code i am uisng php for pagging.
Here u can see how php is used to display the pagging all the lines are well comneted to see demo please click pagging using php
