File manager - Edit - /home/autoph/public_html/data03252025consolidation/app/sales_consultant/update_sales_consultant.php
Back
<?php include_once("../../cfg/db.php"); $id = $db->escape(trim($_POST['sc_id'])); $employee_id = $db->escape(trim($_POST['employee_id'])); $first_name = $db->escape(trim(strtoupper($_POST['first_name']))); $last_name = $db->escape(trim(strtoupper($_POST['last_name']))); $position = $db->escape(trim($_POST['position'])); $mobile_1 = $db->escape(trim(strtoupper($_POST['mobile_1']))); $mobile_2 = $db->escape(trim(strtoupper($_POST['mobile_2']))); $email_1 = $db->escape(trim(strtoupper($_POST['email_1']))); $email_2 = $db->escape(trim(strtoupper($_POST['email_2']))); if(intval($db -> select("SELECT count(1) FROM sales_consultant WHERE `employee_id` != '' AND `employee_id` = '$employee_id' AND id != '$id'")) > 0){ $arr['status'] = 0; //duplicate employee id } else { $update_query = "UPDATE `sales_consultant` SET `employee_id`='$employee_id', `first_name`='$first_name', `last_name` = '$last_name', `type` = '$position', `mobile_1`='$mobile_1', `mobile_2`='$mobile_2', `email_1`='$email_1', `email_2`='$email_2' WHERE `id` = '$id'"; //echo $update_query; $db->sql_query($update_query); $arr['status'] = 1; //success update } echo json_encode($arr); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings