<?php
   //fetch.php
if(isset($_POST["query"])){
 $connect = mysqli_connect("private", "private", "private", "private");
 $request = mysqli_real_escape_string($connect, $_POST['query']);
 $query = "
  SELECT * FROM search_product
  WHERE produktnamn LIKE '%".$request."%'
  OR specifikationer LIKE '%".$request."%'
 ";
 $result = mysqli_query($connect, $query);
 $data = array();
 $html = '';
 $html .= '
  <table class="table table-bordered table-striped">
   <tr>
    <th>Name</th>
    <th>Specifications</th>
   </tr>
';
  }
 }if(mysqli_num_rows($result) == 0){
  $data = 'No Data Found';
  $html .= '
   <tr>
    <td colspan="3">No Results Found</td>
   </tr>
   ';
 }
 $html .= '</table>';
 if(isset($_POST['typehead_search']))
 {
  echo $html;
 }
 else
 {
  array_unique($data);
  echo json_encode($data);
 }
}

?>