<?php include "1nachalo.php"; ?>
<br /><br /><br /><meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<head>
<link type="text/css" rel="stylesheet" href="CSS/table.css">
<script src="JS/thumbnailviewer.js" type="text/javascript"></script>
<style type="text/css">
#menu2{
color: #7ce388; font-family: tahoma; font-size: 16px; width: 140px; height: 20px; font-weight: bold;
}
</style>
</head>
<?php include("tarsene.php");
include "1config.php";
$connect = mysql_connect($host, $user, $pass);
mysql_select_db($bd, $connect) or die (mysql_error());
mysql_query("SET names cp1251");
if (isset($_POST['submit'])) {
$c = htmlspecialchars(addslashes($_POST['c']));
$kategoriq = htmlspecialchars(addslashes($_POST['kategoriq']));
$text = htmlspecialchars(addslashes($_POST['text']));
$ime = htmlspecialchars(addslashes($_POST['ime']));
$tel = htmlspecialchars(addslashes($_POST['tel']));
$grad = htmlspecialchars(addslashes($_POST['grad']));
$cena = htmlspecialchars(addslashes($_POST['cena']));
$data = date ("d.m.y./H:i");
$email = htmlspecialchars(addslashes($_POST['email']));
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "INSERT INTO obqvi
(rand_file_name1, rand_file_name2, rand_file_name3, kategoriq, text, ime, tel, grad, cena, data, email, ip,) VALUES
('$rand_file_name1', '$rand_file_name2', '$rand_file_name3', '$kategoriq', '$text', '$ime', '$tel', '$grad', '$cena', '$data', '$email', '$ip')"; //Ако всичко е попълнено както трябва въвждаме данните в Базата данни!
mysql_query($sql) or die (mysql_error());
header("LOCATION: obqvi-pregled.php?id=$id");
}
$id = (int)$_GET['id'];
$gett = mysql_query("SELECT * FROM `obqvi` WHERE id= $id");
$row = mysql_fetch_array($gett);
$view=$row['view']+1;
$update = mysql_query("Update `obqvi` set view = '$view' where id = '$id'");
echo "<center>";
foreach($row as $k=>$v) {
if($k=='rand_file_name1' or $k=='rand_file_name2' or $k=='rand_file_name3') {
if(strlen($v) > 9) {
echo "<a href='upload/$v' class='a-text' rel='thumbnail'><img src='upload/$v' border='1' width='200px' /></a> "; } } }
echo "</center>";
echo "<table border='3' class='obqvite'>";
echo"
<style type='text/css'>
.span{
font-style:italic; font-weight: bold; border: 2px solid; font-size: 17px; background-color:#a8aa96;
float: left; width: 200px;
}
</style>
";
echo "<tr><td colspan='3'><span class='span'> $row[kategoriq] </span>
<b>$row[text]</b></td></tr>
<tr><td align='left' width='250px'><b>Име: $row[ime]</b></td> <td><b>Тел: $row[tel]</b></td><td><b>Посетена: $row[view]</b></td></tr>
<tr><td><b>Град: $row[grad]</b></td> <td><b>Публикувана:<font> $row[data] </font></b></td> <td><b> Цена:$row[cena] $row[PE]";
echo "</font></b></td></tr><br>";
echo "</table></a><br />";
?>