php - Search User Specific information -

new php please specific. once user logs in come form submit data. user able search data entered them in past month. edit or delete if wish. code use search please. below have (search not working @ all)

    <h1>welcome!</h1>      <form action="<?php echo $_server['php_self']; ?>" method="get"> search: <input type="text" name="search"> <input type="submit" value="submit">     </form>        <?php  // check if form value // submitted, if not // assign default value if(isset($_get['search'])){     $s = $_get['search']; }else{     $s = "%"; }   //echo $s;  // connects database mysql_connect("localhost","sample","qwerty") or die("error " . mysqli_error($link));  // selects of databases use mysql_select_db('crm');  // create , runs query $sql = "select * hours employee_id 'rhilfi'"; //echo $sql;  $results = mysql_query($sql);    echo "<br /><br />"; // loops though of results while($results_array = mysql_fetch_array($results)){      /*     echo "<pre>";     print_r($results_array);     echo "</pre>";     */     //print_r($results_array);     echo " employee id: " . $results_array['employee_id'] . " , date: " .      $results_array['date'] . " , rate of pay: " . $results_array['rate_of_pay'] . " , hours: " . $results_array['hours'] ." , amount due: " . $results_array['amount_due']. " [ <a href=\"edit.php?id=" . $results_array['hours'] . "\">edit</a>]";      /*     // use 1     echo $results_array['title'] . " " . $results_array['director'] . " [ <a href=\"edit.php?id=" . $results_array['hours'] . "\">edit</a>]";     */       echo "<br />";  }     ?>      <h1>submit new claim</h1>      <form action="<?php echo $_server['php_self']; ?>" method="get"> employee id: <input type="text" name="employee_id"> <br /> date (yyyy/mm/dd): <input type="text" name="date"> <br /> rate of pay: <input type="text" name="rate_of_pay"> <br />     hours: <input type="text" name="hours"> <br />     amount due: <input type="text" name="amount_due"> <br /> <input type="submit" value="submit">     </form>         <?php   if(isset($_get['employee_id'])){     $employee_id = $_get['employee_id'];     $date = $_get['date'];     $rate_of_pay = $_get['rate_of_pay'];     $hours = $_get['hours'];     $amount_due = $_get['amount_due']; }else{     $employee_id = "";     $date = "";     $rate_of_pay = "";     $hours = "";     $amount_due = ""; }   if(isset($_get['employee_id'])){     //echo "insert new record";     // insert new record      // connects database     mysql_connect("localhost","sample","qwerty") or die("error " .  mysqli_error($link));     // selects of databases use     mysql_select_db('crm');      // create , runs query     // insert `sample`.`dvd` (`dvd_id`, `title`, `year`, `director`) values  (null, 'title', '1234', 'director');      //$sql = "insert crm . 'hours' (employee_id, date, rate_of_pay, hours, amount_due) values (null, '$employee_id', '$date', '$rate_of_pay', '$hours', $amount_due)";     $sql = "insert hours (id, employee_id, date, rate_of_pay, hours, amount_due) values (null, '$employee_id', '$date', '$rate_of_pay', '$hours', $amount_due)";     //echo $sql;     $results = mysql_query($sql);      echo "<br /><br />";       // optional     if(mysql_affected_rows() >= 1){         echo "<h3>thank you! have submitted claim </h3>";     }  }      ?>    <a href="login.php">log out</a> 

use mysqli instead , if you're using in mysql make looks this:

$sql = "select * hours employee_id '%rhilfi%'";