да не се публикува отново

stefan122

Registered
Като добавя виц след това дам Назад и после рефреш вица се публикува отново...?

как да го променя това?

PHP:
<td width="60%" valign="top">
	
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="images/menuc.gif" alt=""></td>
    <td width="100%" class="menubg">Добави виц</td>
    <td><img src="images/menuc.gif" alt=""></td>
  </tr>
  <tr>
    <td colspan="3" class="menubrd">
<div align="center" style="font-size: 12px;">

<form action="" method="POST">
	<table width="70%" border="0" align="center" style="font-size: 12px;"> 
		<tr>
			<td align="left" width="95"> Вашето име или прякор:</td> 
</tr><tr>
			<td align="left">
			<input name="ot" type="text" size="45" ></td> 
	    </tr> 
		<tr> 
			<td align="left"> Виц:</td></tr>
			<tr>
			<td align="center">
			<textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
		</tr> 

			<td align="center">
<select name="cat"> 
			<option value="0">Изберете категория</option> 
			<?php 
			$r = mysql_query("SELECT * FROM vicove_cat ORDER BY id ASC"); 
			while($row = mysql_fetch_array($r)){ 
			$cat .= "<option value=\"$row[value]\">$row[value]</option>"; 
			} 
			echo $cat; 
			?></td> 
		</tr> 
<tr> 
			<td colspan="3" align="center">
			<input name="button" type="submit" value="Качи" /> 
			</td> 
		</tr> 
			</table> 
  </form> 

<?
include "conn.php";
$button=$_POST['button'];
if($button){
$ot=htmlspecialchars($_POST['ot']);
$vic=htmlspecialchars($_POST['vic']);
$date = date("j-n-Y, H:i:s"); 
$cat=htmlspecialchars($_POST['cat']);
if(empty($ot) OR ($cat=="0") OR empty($vic)){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, vic, date, cat) VALUES ('','$ot', '$vic', '$date', '$cat')") or die(mysql_error());
echo "<div class='success'>Вицът е добавен успешно!</div>"; 
}
}
?>

</div>
</td>
    </tr>
 
	<tr>
    <td><img src="images/dmenul.gif" alt=""></td>
    <td width="100%" class="dmenubg"></td>
    <td><img src="images/dmenur.gif" alt=""></td>
  </tr>
</table>
<br>
		
	
	</td>
 
PHP:
<td width="60%" valign="top">
        
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="images/menuc.gif" alt=""></td>
    <td width="100%" class="menubg">Добави виц</td>
    <td><img src="images/menuc.gif" alt=""></td>
  </tr>
  <tr>
    <td colspan="3" class="menubrd">
<div align="center" style="font-size: 12px;">

<form action="" method="POST">
        <table width="70%" border="0" align="center" style="font-size: 12px;"> 
                <tr>
                        <td align="left" width="95"> Вашето име или прякор:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="45" ></td> 
            </tr> 
                <tr> 
                        <td align="left"> Виц:</td></tr>
                        <tr>
                        <td align="center">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 

                        <td align="center">
<select name="cat"> 
                        <option value="0">Изберете категория</option> 
                        <?php 
                        $r = mysql_query("SELECT * FROM vicove_cat ORDER BY id ASC"); 
                        while($row = mysql_fetch_array($r)){ 
                        $cat .= "<option value=\"$row[value]\">$row[value]</option>"; 
                        } 
                        echo $cat; 
                        ?></td> 
                </tr> 
<tr> 
                        <td colspan="3" align="center">
                        <input name="button" type="submit" value="Качи" /> 
                        </td> 
                </tr> 
                        </table> 
  </form> 

<?
include "conn.php";
$button=$_POST['button'];
if($button){
$ot=htmlspecialchars($_POST['ot']);
$vic=htmlspecialchars($_POST['vic']);
$date = date("j-n-Y, H:i:s"); 
$cat=htmlspecialchars($_POST['cat']);
if(empty($ot) OR ($cat=="0") OR empty($vic)){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, vic, date, cat) VALUES ('','$ot', '$vic', '$date', '$cat')") or die(mysql_error());
echo "<div class='success'>Вицът е добавен успешно!</div>"; 
header('Location: index.php');
}
}
?>

</div>
</td>
    </tr>
 
        <tr>
    <td><img src="images/dmenul.gif" alt=""></td>
    <td width="100%" class="dmenubg"></td>
    <td><img src="images/dmenur.gif" alt=""></td>
  </tr>
</table>
<br>
                
        
        </td>
PHP:
<td width="60%" valign="top">
        
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="images/menuc.gif" alt=""></td>
    <td width="100%" class="menubg">Добави виц</td>
    <td><img src="images/menuc.gif" alt=""></td>
  </tr>
  <tr>
    <td colspan="3" class="menubrd">
<div align="center" style="font-size: 12px;">

<form action="" method="POST">
        <table width="70%" border="0" align="center" style="font-size: 12px;"> 
                <tr>
                        <td align="left" width="95"> Вашето име или прякор:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="45" ></td> 
            </tr> 
                <tr> 
                        <td align="left"> Виц:</td></tr>
                        <tr>
                        <td align="center">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 

                        <td align="center">
<select name="cat"> 
                        <option value="0">Изберете категория</option> 
                        <?php 
                        $r = mysql_query("SELECT * FROM vicove_cat ORDER BY id ASC"); 
                        while($row = mysql_fetch_array($r)){ 
                        $cat .= "<option value=\"$row[value]\">$row[value]</option>"; 
                        } 
                        echo $cat; 
                        ?></td> 
                </tr> 
<tr> 
                        <td colspan="3" align="center">
                        <input name="button" type="submit" value="Качи" /> 
                        </td> 
                </tr> 
                        </table> 
  </form> 

<?
include "conn.php";
$button=$_POST['button'];
if($button){
$ot=htmlspecialchars($_POST['ot']);
$vic=htmlspecialchars($_POST['vic']);
$date = date("j-n-Y, H:i:s"); 
$cat=htmlspecialchars($_POST['cat']);
if(empty($ot) OR ($cat=="0") OR empty($vic)){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, vic, date, cat) VALUES ('','$ot', '$vic', '$date', '$cat')") or die(mysql_error());
echo "<div class='success'>Вицът е добавен успешно!</div>"; 
unset($button);
unset($ot);
unset($vic);
unset($date);
unset($cat);
}
}
?>

</div>
</td>
    </tr>
 
        <tr>
    <td><img src="images/dmenul.gif" alt=""></td>
    <td width="100%" class="dmenubg"></td>
    <td><img src="images/dmenur.gif" alt=""></td>
  </tr>
</table>
<br>
                
        
        </td>
 
Промених си коментара. Това са двата варианта. Няма начин да не става!
 
Така?
PHP:
<td width="60%" valign="top">
        
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><img src="images/menuc.gif" alt=""></td>
    <td width="100%" class="menubg">Добави виц</td>
    <td><img src="images/menuc.gif" alt=""></td>
  </tr>
  <tr>
    <td colspan="3" class="menubrd">
<div align="center" style="font-size: 12px;">

<form action="" method="POST">
        <table width="70%" border="0" align="center" style="font-size: 12px;"> 
                <tr>
                        <td align="left" width="95"> Вашето име или прякор:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="45" ></td> 
            </tr> 
                <tr> 
                        <td align="left"> Виц:</td></tr>
                        <tr>
                        <td align="center">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 

                        <td align="center">
<select name="cat"> 
                        <option value="0">Изберете категория</option> 
                        <?php 
                        $r = mysql_query("SELECT * FROM vicove_cat ORDER BY id ASC"); 
                        while($row = mysql_fetch_array($r)){ 
                        $cat .= "<option value=\"$row[value]\">$row[value]</option>"; 
                        } 
                        echo $cat; 
                        ?></td> 
                </tr> 
<tr> 
                        <td colspan="3" align="center">
                        <input name="button" type="submit" value="Качи" /> 
                        </td> 
                </tr> 
                        </table> 
  </form> 

<?
include "conn.php";
$button=$_POST['button'];
if($button){
$ot=htmlspecialchars($_POST['ot']);
$vic=htmlspecialchars($_POST['vic']);
$date = date("j-n-Y, H:i:s"); 
$cat=htmlspecialchars($_POST['cat']);
if(empty($ot) OR ($cat=="0") OR empty($vic)){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, vic, date, cat) VALUES ('','$ot', '$vic', '$date', '$cat')") or die(mysql_error());
echo "<div class='success'>Вицът е добавен успешно!</div>"; 

}
unset($button);
unset($ot);
unset($vic);
unset($date);
unset($cat);
}
?>

</div>
</td>
    </tr>
 
        <tr>
    <td><img src="images/dmenul.gif" alt=""></td>
    <td width="100%" class="dmenubg"></td>
    <td><img src="images/dmenur.gif" alt=""></td>
  </tr>
</table>
<br>
                
        
        </td>
 

Back
Горе