";
}
}
if(array_key_exists('submit_by_name', $_POST))
{
$search = $_POST['key'];
$query = "SELECT * FROM employee WHERE name like '%$search%'";
$result = mysqli_query($conn,$query);
if(mysqli_num_rows($result)==0)//if no rows found
{
echo "Sorry, not found";
}
while($r = mysqli_fetch_array($result))//get a row
{
echo $r["id"]." ";
echo $r["name"]."
";
}
}
?>