php search from database and display code example
Example 1: php mysql search database and display results
<?php
$con= new mysqli("localhost","root","","Employee");
$name = $_post['search'];
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT * FROM employees
WHERE first_name LIKE '%{$name}%' OR last_name LIKE '%{$name}%'");
while ($row = mysqli_fetch_array($result))
{
echo $row['first_name'] . " " . $row['last_name'];
echo "<br>";
}
mysqli_close($con);
?>
Example 2: search function using php for database entries
$result = mysqli_query($con, "SELECT * FROM employees
WHERE first_name LIKE '%{$name}%' OR last_name LIKE '%{$name}%'");
while ($row = mysqli_fetch_array($result))
{
echo $row['first_name'] . " " . $row['last_name'];
echo "<br>";
}
mysqli_close($con);
?>