File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/department_position/update_department.php
Back
<?php include_once("../../cfg/db.php"); // $get_id = $_POST['id']; // $department_id_conv = implode("", $get_id); $id = $db->escape(trim($_POST['id'])); $name = $db->escape(trim($_POST['name'])); $code = $db->escape(trim($_POST['code'])); if(intval($db -> select("SELECT count(1) FROM employee_department WHERE department_code = '$code' AND id != '$id'")) > 0){ $arr['status'] = 0; //duplicate code } else if(intval($db -> select("SELECT count(1) FROM employee_department WHERE department_name = '$name' AND id != '$id'")) > 0){ $arr['status'] = 1; //duplicate name } else { $update_query = "UPDATE `employee_department` SET `department_code` = '$code', `department_name`='$name' WHERE id = '$id'"; $db->sql_query($update_query); $arr['status'] = 2; //success update } echo json_encode($arr); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings