File manager - Edit - /home/autoph/public_html/connectv1/app/department_position/search_department.php
Back
<?php include_once("../../cfg/db.php"); $search_item = $db->escape(trim($_POST['search_item'])); $search_query = "SELECT ed.id, ed.department_name, ed.department_code FROM employee_department ed WHERE (department_code LIKE '%$search_item%' OR department_name LIKE '%$search_item%') AND id != 0 AND status != 0"; //echo $search_query; return; $result = $db->sql_query($search_query); //echo $search_query; return; while($row = $result->fetch_assoc()) { echo '<option value="'.$row['id'].'">'.$row["department_code"].' - '.$row["department_name"].'</option>'; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings