<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1251" />
<title>Банери</title>
</head>
<body>
<form action="" method="post"><b>Добавяне на банер: </b><br />
Адрес на сайта:<input type="text" size="25" name="url"><br />
Линк към банера:<input type="text" size="25" name="picurl"><br />
<input type="submit" name="submit" value="Добави">
</form>
</body>
</html>
<?php
include("conf.php");
if ($_POST['submit']){
$url = $_POST['url'];
$picurl = $_POST['picurl'];
if ((empty($url)) or (empty($picurl))){
echo "Не си попълнил всички полета!";
exit;
}
$url = htmlspecialchars($url);
$url = addslashes($url);
$picurl = htmlspecialchars($picurl);
$picurl = addslashes($picurl);
mysql_connect($host,$user,$pass);
$chars="SET CHARACTER SET cp1251";
@mysql_select_db($db) or die( "Unable to select database");
mysql_query($chars);
$1 = "SELECT * FROM banner WHERE url='$url'";
$2 = mysql_query($1);
$3 = mysql_num_rows($2);
if($3 >= 1){
echo "Вече сте добавили вашият Банер";
exit;
}
$query = "INSERT into $rw (id,url,picurl) VALUES (NULL,'$url', '$picurl')";
mysql_query ($query);
$command = "SELECT * FROM $rw WHERE impresii > 5000";
$result_command = mysql_query($command);
$row_command = mysql_fetch_array($result_command);
if($row_command)
{
$zaqvka = mysql_query("DELETE FROM $rw WHERE impresii > 5000");
}
echo "Банера е добавен успешно!";
}
?>
