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.co m/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.co m/php_tutorial/php_paging.php

thanks maheswaran

chel-1