File manager - Edit - /home/autoph/public_html/connectv1/app/department_position/remove_position.php
Back
<?php include_once("../../cfg/db.php"); // $get_position_id = $_POST['position_id']; // $position_id_conv = implode("", $get_position_id); $position_id = $db->escape(trim($_POST['position_id'])); // $get_department_id = $_POST['department_id']; // $department_id_conv = implode("", $get_department_id); $department_id = $db->escape(trim($_POST['department_id'])); $check_query = "SELECT * FROM employee_position WHERE id='$position_id' AND department_id='$department_id'"; //echo $check_query; return; $check_if_okay = $db->sql_query($check_query)->num_rows; if($check_if_okay > 0){ $remove_query = "UPDATE employee_position SET `department_id` = 0 WHERE id='$position_id' AND department_id='$department_id'"; $db->sql_query($remove_query); $arr_status['status'] = 1; //done removing } else { $arr_status['status'] = 0; //record not found } echo json_encode($arr_status); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings