File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/misc/get_employee.php
Back
<?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); ?>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings