<?include "conninfo.php";  //bring database connection info

$search=$_POST["thesearch"];

$query="SELECT * FROM people WHERE favfood LIKE '$search'"; 

$result=mysqli_query($link,$query);//run query on database

while($r=mysqli_fetch_array($result))
{
echo $r["id"]." ";
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["favfood"]."<br>";
}

?>


