File manager - Edit - /home/autoph/public_html/voc/home/sub_check_in_vehicle.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"; //if submit/ save to databasevar if(isset($_POST['done'])){ $plate = mysql_escape_string($_POST['plate']); $kmReading = mysql_escape_string($_POST['kmReading']); $location = mysql_escape_string($_POST['location']); $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_in_out_history (chk_plate, chk_km, chk_transaction, comp_code,dealer_code,location_code, time, date, user_id) VALUES('{$plate}','{$kmReading}','{$outStat}','{$companyCode}','{$dealerID}','{$location}','{$addTime}','{$addDate}','{$addBy}')"); mysql_query("UPDATE `vts_service_transaction` SET `s_arrived_date`='$addDate',`s_arrived_time`='$addTime' WHERE `s_arrived_time`='' AND `s_v_plate`='$plate' AND `s_comp_code`='$companyCode' AND `s_deal_code`='$dealerID' AND `service_status`='0'"); if($outStat==='IN'){ mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='1',`v_location_id`='$dealerID',`action_id`='$location' WHERE `v_plate`='$plate'"); }else{ mysql_query("UPDATE `vts_vehicle_lists` SET `v_in_out`='0',`v_location_id`='0',`action_id`='$location' WHERE `v_plate`='$plate'"); } exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings