Проблем с код!

kristiqn2

Registered
Здравейте,
искам да направя една форма която да добавя новини към базата данни но когато поставя кода ми излиза празна страница махна ли кода оправя се защо така?
Ето го и кода:
PHP:
<?php
				{
	if(isset($_POST['add']))
	{
		$time = time();
		$content = strip_tags($_POST['content']);
		$author = strip_tags($_POST['author'];
		$q = "INSERT INTO pozdravi (post_id, content, author) VALUES ('$content',)";
		mysql_query($q) or die (mysql_error());
	}
	}
	?>
 
Имаш грешка на този ред:
PHP:
$q = "INSERT INTO pozdravi (post_id, content, author) VALUES ('$content',)";
Поради тази причина ти изкарва or die (mysql_error()) и не ти изкарва другата част от кода. :)
 
PHP:
  if(isset($_POST['add']))
        {
                $time = time();
                $content = strip_tags($_POST['content']);
                $author = strip_tags($_POST['author'];
                $q = "INSERT INTO pozdravi (content, author) VALUES ('.$content', '.$author')";
             echo myqsl_error();
        }
        }
        ?>

Заповядай кода ако има проблем с кавичките пиши в темата да го оправим :)
ако не излизат грешки махни
echo myqsl_error();
 
PHP:
  if(isset($_POST['add']))
        {
                $time = time();
                $content = strip_tags($_POST['content']);
                $author = strip_tags($_POST['author'];
                $q = "INSERT INTO pozdravi (content, author) VALUES ('$content', '$author')";
mysql_query($q) or die (mysql_error());
        }
        }
        ?>
 
Отново бяла страница ето целия код:
PHP:
<?php
session_start();
include("function_poll.php"); 
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Radio Extreme - Вашето музикално желание !</title>
<link href="style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-type" content="text/html; charset=windows-1251" />
<meta http-equiv="Content-Language" content="bg" />
<meta name="author" content="" />
<meta name="coder" content="Kristiqn Todorov" />
<meta name="copyright" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="shortcut icon" href="images/favicon.ico" />

</head>
<body>
<div id="web">

	<div id="top"></div>
	<div id="mid">
		<div id="headtop"></div>
		<div id="headmid">
			<div id="sitename"><img src="images/radio-xix.jpg"></div>
			<div id="banner"><A href='http://hb-gaming.info/' target=' blank'><IMG src='http://prikachi.com/images/729/2808729z.png' BORDER='0'></A>
</div>
		</div>
		<div id="headbottom"></div>

		
		<div id="lmenu"></div>
		<div id="cmenu"><center>
			<div class="link"><a href="index.php">Начало</a></div>
			<div class="link"><a href="http://94.156.170.132:8000/listen.pls" target=' blank'>Свали Радио</a></div>
			<div class="link"><a href="pozdravi.php">Поздрави</a></div>
			<div class="link"><a href="chat.php">Онлайн Чат</a></div>

		</div>
		<div id="rmenu"></div>
		<div id="left">
			<div class="thebox1">
				<div class="lbox"></div><div class="cbox">Слушай Онлайн</div><div class="rbox"></div>
				<div class="box1"><br /><center><object id="Player" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" standby="Loading Microsoft® Windows® Media Player components..." type="application/x-oleobject" vspace="0" width="200" align="absmiddle" height="52" hspace="0">
      <noembed><a href='http://94.156.170.132:8000/listen.pls</noembed>

      
      <param name="FileName" value="http://94.156.170.132:8000/">

      <param name="ShowControls" value="true">
      <param name="ShowStatusBar" value="true">
      <param name="Autostart" value="true">
      <param name="ShowPositionControls" value="False">
      <param name="ShowTracker" value="false">
      <param name="InvokeURLs" value="True">
      <param name="ShowGotoBar" value="false">

      <param name="ShowDisplay" value="false">
      <param name="AutoSize" value="false">

                      <embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" src="http://94.156.170.132:8000/" name="Player" autostart="true" showcontrols="true" showstatusbar="true" showdisplay="false" showpositioncontrols="False" showtracker="false" invokeurls="True" showgotobar="false" autosize="false" width="190" height="92">    
    </object><br /><br /><br /><br /></center></div>
			</div>

			<div class="thebox1">
				<div class="lbox"></div><div class="cbox">Радио Статистика</div><div class="rbox"></div>
                <div class="box1"><center><br /><b>В момента радиото е: 
<?php
// Change these to your online/offline messages //
$online = "<font color=green>Онлайн</font>"; // Displays when stream is online
$offline = "<font color=red>Офлайн</font>"; // Displays when stream is offline
// don't edit below //
$ip = "94.156.170.132";
$port = "8000";
$fp = @fsockopen($ip,$port,$errno,$errstr,1);
if (!$fp) 
        { 
        $status = $offline;
        } 
        else
        { 
        fputs($fp, "GET /7.html HTTP/1.0\r\nUser-Agent: Mozilla\r\n\r\n");
        while (!feof($fp)) 
                {
                $info = fgets($fp);
                }
        $split = explode(',', $info);
        if ($split[1] == "0" )
                {
                $status = $offline;
                }
        else
                {
                $status = $online;
                }
        }
echo $status;
?>
</div>


<div class="thebox1">
<div class="lbox"></div><div class="cbox">В момента свири:</div><div class="rbox"></div>
<div class="box1">
<? 
// ОТДОЛУ ПИШЕТЕ ИП ТО и ПОРТА 
$open = @fsockopen("94.156.170.132","8000"); 

if ($open) { 

fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n"); 

$read = fread($open,1000); 
$text = explode(",",$read); 

$text = $text[6]; 

} else { $text="Connection Refused!"; } 
echo " " .$text; 
?> 
<br /><br /><br /><br /><br /><br /><br /></center></div>
		</div>
		</div>
		</div>
		<?php
		if(isset($_POST['add']))
        {
		{
                $time = time();
                $content = strip_tags($_POST['content']);
                $author = strip_tags($_POST['author'];
                $q = "INSERT INTO pozdravi (content, author) VALUES ('$content', '$author')";
mysql_query($q) or die (mysql_error());
        }
        }
        ?>
		<div id="right">
			<div class="thebox2">
				<div class="lbox"></div><div class="cbox2">Новини</div><div class="rbox"></div>
				<div class="box2">
				
<Center>
		<form method="post" action="login.php">
		 <div align="center">Име:</div> <input type="text" name="name" />
		 <div align="center">Поздрав:</div> <textarea name="content" cols="30" rows="5"></textarea><br />
		 <input type="submit" name="submit" value="Изпрати" />
</div>
			</div>
		
			<div class="thebox2">
				<div class="lbox"></div><div class="cbox2">Специална реклама</div><div class="rbox"></div>
				<div class="box2"><center><A href='http://devil-cs.info/' target=' blank'><IMG src='http://prikachi.com/images/766/2807766V.jpg' Width='435' BORDER='0'></A>

</center></div>
			</div>

		</div>
		
		
		<div id="right2">
			<div class="thebox1">
				<div class="lbox"></div><div class="cbox">Анкета</div><div class="rbox"></div>
				<div class="box1"><Center><?php @poll(); ?>
			</div>

			<div class="thebox1">
				<div class="lbox"></div><div class="cbox">Гласувайте за нас</div><div class="rbox"></div>
				<div class="box1"><center><a href="http://bgtop.net/in.php/1306695618" target="_blank"><img src="images/bg top.jpg" alt="BGtop" title="Елате в .: BGtop.net :. Топ класацията на българските сайтове и гласувайте за този сайт!" border="0" /></a></center></div>
			</div>
		</div>
	</div>
	<div id="bottom">Всички права запазени © <a href="skype:radio.mix-bg?chat">Radio-Mix</a>
<script  type="text/javascript">

</script>
<noscript><a href="http://www.tyxo.bg/?121752" title="Tyxo.bg counter" target="_blank"><img src="http://cnt.tyxo.bg/121752" width="80" height="15" border="0" alt="Tyxo.bg counter" /></a></noscript>

</div>
</div>
</body>
</html>
 
PHP:
<?php
session_start();
include("function_poll.php"); 
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Radio Extreme - Вашето музикално желание !</title>
<link href="style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-type" content="text/html; charset=windows-1251" />
<meta http-equiv="Content-Language" content="bg" />
<meta name="author" content="" />
<meta name="coder" content="Kristiqn Todorov" />
<meta name="copyright" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="shortcut icon" href="images/favicon.ico" />

</head>
<body>
<div id="web">

        <div id="top"></div>
        <div id="mid">
                <div id="headtop"></div>
                <div id="headmid">
                        <div id="sitename"><img src="images/radio-xix.jpg"></div>
                        <div id="banner"><A href='http://hb-gaming.info/' target=' blank'><IMG src='http://prikachi.com/images/729/2808729z.png' BORDER='0'></A>
</div>
                </div>
                <div id="headbottom"></div>

                
                <div id="lmenu"></div>
                <div id="cmenu"><center>
                        <div class="link"><a href="index.php">Начало</a></div>
                        <div class="link"><a href="http://94.156.170.132:8000/listen.pls" target=' blank'>Свали Радио</a></div>
                        <div class="link"><a href="pozdravi.php">Поздрави</a></div>
                        <div class="link"><a href="chat.php">Онлайн Чат</a></div>

                </div>
                <div id="rmenu"></div>
                <div id="left">
                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Слушай Онлайн</div><div class="rbox"></div>
                                <div class="box1"><br /><center><object id="Player" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" standby="Loading Microsoft® Windows® Media Player components..." type="application/x-oleobject" vspace="0" width="200" align="absmiddle" height="52" hspace="0">
      <noembed><a href='http://94.156.170.132:8000/listen.pls</noembed>

      
      <param name="FileName" value="http://94.156.170.132:8000/">

      <param name="ShowControls" value="true">
      <param name="ShowStatusBar" value="true">
      <param name="Autostart" value="true">
      <param name="ShowPositionControls" value="False">
      <param name="ShowTracker" value="false">
      <param name="InvokeURLs" value="True">
      <param name="ShowGotoBar" value="false">

      <param name="ShowDisplay" value="false">
      <param name="AutoSize" value="false">

                      <embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" src="http://94.156.170.132:8000/" name="Player" autostart="true" showcontrols="true" showstatusbar="true" showdisplay="false" showpositioncontrols="False" showtracker="false" invokeurls="True" showgotobar="false" autosize="false" width="190" height="92">    
    </object><br /><br /><br /><br /></center></div>
                        </div>

                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Радио Статистика</div><div class="rbox"></div>
                <div class="box1"><center><br /><b>В момента радиото е: 
<?php
// Change these to your online/offline messages //
$online = "<font color=green>Онлайн</font>"; // Displays when stream is online
$offline = "<font color=red>Офлайн</font>"; // Displays when stream is offline
// don't edit below //
$ip = "94.156.170.132";
$port = "8000";
$fp = @fsockopen($ip,$port,$errno,$errstr,1);
if (!$fp) 
        { 
        $status = $offline;
        } 
        else
        { 
        fputs($fp, "GET /7.html HTTP/1.0\r\nUser-Agent: Mozilla\r\n\r\n");
        while (!feof($fp)) 
                {
                $info = fgets($fp);
                }
        $split = explode(',', $info);
        if ($split[1] == "0" )
                {
                $status = $offline;
                }
        else
                {
                $status = $online;
                }
        }
echo $status;
?>
</div>


<div class="thebox1">
<div class="lbox"></div><div class="cbox">В момента свири:</div><div class="rbox"></div>
<div class="box1">
<? 
// ОТДОЛУ ПИШЕТЕ ИП ТО и ПОРТА 
$open = @fsockopen("94.156.170.132","8000"); 

if ($open) { 

fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n"); 

$read = fread($open,1000); 
$text = explode(",",$read); 

$text = $text[6]; 

} else { $text="Connection Refused!"; } 
echo " " .$text; 
?> 
<br /><br /><br /><br /><br /><br /><br /></center></div>
                </div>
                </div>
                </div>
                <?php
                if(isset($_POST['add']))
        {
                {
                $time = time();
                $content = strip_tags($_POST['content']);
                $author = strip_tags($_POST['name'];
                $q = "INSERT INTO pozdravi (content, author) VALUES ('$content', '$author')";
mysql_query($q) or die (mysql_error());
        }
        }
        ?>
                <div id="right">
                        <div class="thebox2">
                                <div class="lbox"></div><div class="cbox2">Новини</div><div class="rbox"></div>
                                <div class="box2">
                                
<Center>
                <form method="post" action="">
                 <div align="center">Име:</div> <input type="text" name="name" />
                 <div align="center">Поздрав:</div> <textarea name="content" cols="30" rows="5"></textarea><br />
                 <input type="submit" name="add" value="Изпрати" />
				<form>
</Center>
</div>
                        </div>
                
                        <div class="thebox2">
                                <div class="lbox"></div><div class="cbox2">Специална реклама</div><div class="rbox"></div>
                                <div class="box2"><center><A href='http://devil-cs.info/' target=' blank'><IMG src='http://prikachi.com/images/766/2807766V.jpg' Width='435' BORDER='0'></A>

</center></div>
                        </div>

                </div>
                
                
                <div id="right2">
                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Анкета</div><div class="rbox"></div>
                                <div class="box1"><Center><?php @poll(); ?>
                        </div>

                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Гласувайте за нас</div><div class="rbox"></div>
                                <div class="box1"><center><a href="http://bgtop.net/in.php/1306695618" target="_blank"><img src="images/bg top.jpg" alt="BGtop" title="Елате в .: BGtop.net :. Топ класацията на българските сайтове и гласувайте за този сайт!" border="0" /></a></center></div>
                        </div>
                </div>
        </div>
        <div id="bottom">Всички права запазени © <a href="skype:radio.mix-bg?chat">Radio-Mix</a>
<script  type="text/javascript">

</script>
<noscript><a href="http://www.tyxo.bg/?121752" title="Tyxo.bg counter" target="_blank"><img src="http://cnt.tyxo.bg/121752" width="80" height="15" border="0" alt="Tyxo.bg counter" /></a></noscript>

</div>
</div>
</body>
</html>
 
Стана но сега като натисна изпрати и ми излиза това :
Код:
You have an error in your SQL syntax near ''кирско ','',)' at line 1
 
имаш 3 затварящи къдрави скоби,или не си ги показал всички или там ти е грешката :)
 
PHP:
<?php
session_start();
include("function_poll.php"); 
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Radio Extreme - Вашето музикално желание !</title>
<link href="style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-type" content="text/html; charset=windows-1251" />
<meta http-equiv="Content-Language" content="bg" />
<meta name="author" content="" />
<meta name="coder" content="Kristiqn Todorov" />
<meta name="copyright" content="" />
<meta name="description" content="" />
<meta name="keywords" content="" />
<link rel="stylesheet" type="text/css" href="style.css" />
<link rel="shortcut icon" href="images/favicon.ico" />

</head>
<body>
<div id="web">

        <div id="top"></div>
        <div id="mid">
                <div id="headtop"></div>
                <div id="headmid">
                        <div id="sitename"><img src="images/radio-xix.jpg"></div>
                        <div id="banner"><A href='http://hb-gaming.info/' target=' blank'><IMG src='http://prikachi.com/images/729/2808729z.png' BORDER='0'></A>
</div>
                </div>
                <div id="headbottom"></div>

                
                <div id="lmenu"></div>
                <div id="cmenu"><center>
                        <div class="link"><a href="index.php">Начало</a></div>
                        <div class="link"><a href="http://94.156.170.132:8000/listen.pls" target=' blank'>Свали Радио</a></div>
                        <div class="link"><a href="pozdravi.php">Поздрави</a></div>
                        <div class="link"><a href="chat.php">Онлайн Чат</a></div>

                </div>
                <div id="rmenu"></div>
                <div id="left">
                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Слушай Онлайн</div><div class="rbox"></div>
                                <div class="box1"><br /><center><object id="Player" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" standby="Loading Microsoft® Windows® Media Player components..." type="application/x-oleobject" vspace="0" width="200" align="absmiddle" height="52" hspace="0">
      <noembed><a href='http://94.156.170.132:8000/listen.pls</noembed>

      
      <param name="FileName" value="http://94.156.170.132:8000/">

      <param name="ShowControls" value="true">
      <param name="ShowStatusBar" value="true">
      <param name="Autostart" value="true">
      <param name="ShowPositionControls" value="False">
      <param name="ShowTracker" value="false">
      <param name="InvokeURLs" value="True">
      <param name="ShowGotoBar" value="false">

      <param name="ShowDisplay" value="false">
      <param name="AutoSize" value="false">

                      <embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" src="http://94.156.170.132:8000/" name="Player" autostart="true" showcontrols="true" showstatusbar="true" showdisplay="false" showpositioncontrols="False" showtracker="false" invokeurls="True" showgotobar="false" autosize="false" width="190" height="92">    
    </object><br /><br /><br /><br /></center></div>
                        </div>

                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Радио Статистика</div><div class="rbox"></div>
                <div class="box1"><center><br /><b>В момента радиото е: 
<?php
// Change these to your online/offline messages //
$online = "<font color=green>Онлайн</font>"; // Displays when stream is online
$offline = "<font color=red>Офлайн</font>"; // Displays when stream is offline
// don't edit below //
$ip = "94.156.170.132";
$port = "8000";
$fp = @fsockopen($ip,$port,$errno,$errstr,1);
if (!$fp) 
        { 
        $status = $offline;
        } 
        else
        { 
        fputs($fp, "GET /7.html HTTP/1.0\r\nUser-Agent: Mozilla\r\n\r\n");
        while (!feof($fp)) 
                {
                $info = fgets($fp);
                }
        $split = explode(',', $info);
        if ($split[1] == "0" )
                {
                $status = $offline;
                }
        else
                {
                $status = $online;
                }
        }
echo $status;
?>
</div>


<div class="thebox1">
<div class="lbox"></div><div class="cbox">В момента свири:</div><div class="rbox"></div>
<div class="box1">
<? 
// ОТДОЛУ ПИШЕТЕ ИП ТО и ПОРТА 
$open = @fsockopen("94.156.170.132","8000"); 

if ($open) { 

fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n"); 

$read = fread($open,1000); 
$text = explode(",",$read); 

$text = $text[6]; 

} else { $text="Connection Refused!"; } 
echo " " .$text; 
?> 
<br /><br /><br /><br /><br /><br /><br /></center></div>
                </div>
                </div>
                </div>
                <?php
                if(isset($_POST['add']))
        {
                {
                $time = time();
                $content = addslashes(strip_tags($_POST['content']));
                $author = addslashes(strip_tags($_POST['name']));
                $q = "INSERT INTO pozdravi (`content`,` author`) VALUES ('$content', '$author')";
mysql_query($q) or die (mysql_error());
        }
        }
        ?>
                <div id="right">
                        <div class="thebox2">
                                <div class="lbox"></div><div class="cbox2">Новини</div><div class="rbox"></div>
                                <div class="box2">
                                
<Center>
                <form method="post" action="">
                 <div align="center">Име:</div> <input type="text" name="name" />
                 <div align="center">Поздрав:</div> <textarea name="content" cols="30" rows="5"></textarea><br />
                 <input type="submit" name="add" value="Изпрати" />
                                <form>
</Center>
</div>
                        </div>
                
                        <div class="thebox2">
                                <div class="lbox"></div><div class="cbox2">Специална реклама</div><div class="rbox"></div>
                                <div class="box2"><center><A href='http://devil-cs.info/' target=' blank'><IMG src='http://prikachi.com/images/766/2807766V.jpg' Width='435' BORDER='0'></A>

</center></div>
                        </div>

                </div>
                
                
                <div id="right2">
                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Анкета</div><div class="rbox"></div>
                                <div class="box1"><Center><?php @poll(); ?>
                        </div>

                        <div class="thebox1">
                                <div class="lbox"></div><div class="cbox">Гласувайте за нас</div><div class="rbox"></div>
                                <div class="box1"><center><a href="http://bgtop.net/in.php/1306695618" target="_blank"><img src="images/bg top.jpg" alt="BGtop" title="Елате в .: BGtop.net :. Топ класацията на българските сайтове и гласувайте за този сайт!" border="0" /></a></center></div>
                        </div>
                </div>
        </div>
        <div id="bottom">Всички права запазени © <a href="skype:radio.mix-bg?chat">Radio-Mix</a>
<script  type="text/javascript">

</script>
<noscript><a href="http://www.tyxo.bg/?121752" title="Tyxo.bg counter" target="_blank"><img src="http://cnt.tyxo.bg/121752" width="80" height="15" border="0" alt="Tyxo.bg counter" /></a></noscript>

</div>
</div>
</body>
</html>
 
kristiqn2 каза:
сега пък ми исписва No Database Selected :D
Това го няма в този файл.
Потърси къде ти е връзката с базата данни и си напиши параметрите.
 
kristiqn2 каза:
оправих го но ми исписва тази грешка:
Код:
Unknown column ' author' in 'field list'
В таблицата "pozdravi" нямаш "author" кажи какви полета имаш вътре :idea:
 
Да, но нещо бъркаш явно база данните или не знам точно таблицата може би.. Защото кода ти казва, че няма такова поле, а не мисля че ще те излъже..
 

Back
Горе