File manager

File manager - Edit - /home/autoph/public_html/connect/home/sub_close_ro_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); //if submit/ save to databasevar if(isset($_POST['done'])){ $closeThisRO = mysql_escape_string($_POST['closeThisRO']); $CLaddBy = mysql_escape_string($_POST['CLaddBy']); $CLaddDate = mysql_escape_string($_POST['CLaddDate']); $CLaddTime = mysql_escape_string($_POST['CLaddTime']); $serviceNotes = mysql_escape_string($_POST['reasonForClosing']); mysql_query("UPDATE `vts_service_transaction` SET `service_status`='1', `date_closed`='$CLaddDate', `time_closed`='$CLaddTime', `closed_by`='$CLaddBy',`closed_reason`='$serviceNotes' WHERE `s_ro_no`='$closeThisRO'"); $dealID = mysql_result(mysql_query("SELECT `s_deal_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); $uVPlate = mysql_result(mysql_query("SELECT `s_v_plate` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); $dealID = mysql_result(mysql_query("SELECT `s_deal_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); $dealID = mysql_result(mysql_query("SELECT `s_deal_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); $dealID = mysql_result(mysql_query("SELECT `s_deal_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); $dealID = mysql_result(mysql_query("SELECT `s_deal_code` FROM `vts_service_transaction` WHERE `s_ro_no`='$closeThisRO'"),0); mysql_query("INSERT INTO vts_service_status_logs (ro_number, paint_stage, deal_id, v_plate, date, time, status, notes, add_by, update_sms, update_email) VALUES('{$closeThisRO}','na','{$dealID}','{$uVPlate}','{$CLaddDate}','{$CLaddTime}','Closed','{$serviceNotes}','{$CLaddBy}','NA','NA')"); //mysql_query("INSERT INTO vts_closed_ro (ro_number, closed_date, close_by, reasons) //VALUES('{$SelRONumber}','{$addDate}','{$addBy}','{$serviceNotes}')"); //mysql_query("UPDATE `vts_service_transaction` SET `transfer_return_date`='$addDate' WHERE `s_ro_no`='$UpdateMyRO'"); exit(); } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0.01 | proxy | phpinfo | Settings