Egyszerű lapozó script
<?php
$rowsPerPage = 10;
$pageNum = 1;
$link="";
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query = " SELECT * FROM tablaneve" .
" LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed');
while($row = mysql_fetch_array($result))
{
echo $row['nev'];
echo $row['kiscom'];
echo $row['netto'];
}
$query = "SELECT COUNT(nev) AS numrows FROM termek where tipus = '$tipus' AND altipus='$altipus'";
$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 ";#nem kell
}
else
{
$nav .= " <a href=\"$self?page=$page&".$link."\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a style=\"color:#000000; font-family:Arial; font-size:12px\" onmouseover=\"this.bgcolor='#000080'\" onmouseout=\"this.bgcolor='#000000'\" href=\"$self?page=$page&".$link.\">[Elozo]</a> ";
$first = " <a href=\"$self?page=1&".$link.\">[Elso oldal]</a> ";
}
else
{
$prev = ' ';
$first = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page&".$link.\">[Következo]</a> ";
$last = " <a href=\"$self?page=$maxPage&".$link.\">[utolsó oldal]</a> ";
}
else
{
$next = ' ';
$last = ' ';
}
echo $first . $prev . $nav . $next . $last;
?>


