paging

[chelvan]

hi
all
its me again

on my displaying page, i want to limit the records to display on it. and display the link to go next pages to view the balance.

is it possible?

thanks in advance.




chel--1

[maheswaran]

ya its possible, try limit in ur query according to ur page index.


see this

http://www.plus2net.com/php_tutorial/php_paging.php

[chelvan]

hi all
thanks.......

i got it.....

<?php
 
$rowsPerPage = 3;
 
$pageNum = 1;
if(isset($_GET['page']))
{
    $pageNum = $_GET['page'];
}
 
 
$offset = ($pageNum - 1) * $rowsPerPage;
 
$query = " SELECT * FROM user " .
         " LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
 
while($row = mysql_fetch_array($result))
{
 // reading database
}
 
echo "<table align='center' border='0'>";
//printing
echo "</table>";
 
 
$query   = "SELECT COUNT(refno) AS numrows FROM myfriends WHERE refno='$refno'";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
 
$maxPage = ceil($numrows/$rowsPerPage);
 
 
$self = $_SERVER['PHP_SELF'];
$nav  = '';
 
for($page = 1; $page <= $maxPage; $page++)
{
   if ($page == $pageNum)
   {
      $nav .= " $page "; // no need to create a link to current page
   }
   else
   {
      $nav .= " <a href=\"$self?page=$page\">$page</a> ";
   } 
}
 
if ($pageNum > 1)
{
   $page  = $pageNum - 1;
   $prev  = " <a href=\"$self?page=$page\">[Prev]</a> ";
 
   $first = " <a href=\"$self?page=1\">[First Page]</a> ";
} 
else
{
   $prev  = '&nbsp;'; 
   $first = '&nbsp;'; 
}
 
if ($pageNum < $maxPage)
{
   $page = $pageNum + 1;
   $next = " <a href=\"$self?page=$page\">[Next]</a> ";
 
   $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
} 
else
{
   $next = '&nbsp;'; 
   $last = '&nbsp;'; 
}
 
echo "<br><br>";
echo $first . $prev . $nav . $next . $last;
 
?>
 
 

chel-1

[chelvan]

ya its possible, try limit in ur query according to ur page index.


see this

http://www.plus2net.com/php_tutorial/php_paging.php

thanks maheswaran

chel-1