File manager - Edit - /home/autoph/public_html/connectv1/app/sales_consultant/add_sales_consultant.php
Back
<?php include_once("../../cfg/db.php"); $new_employee_id = $db->escape(trim(strtoupper($_POST['new_employee_id']))); $new_firstname = $db->escape(trim(strtoupper($_POST['new_first_name']))); $new_lastname = $db->escape(trim(strtoupper($_POST['new_last_name']))); //$current_user = $_SESSION['user']['id']; if($new_employee_id <> ''){ if(intval($db -> select("SELECT count(1) FROM sales_consultant WHERE status = 1 AND employee_id = '$new_employee_id'")) > 0){ $return_arr['status'] = 0; //duplicate employee id $return_arr['message'] = "Employee ID already existing"; echo json_encode($return_arr); }else{ insertSC($new_employee_id,$new_firstname,$new_lastname,$db); } } else { insertSC($new_employee_id,$new_firstname,$new_lastname,$db); } function insertSC($new_employee_id,$new_firstname,$new_lastname,$db){ $db->sql_query("INSERT INTO `sales_consultant` (`employee_id`, `first_name`, `last_name`,`status`) VALUES (NULLIF('$new_employee_id',''), '$new_firstname', '$new_lastname',1)"); $return_arr['status'] = 1; echo json_encode($return_arr); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings