File manager - Edit - /home/autoph/public_html/tasks/save_reservation_comments.php.tar
Back
home/autoph/public_html/voc/home/save_reservation_comments.php 0000644 00000002047 15025114037 0021013 0 ustar 00 <?php include 'core/database/connect.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); //$toDate = date_create() ->format("Y/m/d"); //$toTime =Explode(":", date('H:i:s')); //$expirationDate = date('Y/m/d', strtotime($toDate. ' + 3 days')); //if submit/ save to database if(isset($_POST['done'])){ $selectedVIN = mysql_escape_string($_POST['selectedVIN']); $salesAgent = mysql_escape_string($_POST['salesAgent']); $reservationComment = mysql_escape_string($_POST['reservationComment']); $EditRecordID = mysql_escape_string($_POST['EditRecordID']); mysql_query("UPDATE `db_vehicle_inventory` SET `reserved`='1', `status`='Reserved', `tagged`='$salesAgent', `remarks`='$reservationComment' WHERE `id`='$EditRecordID'"); echo "<p style='font-family:Arial;font-size:16px;padding:5px;'>UNIT RESERVATION COMPLETE</p>"; exit(); } ?>