[Help] If-чета и else-чета

ivowe3 · Jul 2, 2011

Здравейте,
Този код работи, но когато му сложа If не засича резултатите от базата данни.

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
   while ($row = mysql_fetch_assoc($our))

   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$row[raz]<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
	<td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
	</tr>
</table>";
}

?>

Не работещия изглежда така: Някой вижда ли грешката?

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row[raz] == 1){ $raza ='HDTV';}
else{$raza =$row[raz];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
 </tr>
</table>";
}

?>

Milanoob · Jul 3, 2011

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row[raz] == 1){$raza ='HDTV';}
else{$raza = $row['raz'];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
    <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
    </tr>
</table>";
}

?>

Грешката ти беше ето тук:
if($row[raz] == 1){ $raza ='HDTV';}
else{$raza =$row[raz];}
Поправен:
if($row[raz] == 1){$raza ='HDTV';}
else{$raza = $row['raz'];}

KR373N · Jul 3, 2011

опитай така

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row[raz] == 1){ $raza ='HDTV';}
else{$raza =$row['raz'];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
 </tr>
</table>";
}

?>

ivowe3 · Jul 3, 2011

KR373N said:

опитай така

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row[raz] == 1){ $raza ='HDTV';}
else{$raza =$row['raz'];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
 </tr>
</table>";
}

?>

Благодаря, но не се получи.

Damian · Jul 3, 2011

Виш дали колоната "raz" в базата данни се пише точно така понеже в твоя случай големите и малките букви имат значение.

ivowe3 · Jul 3, 2011

Точно така се пише.

Когато е без if скрипта работи перфектно, но когато сложа if нещата се оплескват.

Искам да попитам и за защитата. Как да защитя заявките...

ivowe3 · Jul 3, 2011

Извинявам се за двойният пост ако искате мога да ви дам и останалата част от скрипта. HTML-то, но не мисля, че ще ви потрябва.

Coolio · Jul 3, 2011

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row['raz'] == 1){ $raza ='HDTV';}
else{$raza =$row['raz'];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
 </tr>
</table>";
}

?>

Изпуснал си двете кавички във if-a така трябва да работи.

ivowe3 · Jul 3, 2011

Coolio said:

PHP:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = mysql_escape_string($_POST["name"]);
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   
   $our = mysql_query("SELECT * FROM movie where raz like '%".$raz."%' AND janr1 like '%".$cat."%' or janr2 like '%".$cat."%' or janr3 like '%".$cat."%' AND name like '%".$name."%' ORDER BY id DESC");
while ($row = mysql_fetch_assoc($our))

if($row['raz'] == 1){ $raza ='HDTV';}
else{$raza =$row['raz'];}

   
   echo "<table align=center border=1  width=90%>
<tr>
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td>
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>, 
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>, 
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>, 
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>, 
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td>
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td>
 </tr>
</table>";
}

?>

Изпуснал си двете кавички във if-a така трябва да работи.

И така не работи. Някакви други идеи???

Coolio · Jul 3, 2011

PHP:

<?php 
include("config.php"); 
if(isset($_POST['submit'])) { 
    
   $name = mysql_escape_string($_POST['name']); 
   $raz = $_POST['raz']; 
   $cat = $_POST['cat']; 
   
    
   $our = mysql_query("SELECT * FROM movie where raz like ".$raz." AND janr1 like ".$cat." or janr2 like ".$cat." or janr3 like ".$cat." AND name like ".$name." ORDER BY id DESC"); 
while ($row = mysql_fetch_assoc($our)) 

if($row['raz'] == 1){ $raza ='HDTV';}     
   echo "<table align=center border=1  width=90%> 
<tr> 
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td> 
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>,  
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>,  
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>,  
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>,  
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td> 
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td> 
 </tr> 
</table>";
else{$raza = $row['raz'];}  
   echo "<table align=center border=1  width=90%> 
<tr> 
    <td width=50%><b>[</b>$raza<b>]</b>$row[name]</td> 
    <td width=30%><b>[</b><a href=$row[link1]>LINK 1</a><b>]</b>,  
<b>[</b><a href=$row[link2]>LINK 2</a><b>]</b>,  
<b>[</b><a href=$row[link3]>LINK 3</a><b>]</b>,  
<b>[</b><a href=$row[link4]>LINK 4</a><b>]</b>,  
<b>[</b><a href=$row[link5]>LINK 5</a><b>]</b></td> 
 <td width=20%>$row[janr1], $row[janr2], $row[janr3]</td> 
 </tr> 
</table>";
} 

?>

Я провери така ще го бъде ли ?

ivowe3 · Jul 3, 2011

PHP:

else{$raza = $row['raz'];}

Parse error: parse error on line 68

ПП: не разглеждайте само if-четата може да идва от другаде тази грешка.
ПП2: грешката след като му сложа if-че е, че не излизат резултатите от базата данни

Coolio · Jul 3, 2011

ivowe3 said:
PHP:

else{$raza = $row['raz'];}

Parse error: parse error on line 68

Направи го така:

PHP:

else{$raza == $row['raz'];}

ivowe3 · Jul 3, 2011

пак така.... Parse error: parse error on line 68

FrozeN · Jul 3, 2011

Code:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = $_POST['name'];
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   $our = mysql_query("SELECT * FROM movie where raz like '%$raz%' AND janr1 like '%$cat%' or janr2 like '%$cat%' or janr3 like '%$cat%' AND name like '%$name%' ORDER BY id DESC");
  
	while ($row = mysql_fetch_assoc($our)) {
	if($row[raz] == 1){ $raz = "HDTV"; }
		else { $raz = $row[raz]; }
echo "
<table align='center' border='1'  width='90%'>
	<tr>
		<td width='50%'><b>[</b>$row[raz]<b>]</b>$row[name]</td>
		<td width='30%'><b>[</b><a href='$row[link1]'>LINK 1</a><b>]</b>, 
			<b>[</b><a href='$row[link2]'>LINK 2</a><b>]</b>, 
			<b>[</b><a href='$row[link3]'>LINK 3</a><b>]</b>, 
			<b>[</b><a href='$row[link4]'>LINK 4</a><b>]</b>, 
			<b>[</b><a href='$row[link5]'>LINK 5</a><b>]</b></td>
		<td width='20%'>$row[janr1], $row[janr2], $row[janr3]</td>
    </tr>
</table>";
}

}
?>

ivowe3 · Jul 3, 2011

FrozeN said:

Code:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = $_POST['name'];
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   $our = mysql_query("SELECT * FROM movie where raz like '%$raz%' AND janr1 like '%$cat%' or janr2 like '%$cat%' or janr3 like '%$cat%' AND name like '%$name%' ORDER BY id DESC");
  
	while ($row = mysql_fetch_assoc($our)) {
	if($row[raz] == 1){ $raz = "HDTV"; }
		else { $raz = $row[raz]; }
echo "
<table align='center' border='1'  width='90%'>
	<tr>
		<td width='50%'><b>[</b>$row[raz]<b>]</b>$row[name]</td>
		<td width='30%'><b>[</b><a href='$row[link1]'>LINK 1</a><b>]</b>, 
			<b>[</b><a href='$row[link2]'>LINK 2</a><b>]</b>, 
			<b>[</b><a href='$row[link3]'>LINK 3</a><b>]</b>, 
			<b>[</b><a href='$row[link4]'>LINK 4</a><b>]</b>, 
			<b>[</b><a href='$row[link5]'>LINK 5</a><b>]</b></td>
		<td width='20%'>$row[janr1], $row[janr2], $row[janr3]</td>
    </tr>
</table>";
}

}
?>

Здравей,

С риск да те обидя, в кода няма грам смисъл относно if-а, защото след това си сложил в echo $row[raz] което няма да помогне особено.

FrozeN · Jul 4, 2011

Бях копирал първия код и него променях виж така

Code:

<?php
include("config.php");
if(isset($_POST['submit'])) {
   
   $name = $_POST['name'];
   $raz = $_POST['raz'];
   $cat = $_POST['cat'];
  
   $our = mysql_query("SELECT * FROM movie where raz like '%$raz%' AND janr1 like '%$cat%' or janr2 like '%$cat%' or janr3 like '%$cat%' AND name like '%$name%' ORDER BY id DESC");
  
	while ($row = mysql_fetch_assoc($our)) {
	if($row[raz] == 1){ $raza = "HDTV"; }
		else { $raz = $row[raz]; }
echo "
<table align='center' border='1'  width='90%'>
	<tr>
		<td width='50%'><b>[</b>$raza<b>]</b>$row[name]</td>
		<td width='30%'><b>[</b><a href='$row[link1]'>LINK 1</a><b>]</b>, 
			<b>[</b><a href='$row[link2]'>LINK 2</a><b>]</b>, 
			<b>[</b><a href='$row[link3]'>LINK 3</a><b>]</b>, 
			<b>[</b><a href='$row[link4]'>LINK 4</a><b>]</b>, 
			<b>[</b><a href='$row[link5]'>LINK 5</a><b>]</b></td>
		<td width='20%'>$row[janr1], $row[janr2], $row[janr3]</td>
    </tr>
</table>";
}

}
?>

ivowe3 · Jul 4, 2011

Проблемът вече е решен с помоща на Damian и XTYLING

XTYLING помогна за if-овете
Damian за останалото.

Search

Search

[Help] If-чета и else-чета

ivowe3

Wiki

Milanoob

Active Member

KR373N

Well-Known Member

ivowe3

Wiki

Damian

Team Member

ivowe3

Wiki

ivowe3

Wiki

Coolio

Active Member

ivowe3

Wiki

Coolio

Active Member

ivowe3

Wiki

Coolio

Active Member

ivowe3

Wiki

FrozeN

New Member

ivowe3

Wiki

FrozeN

New Member

ivowe3

Wiki