File manager - Edit - /home/autoph/public_html/connectv1/app/company_dealer/add_dealer.php
Back
<?php include_once("../../cfg/db.php"); //echo $_POST['company_code']; return; $new_dealer_name = $db->escape(trim(strtoupper($_POST['dealer_name']))); $new_dealer_code = $db->escape(trim(strtoupper($_POST['dealer_code']))); $new_dealer_brand = $db->escape(trim(strtoupper($_POST['dealer_brand']))); //check duplicate //$duplicate_name_count = $db->sql_query("SELECT `name` FROM `source_dealer` WHERE `name`='$new_dealer_name'")->num_rows; //$duplicate_code_count = $db->sql_query("SELECT `code` FROM `source_dealer` WHERE `code`='$new_dealer_code'")->num_rows; $current_user = $_SESSION['user']['id']; if(intval($db -> select("SELECT count(1) FROM source_dealer WHERE name = '$new_dealer_name'")) > 0){ $return_arr['status'] = 0; //duplicate name echo json_encode($return_arr); } else if(intval($db -> select("SELECT count(1) FROM source_dealer WHERE code = '$new_dealer_code'")) > 0){ $return_arr['status'] = 1; //duplicate code echo json_encode($return_arr); } else { $insert = "INSERT INTO `source_dealer` (`name`, `code`, `brand_id`, `address`, `state_id`, `city_id`, `postal`, `add_by`) VALUES ('$new_dealer_name', '$new_dealer_code', '$new_dealer_brand', '', '0', '0', '0', '$current_user')"; //echo $insert; return; $insert_query = $db->sql_query($insert); $return_arr['status'] = 2; echo json_encode($return_arr); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings