Малко проблеми с baneradd.php

ludasam · 6 Юни 2010

Проблема ми е следния влизам в админпанела да добавам банер добавам го ама него показва можели малко помощ сайта е httP://cs-haskovo.info моля някой дами помогне

Код:

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
?>
<?
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<? 
include("../config.php"); 
function sec($prom) 
{ 
return htmlspecialchars(addslashes($prom)); 
} 
if ( isset($_POST[button])) 
{ 
 
$rez = sec($_POST[rez]); 
$snimka = sec($_POST[snimka]); 
$link = sec($_POST[link]); 
$pokazvaniq = sec($_POST[pokazvaniq]); 
 
if ( empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq)) 
{ 
echo 'popylni vsi4ki poleta ...'; 
} 
else 
{ 
mysql_query("INSERT INTO banners (id,click,pokazvaniq,kartinka,link,rez) VALUES('','0','$pokazvaniq','$snimka','$link','$rez')"); 
echo "Банера е добавен успешно :)"; 
} 
} 
else 
{ 
echo '<form action="" method=post> Линк до снимка : <BR> <input type=text name=snimka><BR>Линк до сайта : <BR> <input type=text name=link><BR>показвания : <BR> <input type=text name=pokazvaniq><BR> Резолюция:<select name=rez> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type=submit name=button></form>'; 
echo '<hr><br>'; 
} 

$select = mysql_query("SELECT * FROM banners WHERE rez='$razmeri' AND pokazvaniq > '0' ORDER  by ID"); 
$rezz = explode("x",$razmeri); 
 
while( $row =($select) ) 
{ 
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"   
src='.$row[kartinka].'>'.$row[pokazvaniq].'s'; 
mysql_query("UPDATE banners SET pokazvaniq=pokazvaniq-1 WHERE id='$row[id]'"); 
} 
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

vesku · 6 Юни 2010

Код:

	 <?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
?>
<?
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if ( isset($_POST[button]))
{
 
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);
 
if ( empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
mysql_query("INSERT INTO banners (id,click,pokazvaniq,kartinka,link,rez) VALUES('','0','$pokazvaniq','$snimka','$link','$rez')");
echo "Банера е добавен успешно :)";
}
}
else
{
echo '<form action="" method=post> Линк до снимка : <BR> <input type=text name=snimka><BR>Линк до сайта : <BR> <input type=text name=link><BR>показвания : <BR> <input type=text name=pokazvaniq><BR> Резолюция:<select name=rez> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type=submit name=button></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM banners WHERE rez='$razmeri' AND pokazvaniq > '0' ORDER  by ID");
$rezz = explode("x",$razmeri);
 
while( $row =mysql_fetch_array($select) )
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"   
src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
mysql_query("UPDATE banners SET pokazvaniq=pokazvaniq-1 WHERE id='$row[id]'");
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

ludasam · 6 Юни 2010

Давами тази грешка

Код:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/cshaskov/public_html/admin/baneradd.php  on line 46

vesku · 6 Юни 2010

SELECT * FROM banners WHERE rez='$razmeri' AND pokazvaniq > '0' ORDER by ID

Виж дали си объркал нещо.

ludasam · 6 Юни 2010

можели целия код плс на ново да видя щебачкали

kulov · 6 Юни 2010

Код:

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if (isset($_POST[button]))
{
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);
 
if (empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
$add=mysql_query("INSERT INTO `banners` (`id`, `click`, `pokazvaniq`, `kartinka`, `link`, `rez`) VALUES('', '0', '$pokazvaniq', '$snimka', '$link', '$rez')") or die(mysql_error());
echo "Банера е добавен успешно :)";
}
}
else
{
echo '<form action="" method="post"> Линк до снимка : <BR> <input type="text" name="snimka"><BR>Линк до сайта : <BR> <input type="text" name="link"><BR>показвания : <BR> <input type="text" name="pokazvaniq"><BR> Резолюция:<select name="rez"> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type="submit" name="button"></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM `banners` WHERE `rez` = '$razmeri' AND `pokazvaniq` > '0' ORDER BY `ID`");
$rezz = explode("x",$razmeri);
 
while($row=mysql_fetch_array($select))
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
$pok=$row['pokazvaniq']-1;
mysql_query("UPDATE `banners` SET `pokazvaniq` = '$pok' WHERE id='$row[id]'") or die(mysql_error());
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

slideR · 6 Юни 2010

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if (isset($_POST[button]))
{
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);

if (empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
$add=mysql_query("INSERT INTO `banners` (`id`, `click`, `pokazvaniq`, `kartinka`, `link`, `rez`) VALUES('', '0', '$pokazvaniq', '$snimka', '$link', '$rez')") or die(mysql_error());
echo "Банера е добавен успешно ";
}
}
else
{
echo '<form action="" method="post"> Линк до снимка : <BR> <input type="text" name="snimka"><BR>Линк до сайта : <BR> <input type="text" name="link"><BR>показвания : <BR> <input type="text" name="pokazvaniq"><BR> Резолюция:<select name="rez"> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type="submit" name="button"></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM `banners` WHERE `rez` = '$razmeri' AND `pokazvaniq` > '0' ORDER BY `id`");
$rezz = explode("x",$razmeri);

while($row=mysql_fetch_array($select))
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
$pok=$row['pokazvaniq']-1;
mysql_query("UPDATE `banners` SET `pokazvaniq` = '$pok' WHERE id='$row[id]'") or die(mysql_error());
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

Така :S

kulov · 6 Юни 2010

slideR каза:
<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if (isset($_POST[button]))
{
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);

if (empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
$add=mysql_query("INSERT INTO `banners` (`id`, `click`, `pokazvaniq`, `kartinka`, `link`, `rez`) VALUES('', '0', '$pokazvaniq', '$snimka', '$link', '$rez')") or die(mysql_error());
echo "Банера е добавен успешно ";
}
}
else
{
echo '<form action="" method="post"> Линк до снимка : <BR> <input type="text" name="snimka"><BR>Линк до сайта : <BR> <input type="text" name="link"><BR>показвания : <BR> <input type="text" name="pokazvaniq"><BR> Резолюция:<select name="rez"> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type="submit" name="button"></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM `banners` WHERE `rez` = '$razmeri' AND `pokazvaniq` > '0' ORDER BY `id`");
$rezz = explode("x",$razmeri);

while($row=mysql_fetch_array($select))
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
$pok=$row['pokazvaniq']-1;
mysql_query("UPDATE `banners` SET `pokazvaniq` = '$pok' WHERE id='$row[id]'") or die(mysql_error());
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

Увеличете...

Така :S

Извинявай, но копира моя код, който му дадох по-горе и го постна пак ли какво ?

slideR · 6 Юни 2010

$select = mysql_query("SELECT * FROM `banners` WHERE `rez` = '$razmeri' AND `pokazvaniq` > '0' ORDER BY `id`");

Смених ID със малко id може това да е грешката

ludasam · 6 Юни 2010

Грешка

Код:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/cshaskov/public_html/admin/baneradd.php  on line 43

slideR · 6 Юни 2010

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if (isset($_POST[button]))
{
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);

if (empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
$add=mysql_query("INSERT INTO `banners` (`id`, `click`, `pokazvaniq`, `kartinka`, `link`, `rez`) VALUES('', '0', '$pokazvaniq', '$snimka', '$link', '$rez')") or die(mysql_error());
echo "Банера е добавен успешно Smile";
}
}
else
{
echo '<form action="" method="post"> Линк до снимка : <BR> <input type="text" name="snimka"><BR>Линк до сайта : <BR> <input type="text" name="link"><BR>показвания : <BR> <input type="text" name="pokazvaniq"><BR> Резолюция:<select name="rez"> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type="submit" name="button"></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM `banners` WHERE `rez` = '$razmeri' AND `pokazvaniq` > '0' ORDER BY `id`") or die(mysql_error());
$rezz = explode("x",$razmeri);

while($row=mysql_fetch_array($select))
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
$pok=$row['pokazvaniq']-1;
mysql_query("UPDATE `banners` SET `pokazvaniq` = '$pok' WHERE id='$row[id]'") or die(mysql_error());
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

какво ти дава

ludasam · 6 Юни 2010

Грешка Unknown column 'rez' in 'where clause'

то с тоя код ми да ва да добавям банер ама него показва

Код:

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
?>
<?
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if ( isset($_POST[button]))
{
 
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);
 
if ( empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
mysql_query("INSERT INTO banners (id,click,pokazvaniq,kartinka,link,rez) VALUES('','0','$pokazvaniq','$snimka','$link','$rez')");
echo "Банера е добавен успешно :)";
}
}
else
{
echo '<form action="" method=post> Линк до снимка : <BR> <input type=text name=snimka><BR>Линк до сайта : <BR> <input type=text name=link><BR>показвания : <BR> <input type=text name=pokazvaniq><BR> Резолюция:<select name=rez> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type=submit name=button></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM banners WHERE rez='$razmeri' AND pokazvaniq > '0' ORDER  by ID");
$rezz = explode("x",$razmeri);
 
while( $row =($select) )
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"   
src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
mysql_query("UPDATE banners SET pokazvaniq=pokazvaniq-1 WHERE id='$row[id]'");
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

slideR · 6 Юни 2010

Изкарва ли някаква грешка

ludasam · 6 Юни 2010

ludasam каза:

Грешка Unknown column 'rez' in 'where clause'

то с тоя код ми да ва да добавям банер ама него показва

Код:

<?php
session_start();
if (!isset($_SESSION['login'])) {
header("Location: index.php");
}
?>
<?
include("../admin/style1.html");
?>
<table style="border:1px solid black; color:#666666" cellpadding="5" cellspacing="0" width="100%">
<tr><td align="center" height="30" style="background:url('../admin/imgpan/back.gif') #808080;color:#FFFFFF;padding-bottom:5px;font-size:10px;"><b>Новини</b></td></tr></table>
<table style="border:1px solid black; color:#666666; padding: 10px; background:url('../admin/imgpan/backgr.jpg'); -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;" cellpadding="5" cellspacing="0" width="100%"><tr><td align="center"><font color="#FFFFFF">
<?
include("../config.php");
function sec($prom)
{
return htmlspecialchars(addslashes($prom));
}
if ( isset($_POST[button]))
{
 
$rez = sec($_POST[rez]);
$snimka = sec($_POST[snimka]);
$link = sec($_POST[link]);
$pokazvaniq = sec($_POST[pokazvaniq]);
 
if ( empty($rez) || empty($snimka) || empty($link) || empty($pokazvaniq))
{
echo 'popylni vsi4ki poleta ...';
}
else
{
mysql_query("INSERT INTO banners (id,click,pokazvaniq,kartinka,link,rez) VALUES('','0','$pokazvaniq','$snimka','$link','$rez')");
echo "Банера е добавен успешно :)";
}
}
else
{
echo '<form action="" method=post> Линк до снимка : <BR> <input type=text name=snimka><BR>Линк до сайта : <BR> <input type=text name=link><BR>показвания : <BR> <input type=text name=pokazvaniq><BR> Резолюция:<select name=rez> <option value="468x60"> 468x60</option><option value="88x31"> 88x31</option><option value="120x240"> 120x240</option></select> <BR> <input type=submit name=button></form>';
echo '<hr><br>';
}

$select = mysql_query("SELECT * FROM banners WHERE rez='$razmeri' AND pokazvaniq > '0' ORDER  by ID");
$rezz = explode("x",$razmeri);
 
while( $row =($select) )
{
echo '<img width="'.$rezz[0].'" height="'.$rezz[1].'"   
src='.$row[kartinka].'>'.$row[pokazvaniq].'s';
mysql_query("UPDATE banners SET pokazvaniq=pokazvaniq-1 WHERE id='$row[id]'");
}
?></font></td></tr>
</table>
<?
include("../admin/style2.html");
?>

slideR · 6 Юни 2010

Нямаш поле rez

ludasam · 6 Юни 2010

и кво да направя то смоя си код неми да ва грешки ама кат добавя банера него показва

slideR · 6 Юни 2010

саздай поле rеz в таблицата и ще стане :?:

ludasam · 6 Юни 2010

как и каде ако може дами го направиш или дама светнеш повече

slideR · 6 Юни 2010

Ами в таблицата banners създаваш едно поле rez. Това е

ludasam · 6 Юни 2010

е незнам как бе брат :С

Малко проблеми с baneradd.php

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered

Registered