<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
a#hiddenlink, a#hiddenlink:hover {
color: #ffffff;
background:none;
}
</style>
</head>
<body bgcolor="#FFFFFF">
<table style="border: 1px solid #000000" align="center">
<form action="gallery.php" method="post" enctype="multipart/form-data">
<tr><td>Име</td><td><input name="name" type="text" class="blocks"></td></tr>
<tr><td>Фаел</td><td><input name="file" type="file" class="blocks" id="pic" /></td></tr>
<tr><td>Кратко<br>описание</td><td><textarea name="opis" cols="30" rows="6"></textarea></td></tr>
<tr><td>Добавен от</td><td><input name="dobavil" type="text" class="blocks" id="dobavil"></td></tr>
<tr><td></td><td>
<input type="reset" name="Reset" style="float:right" value="Изчисти" /><input type="submit" name="Submit2" style="float:right" value="Добави" /></td></tr>
</form>
</table>
<hr>
<?php
$db=mysql_connect ("localhost", "root", "idkfa") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("links");
// Rezultati na stranica
$pp = "10";
$table = "gallery";
$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table Limit 5"),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
//pokazvane na zapisite
$query = "SELECT * FROM $table order by id desc LIMIT $limitvalue, $pp";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
echo "<table width='650' border=\"1\" align=\"center\"><tr align=\"center\" width=20><td>$r[id]</td><td width=190>$r[name]</td><td>$r[big] байта</td><td>Oт: $r[dobavil]</td><td width=140>$r[date]</td><td>$r[chas]</td></tr></table><table width='650' border=\"1\" align=\"center\"><tr><td width=135><a href=$r[link] alt=\"Уголеми\" id=\"hiddenlink\" target=_blank><img src=$r[link] height=120 width=135></a></td><td>$r[text]</td></tr></table>";
echo "<br>";
}
//Показване на резултатите на различни страници
function per_page($link, $offset) {
global $numofpages, $page;
$numofpages = round($numofpages);
$pagesstart = round($page-$offset);
$pagesend = round($page+$offset);
echo "<center>";
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>');
}
}
echo '<br>';
per_page("?page=%page", "5");
echo "</center>";
?>
</body>
</html>
