webtuto Posted January 6, 2008 Share Posted January 6, 2008 hi , well im trying to do a search form for my database here is the 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 Link to comment https://forums.phpfreaks.com/topic/84783-sosa-search-for-a-database-double-click-here/ Share on other sites More sharing options...
redarrow Posted January 6, 2008 Share Posted January 6, 2008 try this............... <?php if(!empty($_POST['search']) ) { $con = mysql_connect("localhost","root","") ; $db = mysql_select_db("test",$con) ; $x=$_POST['search']; $sql = "select * from webt where search='%$x%' "; $res = mysql_query($sql) or die (mysql_error()); 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 name="submit" type="submit" value="Search" > </form> Link to comment https://forums.phpfreaks.com/topic/84783-sosa-search-for-a-database-double-click-here/#findComment-432102 Share on other sites More sharing options...
GingerRobot Posted January 6, 2008 Share Posted January 6, 2008 If you want to use wildcards, you need to use LIKE, not = : $sql = "select * from webt where name LIKE '%$_POST[search]%' "; Link to comment https://forums.phpfreaks.com/topic/84783-sosa-search-for-a-database-double-click-here/#findComment-432107 Share on other sites More sharing options...
webtuto Posted January 6, 2008 Author Share Posted January 6, 2008 thanks it solved Link to comment https://forums.phpfreaks.com/topic/84783-sosa-search-for-a-database-double-click-here/#findComment-432184 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.