pagination
Posted: Tue Mar 13, 2007 1:51 pm
How to do to output table with default row by pagination. I have done it but it'snot exactly
Code: Select all
<?php
db_connect();
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$query = "SELECT rc_student FROM student ";
$result = mysql_query($query)or die(mysql_error);
$numrows = mysql_numrows($result);
for($i =0;$i<$numrows;$i++){
$rc = mysql_result($result,$i,"rc_student");
echo "<table><tr><td>$rc</td></tr></table>";
}
echo $numrows;
$rows_per_page = 5;
$lastpage = ceil($numrows/$rows_per_page);
echo $lastpage;
$pageno = (int)$pageno;
if ($pageno < 1) {
$pageno = 1;
} elseif ($pageno > $lastpage) {
$pageno = $lastpage;
} // if
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
$query = "SELECT * FROM student $limit";
$result = mysql_query($query) or die(mysql_error());
if ($pageno == 1) {
echo " FIRST PREV ";
} else {
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1'>FIRST</a> ";
$prevpage = $pageno-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage'>PREV</a> ";
} // if
echo " ( Page $pageno of $lastpage ) ";
if ($pageno == $lastpage) {
echo " NEXT LAST ";
} else {
$nextpage = $pageno+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage'>NEXT</a> ";
echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage'>LAST</a> ";
} // if
?>