Jump to content

[SOS]a search for a database ,double click here


webtuto

Recommended Posts

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

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>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.