Hi,
I've been trying to limit the display of page number from the result of the database.
I have tried to limit the the link number displayed and put 10 number links displayed at a time and when clicked to Next Pages it should go to first page after the last page i.e. should display page number link from [11] - [20]. and should hide the display of [1] - [10] page number.
Thank you.
<?php
$dbhost = "";
$dbname = "";
$dbusername = "";
$dbpassword = "";
$connection = mysql_connect($dbhost, $dbusername, $dbpassword);
if (!$connection) { echo("ERROR: " . mysql_error() . "\n"); }
// the number of rows returned from database
$database = mysql_select_db($dbname,$connection);
$numresults = mysql_query("SELECT id FROM database ORDER BY date ");
$numrows = mysql_num_rows($numresults);
$limit = 12;
// next determine if offset has been passed to script, if not use 0
if (!$offset) { $offset = 0; }
function pagenav()
{
global $limit,$offset,$pages,$numrows;
// calculate number of pages needing links
$pages=intval(round($numrows/$limit));
// get previous page displayed
if ($offset>=$limit)
{
$newoff=$offset-$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\"> prev</a>";
}
else
{
echo "PREV";
}
// get next page displayed
if ($offset<$limit*($pages-1))
{
$newoff=$offset+$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\">
next</a>";
}
else
{
echo "NEXT";
}
// get the page number displayed
$pagenumber=1;
$max = 10;
while ($pagenumber <= $pages)
{
if ((($pagenumber-1)$limit)==$offset)
{ print " $pagenumber "; }
elseif($pagenumber <= $max)
{
$newoff=($pagenumber-1)$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\"><font size=3> [$pagenumber] </font></a>";
}
else
{
$newoff=($pagenumber-1)*$limit;
echo "<a href=\"$PHP_SELF?offset=$newoff\">[Next Pages]</a>";
exit;
}
$pagenumber++;
}
echo "<br><br>";
} // END FUNCTION
