<?php
include("connect1.php");
$search=$_POST['search'];
$sql="select * from record where name='$search'"; //select command  (it will select all command form table) *(selects all rows and column) 
$result=mysqli_query($con,$sql); //executing sql command and storing record to $result var
while ($row=mysqli_fetch_array($result))//  It is fetching (reading) record from $result and storing to $row variable 
{
	echo '<br>';
echo $row['id']; //Displaying record of column id 
echo "<br>";
echo $row['name']; //Displaying record of column name 
echo "<br>";
echo $row['city'];//Displaying record of column  city
echo "<br>";
}
?>
