<?include "conninfo.php";
$srch=$_POST["search"];//bring from POST data


echo "<h1>Search Results:</h1>";

$query="SELECT * FROM people WHERE surname like '$srch'";
$result=mysqli_query($link,$query);


if($numrows==0)//nothing found in database (no rows matching)
{
	echo "Sorry nothing found";
}
else
{
	echo $numrows." results found:<br><br>";
	
	while($r=mysqli_fetch_array($result))
	{
	$postcode=$r["postcode"];
	$postcode=strtoupper($postcode);
	echo $r["id"]." ";
	echo $r["firstname"]." ";
	echo $r["surname"]." ";
	echo $r["favfood"]." ";
	echo $postcode."<br>";
	}
}
mysqli_stmt_close($stmt);
mysqli_close($link);
?>