File manager - Edit - /home/autoph/public_html/connectv1/app/department_position/designate_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'])); //$query = "SELECT id FROM source_dealer WHERE code='$dealer_code'"; $check_query = "SELECT department_id FROM employee_position WHERE id='$position_id' AND department_id='$department_id'"; //echo $check_query; return; //$check_query = "SELECT status FROM source_company_dealer WHERE dealer_id='$dealer_id' AND company_id='$company_id'"; $check_record = $db->sql_query($check_query)->num_rows; if($check_record > 0){ $arr_status['status'] = 0; //already added } else { $insert_query = "UPDATE employee_position SET `department_id` = '$department_id' WHERE id='$position_id'"; //echo $insert_query; return; $position_info = $db->sql_query($insert_query); $arr_status['status'] = 1; //clear } echo json_encode($arr_status); // while($row = $company_info->fetch_assoc()) { // echo '<option value="'.$row['id'].'">'.$row["code"].' - '.$row["name"].'</option>'; // } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings