File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/admin/API/AddNewRequest.php
Back
<?php if(isset($_GET['c_id'])) { require_once("Connection.php"); $cid = $_GET['c_id']; $vid = $_GET['v_id']; $padd = $_GET['p_add']; $status = $_GET['status']; $sid = $_GET['s_id']; $p_date = $_GET['p_date']; $p_time = $_GET['p_time']; $d_date = $_GET['d_date']; $d_time = $_GET['d_time']; $sql = "INSERT INTO `solu_request_table` (`sr_id`, `client_id`, `vehicle_id`, `pickup_address`, `additional_amount`, `status`, `offer_id`, `GGST`, `SGST`, `IGST`, `service_charge`, `labor_charge`, `delivery_address`) VALUES (NULL, '$cid', '$vid', '$padd', 0, '$status', 1, NULL, NULL, NULL, NULL, NULL, NULL)"; if($con->query($sql)) { $sql = "SELECT MAX(`solu_request_table`.`sr_id`) AS 'MAX' FROM `solu_request_table`,`vehicle_table`,`client_table` WHERE `solu_request_table`.`client_id` = `client_table`.`client_id` AND `client_table`.`client_id` = $cid"; if($rows = $con->query($sql)) { $row = $rows->fetch_assoc(); $srid = $row['MAX']; $sql = "INSERT INTO `solu_details` (`sd_id`, `sr_id`, `solution_id`) VALUES (NULL, '$srid', '$sid')"; if($con->query($sql)) { $sql = "INSERT INTO `req_schedule_table` (`sr_id`, `pick_datetime`, `pic_pref_time`, `del_datetime`, `del_pref_time`) VALUES ('$srid', '$p_date', '$p_time', '$d_date', '$d_time');"; if($con->query($sql)) { echo "SUCCESS"; exit; } } } } echo "ERROR"; } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings