File manager - Edit - /home/autoph/public_html/connectv1/app/department_position/add_department.php
Back
<?php include_once("../../cfg/db.php"); $new_department_name = $db->escape(trim($_POST['department_name'])); $new_department_code = $db->escape(trim($_POST['department_code'])); $current_user = $_SESSION['user']['id']; if(intval($db -> select("SELECT count(1) FROM employee_department WHERE department_name = '$new_department_name'")) > 0){ $return_arr['status'] = 0; //duplicate name echo json_encode($return_arr); } else if(intval($db -> select("SELECT count(1) FROM employee_department WHERE department_code = '$new_department_code'")) > 0){ $return_arr['status'] = 1; //duplicate code echo json_encode($return_arr); } else { // echo "INSERT INTO `source_company` (`name`, `code`) VALUES ('$new_company_name', '$new_company_code')";return; $db->sql_query("INSERT INTO `employee_department` (`department_name`, `department_code`, `add_by`) VALUES ('$new_department_name', '$new_department_code', '$current_user' )"); $return_arr['status'] = 2; echo json_encode($return_arr); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings