nedko

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>

<body>
<?php
include 'config.php';

$db_selected = mysql_select_db('klienti');
$rowsPerPage = 15;
$pageNum = 1;
if(isset($_GET['page']))
{
	$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
$query  = "SELECT * FROM info LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed_1');
while($row = mysql_fetch_array($result))
{
	echo $row['id'];
	echo $row['ime'];
	echo $row['familia'];
	}
echo '<br>';
$query   = "SELECT COUNT(*) AS numrows FROM info";
$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 ";
	}
	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 "$first . $prev . $nav . $next . $last";
?>
</body>
</html>