Да проверява дали няма вече записан виц със същото Име

stefan122 · 10 Март 2011

това е файла чрез който се добавят:

Код:

<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="49" ></td> 
	    </tr> 
		
		
		
		<tr> 
			<td align="left"> *Описание:</td></tr>
			<tr>
			<td align="left">
			<textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
		</tr> 


		
			<td align="left">
			*Изберете категория: <br />
<select name="cat"> 

			<?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("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
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 '<script type="text/javascript">
setTimeout(\'window.location="http://abv.bg"\', 1);
</script>';
}
}
?>

</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>

MaLa_NocHe · 10 Март 2011

stefan122 каза:

това е файла чрез който се добавят:

Код:

<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="49" ></td> 
	    </tr> 
		
		
		
		<tr> 
			<td align="left"> *Описание:</td></tr>
			<tr>
			<td align="left">
			<textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
		</tr> 


		
			<td align="left">
			*Изберете категория: <br />
<select name="cat"> 

			<?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("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
$sql = "SELECT SQL_CACHE * FROM vicove WHERE ot = '$ot'";
	$result = mysql_query($sql) or die (mysql_error());
$broi = mysql_num_rows($result);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
if ($broi >= 1) {
			echo "<center>Този виц вече го има в сайта.</center>";
		}
		else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, vic, date, cat) VALUES ('','$ot', '$vic', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.bg"\', 1);
</script>';
}
}
}
?>

</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>

stefan122 · 11 Март 2011

а с този как ще стане:

<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"> *1:</td>
</tr><tr>
<td align="left">
<input name="ot" type="text" size="49" ></td>
</tr>

<tr>
<td align="left" width="95"> *2:</td>
</tr><tr>
<td align="left">
<input name="url" type="text" size="49" ></td>
</tr>

<tr>
<td align="left"> *3:</td></tr>
<tr>
<td align="left">
<textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td>
</tr>

<tr>
<td align="left" width="95"> *4:</td>
</tr><tr>
<td align="left">
<input name="ime" type="text" size="49" ></td>
</tr>

<tr>
<td align="left" width="95"> *5:</td>
</tr><tr>
<td align="left">
<input name="email" type="text" size="49" ></td>
</tr>

<td align="left">
* категория: <br />
<select name="cat">

<?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']);
$url=htmlspecialchars($_POST['url']);
$vic=htmlspecialchars($_POST['vic']);
$ime=htmlspecialchars($_POST['ime']);
$email=htmlspecialchars($_POST['email']);
$date = date("m.d.y");
$cat=htmlspecialchars($_POST['cat']);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, url, vic, ime, email, date, cat) VALUES ('','$ot', '$url', '$vic', '$ime', '$email', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.eu"\', 1);
</script>';
}
}
?>

</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>

tedo96 · 11 Март 2011

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"> *1:</td> 
</tr><tr>
			<td align="left">
			<input name="ot" type="text" size="49" ></td> 
	    </tr> 
			
				<tr>
			<td align="left" width="95"> *2:</td> 
</tr><tr>
			<td align="left">
			<input name="url" type="text" size="49" ></td> 
	    </tr> 				
		<tr> 
			<td align="left"> *3:</td></tr>
			<tr>
			<td align="left">
			<textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
		</tr> 
		<tr>
			<td align="left" width="95"> *4:</td> 
</tr><tr>
			<td align="left">
			<input name="ime" type="text" size="49" ></td> 
	    </tr> 		
		<tr>
			<td align="left" width="95"> *5:</td> 
</tr><tr>
			<td align="left">
			<input name="email" type="text" size="49" ></td> 
	    </tr> 	
			<td align="left">
			* категория: <br />
<select name="cat"> 

			<?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']);
$url=htmlspecialchars($_POST['url']);
$vic=htmlspecialchars($_POST['vic']);
$ime=htmlspecialchars($_POST['ime']);
$email=htmlspecialchars($_POST['email']);
$date = date("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
if ($broi >= 1) {
         echo "<center>Този виц вече го има в сайта.</center>";
      }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, url, vic, ime, email, date, cat) VALUES ('','$ot', '$url', '$vic', '$ime', '$email', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.eu"\', 1);
</script>';
}
}
}
?>
</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>

stefan122 · 11 Март 2011

не ще...

начина на MaLa_NocHe работи... аз не можах да го приложа и на този код

tedo96 · 11 Март 2011

Промених си коментара.

stefan122 · 11 Март 2011

пак не става

tedo96 · 11 Март 2011

Последен опит!

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"> *1:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="49" ></td> 
            </tr> 
                        
                                <tr>
                        <td align="left" width="95"> *2:</td> 
</tr><tr>
                        <td align="left">
                        <input name="url" type="text" size="49" ></td> 
            </tr>                               
                <tr> 
                        <td align="left"> *3:</td></tr>
                        <tr>
                        <td align="left">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 
                <tr>
                        <td align="left" width="95"> *4:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ime" type="text" size="49" ></td> 
            </tr>               
                <tr>
                        <td align="left" width="95"> *5:</td> 
</tr><tr>
                        <td align="left">
                        <input name="email" type="text" size="49" ></td> 
            </tr>       
                        <td align="left">
                        * категория: <br />
<select name="cat"> 

                        <?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']);
$url=htmlspecialchars($_POST['url']);
$vic=htmlspecialchars($_POST['vic']);
$ime=htmlspecialchars($_POST['ime']);
$email=htmlspecialchars($_POST['email']);
$date = date("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
$sql = "SELECT SQL_CACHE * FROM vicove WHERE ot = '$ot'";
$result = mysql_query($sql) or die (mysql_error());
$broi = mysql_num_rows($result);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
elseif ($broi >= 1) {
         echo "<center>Този виц вече го има в сайта.</center>";
      }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, url, vic, ime, email, date, cat) VALUES ('','$ot', '$url', '$vic', '$ime', '$email', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.eu"\', 1);
</script>';
}
}
}
?>
</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>

stefan122 · 11 Март 2011

дава грешка:

Parse error: syntax error, unexpected '{', expecting '(' in

на 79 ред има elseif {

tedo96 · 11 Март 2011

Сега....? Трябва да се науча, че не трябва да пиша код след тренировки..

stefan122 · 11 Март 2011

пак не ...

tedo96 · 11 Март 2011

Оооо колко съм прост! Сега вече ще работи!

Аз си ползвам $broi, но къде подяволите е дефинирам? Никъде... Сега няма начин да не е ОК!

stefan122 · 11 Март 2011

съжелявам, пак се публикуват повторно също....

tedo96 · 11 Март 2011

В тази тема нали искаше проверка дали вече няма качено....

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"> *1:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="49" ></td> 
            </tr> 
                        
                                <tr>
                        <td align="left" width="95"> *2:</td> 
</tr><tr>
                        <td align="left">
                        <input name="url" type="text" size="49" ></td> 
            </tr>                               
                <tr> 
                        <td align="left"> *3:</td></tr>
                        <tr>
                        <td align="left">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 
                <tr>
                        <td align="left" width="95"> *4:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ime" type="text" size="49" ></td> 
            </tr>               
                <tr>
                        <td align="left" width="95"> *5:</td> 
</tr><tr>
                        <td align="left">
                        <input name="email" type="text" size="49" ></td> 
            </tr>       
                        <td align="left">
                        * категория: <br />
<select name="cat"> 

                        <?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']);
$url=htmlspecialchars($_POST['url']);
$vic=htmlspecialchars($_POST['vic']);
$ime=htmlspecialchars($_POST['ime']);
$email=htmlspecialchars($_POST['email']);
$date = date("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
$sql = "SELECT SQL_CACHE * FROM vicove WHERE ot = '$ot'";
$result = mysql_query($sql) or die (mysql_error());
$broi = mysql_num_rows($result);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
else {
if ($broi >= 1) {
         echo "<center>Този виц вече го има в сайта.</center>";
      }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, url, vic, ime, email, date, cat) VALUES ('','$ot', '$url', '$vic', '$ime', '$email', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.eu"\', 1);
</script>';
}
}
}
?>
</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>

или:

Аз бих го направил по друг начин и затова правя толкова грешки, но следвам примера на момчето.
Аз бих си минал стойностите на заявката като масив и бих проверявал дали
$row['name'] е равно на $_POST['name']

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"> *1:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ot" type="text" size="49" ></td> 
            </tr> 
                        
                                <tr>
                        <td align="left" width="95"> *2:</td> 
</tr><tr>
                        <td align="left">
                        <input name="url" type="text" size="49" ></td> 
            </tr>                               
                <tr> 
                        <td align="left"> *3:</td></tr>
                        <tr>
                        <td align="left">
                        <textarea name="vic" style="width: 350px; height: 125px;"> </textarea></td> 
                </tr> 
                <tr>
                        <td align="left" width="95"> *4:</td> 
</tr><tr>
                        <td align="left">
                        <input name="ime" type="text" size="49" ></td> 
            </tr>               
                <tr>
                        <td align="left" width="95"> *5:</td> 
</tr><tr>
                        <td align="left">
                        <input name="email" type="text" size="49" ></td> 
            </tr>       
                        <td align="left">
                        * категория: <br />
<select name="cat"> 

                        <?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']);
$url=htmlspecialchars($_POST['url']);
$vic=htmlspecialchars($_POST['vic']);
$ime=htmlspecialchars($_POST['ime']);
$email=htmlspecialchars($_POST['email']);
$date = date("m.d.y"); 
$cat=htmlspecialchars($_POST['cat']);
$sql = "SELECT SQL_CACHE * FROM vicove WHERE ot = '$ot'";
$result = mysql_query($sql) or die (mysql_error());
$broi = mysql_num_rows($result);
if($ot == NULL || ($cat == '0') || $cat == NULL || $vic == NULL || $url == NULL || $ime == NULL || $email == NULL){
echo "<div class='unsuccess'>Моля, попълнете нужните полета.</div>"; }
elseif ($broi >= 1) {
         echo "<center>Този виц вече го има в сайта.</center>";
      }
else {
$sql=mysql_query("INSERT INTO `vicove` (id, ot, url, vic, ime, email, date, cat) VALUES ('','$ot', '$url', '$vic', '$ime', '$email', '$date', '$cat')") or die(mysql_error());
echo '<script type="text/javascript">
setTimeout(\'window.location="http://abv.eu"\', 1);
</script>';
}
}
}
?>
</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>

Да проверява дали няма вече записан виц със същото Име

stefan122

Registered

MaLa_NocHe

Registered

stefan122

Registered

tedo96

Registered

stefan122

Registered

tedo96

Registered

stefan122

Registered

tedo96

Registered

stefan122

Registered

tedo96

Registered

stefan122

Registered

tedo96

Registered

stefan122

Registered

tedo96

Registered