Ето го:
<?php include ("config.php"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>SSL-BG Вицове</title>
<style type="text/css">
#nav
{
width: 199px;
}
#nav a
{
background-color: #000000;
border-top: 1px solid #808080;
border-left: 2px solid #ff0000;
border: 1px solid green;
height: 17px;
width: 178px;
font-family: verdana;
font-size: 13px;
color: white;
text-decoration: none;
padding-left: 20px;
padding-top: 2px;
display: block;
}
#nav a:hover
{
text-decoration: none;
background-color: #ff0000;
border-top: #ff0000;
border-bottom: 1px solid black;
}
#nav a:active {
background-color: #ff0000;
text-decoration: none;
border-top: #A2DBFC;
border-left: 2px solid #52BCF7;
</style>
</head>
<body>
<body background="http://i.data.bg/07/11/04/646534_orig.jpg">
<table width="800px" border="0" cellspacing="5" cellpadding="0">
<tr>
<td colspan="2"> <h1><h1></td>
</tr>
<tr>
<td valign="top" width="200px">
<div id="nav">
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM kategorii ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
$id_cat=mysql_result($result,$i,"id_cat");
echo "<a href=view.php?id_cat=$id_cat>$cats</a>";
$i++;
}
echo "<br>";
echo "<a href=index.php>Начало</a>";
echo "<a href=add.php>Добави виц</a>";
?>
</div>
</td>
<td valign="top" width="600px">
<table width="66%" border="1">
<?php
$id_cat=$_GET['id_cat'];
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$pp = "10";
$total = mysql_result(mysql_query("SELECT COUNT(id_vic) FROM vicove"),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
$query = "SELECT * FROM vicove WHERE id_cat='$id_cat' ORDER BY id_vic DESC LIMIT $limitvalue, $pp";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
$vic=$r[vic];
$potrebitel=$r[potrebitel];
$vreme=$r[vreme];
$email=$r;
echo "<tr>
<td width=50%> Добавил: <a href=mailto:$email>$potrebitel</a></td>
<td width=50%> Дата: $vreme</td>
</tr>
<tr>
<td align="justify" width="100%" colspan="2"><?php echo "<span style='color: white; font-family: verdana; font-size: 11px;'>$vic</span>"; ?> </td>
</tr>
<tr>
<td width=100% colspan=2> </td>
</tr>";
}
?>
<table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
<?php
echo 'Общо страници: '.round($numofpages).'<br>';
?>
<center>
<?php
function per_page($link, $offset) {
global $numofpages, $page;
$numofpages = round($numofpages);
$pagesstart = round($page-$offset);
$pagesend = round($page+$offset);
if ($page != "1" && round($numofpages) != "0") {
echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">«</font></a> ');
}
for($i = 1; $i <= $numofpages; $i++) {
if ($pagesstart <= $i && $pagesend >= $i) {
if ($i == $page) {
echo "<b>[$i]</b> ";
}
else {
echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a> ');
}
}
}
if (round($numofpages) == "0") {
echo "[$i]";
}
if ($page != round($numofpages) && round($numofpages) != "0") {
echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">»</font></a>');
}
}
per_page("?id_cat=$id_cat&page=%page", "5");
?>
</center>
</body>
</html>