<?php

$connect = mysqli_connect("cseemyweb.essex.ac.uk", "hm18359", "j5j06KkfIyVAk", "ce29x_hm18359");

$output = '';
if(isset($_POST["query"]))
{
 $search = mysqli_real_escape_string($connect, $_POST["query"]);
 $query = "SELECT * FROM Car
           INNER JOIN Manufacturer
           ON Car.manu_id = Manufacturer.manu_id
           INNER JOIN User
           ON Car.user_id = User.user_id
           WHERE  id  LIKE '%".$search."%'
           OR year LIKE '%".$search."%'
           OR manufacturerName LIKE '%".$search."%'
           OR model LIKE '%".$search."%'
           OR retailPrice LIKE '%".$search."%'
           OR owner LIKE '%".$search."%'
 ";}
else
{
 $query = "SELECT * FROM Car
           INNER JOIN Manufacturer
           ON Car.manu_id = Manufacturer.manu_id
           INNER JOIN User
           ON Car.user_id = User.user_id";
}
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{
   while($row = mysqli_fetch_array($result))
   {
    $output .= echo '
    <tr>
      <td>'.$row["id"].'</td>
      <td>'.$row["year"].'</td>
     </tr>';
   }
   echo $output;
}
else
{
 echo 'Record Not Found';
}

?>