<?php
include"conf.php";
$broinastranica = 10;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$pp = "5";
$table = "clips";
$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table "),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
echo"<table align=\"left\" border=\"0\">";
$i="0";
$nared="6";
$query="SELECT * FROM $table ORDER BY id LIMIT $redove, $broinastranica";
$result=mysql_query($query);
while ( $r = mysql_fetch_array( $result )){
$i++;
$width=ceil(100/$nared);
$ime=$r[ime];
$pic=$r[pic];
$klik=$r[klik];
$url=$r[url];
if (strlen($ime)>16)
{$t='...';}
$ime = substr($ime,0,16);
$kat = $r[kategoria];
echo"<td width=\"130\" align=\"center\" border=\"1\" background=\"images/b.gif\">
<a href=\"view.php?id=$r[id]\" onmouseover=\"return overlib('$r[ime]')\" onmouseout=\"return nd();\"><img src=\"$pic\" border=\"0\" width=\"120\" height=\"90\"></div><br><b>$ime$t</a>";
if($kat==""){
echo"<br>Гледан : $klik пъти
<br>Свали : <a href=\"$url\">От Тук</a>
<br>Няма категория<br>";
}else{ echo"
<br>Гледан : $klik пъти
<br>Свали : <a href=\"$url\">От Тук</a>
<br>Категория : <a href=\"cat.php?kategoria=$r[kategoria]\"><b>$kat</a><br>";}
if ($i==$nared)
{
echo "</tr>
<tr>";
$i=0;
}
}
$query = "SELECT COUNT(id) AS numrows FROM $table";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page\"> [<<<<<] </a> ";
$parva = " <a href=\"$self?page=1\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page\"> [>>>>>] </a> ";
$posledna = " <a href=\"$self?page=$maxPage\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<br>".$parva . $predishna . $nomeranastranici . $sledvashta . $posledna."<br>";
echo"</table>";
?>