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;
?>

Keresés

Hirdetések

Hirdetes

Ki van még itt?

Oldalainkat 2 vendég böngészi

Stats

Tartalom találatai : 34195