<?php
include_once("../../cfg/db.php");
	if(!isset($_GET['searchTerm'])){
        $json = [];
    }else{

		 $search = $_GET['searchTerm'];
		 
		  $employee_info = $db -> return_result("SELECT id,employee_id,concat(first_name,' ',middle_name,' ',last_name) as name FROM `employee` 
WHERE concat(employee_id, ' - ',first_name,' ',middle_name,' ',last_name) LIKE '%$search%' LIMIT 10"); 
			$json = [];
			foreach($employee_info as $data){
				 $json[] = ['id'=>$data['id'], 'text'=>$data['employee_id'] .' - '. $data['name']];
			}
         
	}
 echo json_encode($json);

 ?>