File manager - Edit - /home/autoph/public_html/connectv1/app/company_dealer/update_company.php
Back
<?php include_once("../../cfg/db.php"); // $get_id = $_POST['id']; // $company_id_conv = implode("", $get_id); $id = $db->escape(trim($_POST['id'])); $code = $db->escape(trim(strtoupper($_POST['code']))); $name = $db->escape(trim(strtoupper($_POST['name']))); $address = $db->escape(trim(strtoupper($_POST['address']))); $state = $db->escape(trim(strtoupper($_POST['state']))); $city = $db->escape(trim(strtoupper($_POST['city']))); $postal = $db->escape(trim(strtoupper($_POST['postal']))); $dms = $db->escape(trim(strtoupper($_POST['dms']))); if(intval($db -> select("SELECT count(1) FROM source_company WHERE code = '$code' AND id != '$id'")) > 0){ $arr['status'] = 0; //duplicate code } else if(intval($db -> select("SELECT count(1) FROM source_company WHERE name = '$name' AND id != '$id'")) > 0){ $arr['status'] = 1; //duplicate name } else { $update_query = "UPDATE `source_company` SET `code`='$code', `name`='$name', `address`='$address', `state_id`='$state', `city_id`='$city', `postal`='$postal', `dms_id`='$dms' WHERE id = '$id'"; $db->sql_query($update_query); $arr['status'] = 2; //success update } echo json_encode($arr); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings