TalkPHP - View Single Post - [SOS]a search for a database ,double click here

webtuto · 01-06-2008, 09:37 PM

hi ,
well im trying to do a search form for my database here is the code =>

PHP Code:


			
<?php



if(!empty($_POST['search']) ) {

$con = mysql_connect("localhost","root","") ;

$db = mysql_select_db("test") ;

$sql = "select * from webt where name='%$_POST[search]%' ";

$res = mysql_query($sql) ;

if (mysql_num_rows($res) == 0 ) {

          echo "No result";

 }else{ while ($row = mysql_fetch_array($res) ) {

       

      echo $row[name]."<br><br>" ; 

       }

       

}

}else{ echo"full the form"; } 



?>

<form method="post" action="search.php" >

<b>Search</b><input type="text" name="search" >

<input type="submit" value="Search" >

</form>

and in the database there is name='aa'
name is the name of the column
anyway when i delete "%" the code works great but when i add them it douesnt work

01-06-2008, 09:37 PM	#1 (permalink)
webtuto The Addict Join Date: Dec 2007 Location: morocco Posts: 221 Thanks: 19	[SOS]a search for a database ,double click here hi , well im trying to do a search form for my database here is the code => PHP Code: <?php if(!empty($_POST['search']) ) { $con = mysql_connect("localhost","root","") ; $db = mysql_select_db("test") ; $sql = "select * from webt where name='%$_POST[search]%' "; $res = mysql_query($sql) ; if (mysql_num_rows($res) == 0 ) { echo "No result"; }else{ while ($row = mysql_fetch_array($res) ) { echo $row[name]."<br><br>" ; } } }else{ echo"full the form"; } ?> <form method="post" action="search.php" > <b>Search</b><input type="text" name="search" > <input type="submit" value="Search" > </form> and in the database there is name='aa' name is the name of the column anyway when i delete "%" the code works great but when i add them it douesnt work