검색을 위한 쿼리변경

값이 존재하면

isset($_POST["search_option"])

 

$option="";


if( isset($_POST["search_option"]) ){
	
	$search_option =$_POST["search_option"];
	
	$search =$_POST["search"];
	
	$option="  and  ".$search_option."  like '%".$search . "%'";
	
}


	$sql ="select * from guestbook  where idx > 0 
	    	$option  
		  order by idx desc";

	echo $sql;  
	 
	$rs =mysql_query($sql);
	$count=mysql_num_rows($rs);
	

 

선택 되게 옵션 변경

 

echo "
	<form method='post'  name='form1'>
		<select name='search_option'>";
?>
	
	
 <option value='name' 
 
 <?php 
 	if(isset($_POST["search_option"])){ if($search_option=="name") {echo "selected";}}; 
 
 ?>
  >이름</option>
 
 <option value='content'
  <?php 
  
  	if(isset($_POST["search_option"])){if($search_option=="name") {echo "selected";}; }
  ?>
  
  >내용</option>
  
  
    
<?php 
	echo	"</select>
		<input type='text' name='search' value='$search'>
		<input type='submit' value'검색'>
	</form>
";

 

전체 코드 내용

 

<?php

include("dbcon.php");


$option="";


if( isset($_POST["search_option"]) ){
	
	$search_option =$_POST["search_option"];
	
	$search =$_POST["search"];
	
	$option="  and  ".$search_option."  like '%".$search . "%'";
	
}


	$sql ="select * from guestbook  where idx > 0 
	    	$option  
		  order by idx desc";

	echo $sql;  
	 
	$rs =mysql_query($sql);
	$count=mysql_num_rows($rs);
	


echo "<a href='write.html'>작성</a><br/>";
echo "글 등록 수 $count 개<br/>";


echo "
	<form method='post'  name='form1'>
		<select name='search_option'>";
?>
	
	
 <option value='name' 
 
 <?php 
 	if(isset($_POST["search_option"])){ if($search_option=="name") {echo "selected";}}; 
 
 ?>
  >이름</option>
 
 <option value='content'
  <?php 
  
  	if(isset($_POST["search_option"])){if($search_option=="name") {echo "selected";}; }
  ?>
  
  >내용</option>
  
  
    
<?php 
	echo	"</select>
		<input type='text' name='search' value='$search'>
		<input type='submit' value'검색'>
	</form>
";
echo "<table border='1' >";


echo 
"<tr>
	<th>번호</th>
	<th>이름</th>
	<th>내용</th>
	<th>이메일</th>
	<th>날짜</th>
	</tr>
";
while($row = mysql_fetch_array($rs)){
	echo "
	<tr>
	<td>$row[idx]</td>		
	<td>$row[name] </td>
	<td><a href='view.php?idx=$row[idx]'>$row[content]</a></td>
	<td>$row[email]</td>
	<td>$row[post_date]</td>		

	 </tr>";
}

mysql_close();
?>