Advertisement
Guest User

Untitled

a guest
Jan 17th, 2020
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.14 KB | None | 0 0
  1. <?php
  2.  
  3. $connect = mysqli_connect("cseemyweb.essex.ac.uk", "hm18359", "j5j06KkfIyVAk", "ce29x_hm18359");
  4. $output = '';
  5. if(isset($_POST["query"]))
  6. {
  7.  $search = mysqli_real_escape_string($connect, $_POST["query"]);
  8.  $query = "SELECT * FROM Car
  9.          INNER JOIN Manufacturer
  10.          ON Car.manu_id = Manufacturer.manu_id
  11.          INNER JOIN User
  12.          ON Car.user_id = User.user_id
  13.          WHERE  id  LIKE '%".$search."%'
  14.          OR year LIKE '%".$search."%'
  15.          OR manufacturerName LIKE '%".$search."%'
  16.          OR model LIKE '%".$search."%'
  17.          OR retailPrice LIKE '%".$search."%'
  18.          OR owner LIKE '%".$search."%'
  19. ";}
  20. else
  21. {
  22.  $query = "SELECT * FROM Car
  23.          INNER JOIN Manufacturer
  24.          ON Car.manu_id = Manufacturer.manu_id
  25.          INNER JOIN User
  26.          ON Car.user_id = User.user_id";
  27. }
  28. $result = mysqli_query($connect, $query);
  29. if(mysqli_num_rows($result) > 0)
  30. {
  31.    while($row = mysqli_fetch_array($result))
  32.    {
  33.     $output .= '
  34.   <tr>
  35.     <td>'.$row["id"].'</td>
  36.     <td>'.$row["year"].'</td>
  37.    </tr>';
  38.    }
  39.    echo $output;
  40. }
  41. else
  42. {
  43.  echo 'Record Not Found';
  44. }
  45.  
  46. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement