<?php
   $servername = 'localhost';
   $username = 'root';
   $password = 'root';

   $conn = mysql_connect($servername, $username, $password);

   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   if(isset($_POST['textfield']) && $_POST['textfield'] != "" )
   {
      $search = $_POST['textfield'];
      echo "Searching for $search";
      // show records here
   }

   else
   {
      echo "Enter a search term";
   }

   $sql = 'SELECT name, age, gender, qualification FROM employee';
   mysql_select_db('login');
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die('Could not get data: ' . mysql_error());
   }

   while($row = mysql_fetch_assoc($retval)) {
      echo "Name :{$row['name']}  <br> ".
         "Age : {$row['age']} <br> ".
         "Gender : {$row['gender']} <br> ".
		 "Qualification : {$row['qualification']} <br> ".
         "--------------------------------<br>";
   }

   echo "Fetched data successfully\n";

   mysql_close($conn);
?>