<?php
include 'core/database/connect.php';
//$connect_error = 'Sorry, we\'re experiencing connection problem.  Please try again later...  Thank you!';
//mysql_connect('localhost','root','aee1024') or die ($connect_error);
//mysql_select_db('db_vts') or die($connect_error);
//error_reporting(1);
$tDate = date_create() ->format("Y/m/d"); 
$tTime =Explode(":", date('H:i:s'));
$svtTime = $tTime[0].":".$tTime[1].":".$tTime[1];	

 
function get_names($conn , $term){ 
 $query = "SELECT * FROM vts_customers WHERE cust_fname LIKE '%".$term."%'  ORDER BY cust_lname ASC";
 $result = mysqli_query($conn, $query); 
 $data = mysqli_fetch_all($result,MYSQLI_ASSOC);
 return $data; 
}
 
if (isset($_GET['term'])) {
 $fname = get_names($conn, $_GET['term']);
 $nameList = array();
 foreach($getName as $name){
 $nameFList[] = $name['cust_fname'];
 $nameLList[] = $name['cust_lname'];
 }
 echo json_encode($nameList);
}
?>