File manager - Edit - /home/autoph/public_html/connect/home/sub_transfer_request_save.php
Back
<?php $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); error_reporting(1); //echo "Connected"; //$apptDate = mysql_escape_string($_POST['apptDate']); //$newApptDate = date_format(date_create_from_format('Y-m-d', $apptDate), 'Y/m/d'); //transDate if(isset($_POST['done'])){ $fPlate = mysql_escape_string($_POST['fPlate']); $vRONumber = mysql_escape_string($_POST['vRONumber']); $transDate = mysql_escape_string($_POST['transDate']); $NewTransDate = date_format(date_create_from_format('Y-m-d', $transDate), 'Y/m/d'); $serviceRequestInfo= mysql_escape_string($_POST['serviceRequestInfo']); $Destination = mysql_escape_string($_POST['Destination']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); $dealerID = mysql_escape_string($_POST['dealerID']); $companyCode = mysql_escape_string($_POST['companyCode']); $addTime = mysql_escape_string($_POST['addTime']); $outStat =mysql_escape_string($_POST['trans']); mysql_query("INSERT INTO vts_vehicle_transfer_for_service (ro_number,t_plate, t_comp_id, t_deal_id, t_trans_by,t_trans_date,t_trans_time, t_trans_to_dealer_id, t_notes, transfer_delivery_date) VALUES('{$vRONumber}','{$fPlate}','{$companyCode}','{$dealerID}','{$addBy}','{$addDate}','{$addTime}','{$Destination}','{$serviceRequestInfo}','{$NewTransDate}')"); mysql_query("UPDATE `vts_service_transaction` SET `transferred_to` ='$Destination', `transfer_date`='$NewTransDate',`s_arrived_date`='',`s_arrived_time`='' WHERE `s_ro_no`='$vRONumber'"); exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings