<?php

   $servername = 'localhost';
   $username = 'root';
   $password = 'root';

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

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

     // check $_POST superglobal

if(isset($_POST['textfield']) && $_POST['textfield'] != "" )
{
    $search =  $_POST['textfield'];
    echo "Searching for {$_POST['textfield']} ...";
   // now exeute this query
   // select * from table where name like '$search';
}

else
{
  die("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);
?>