File manager - Edit - /home/autoph/public_html/voc/home/update_inventory_information.php
Back
<?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')); //error_reporting(0); $code = 0; if(isset($_POST['done'])){ $selectedVIN = mysql_real_escape_string($_POST['selectedVIN']); $brandCSNumber = mysql_real_escape_string($_POST['brandCSNumber']); $EditRecordID = mysql_real_escape_string($_POST['EditRecordID']); $BrandSellingDealer = mysql_real_escape_string($_POST['BrandSellingDealer']); $BrandLocation = mysql_real_escape_string($_POST['BrandLocation']); $brandDesc = mysql_real_escape_string($_POST['brandDesc']); $brandYear = mysql_real_escape_string($_POST['brandYear']); if($BrandSellingDealer!=''){ $code = 1; } if($BrandLocation!=''){ $code = 2; } if ($BrandSellingDealer!='' && $BrandLocation!=''){ $code = 8; } switch($code){ case '1': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear',`cs_number`='$brandCSNumber', `description`='$brandDesc', `selling_dealer`='$BrandSellingDealer' WHERE `id` = '$EditRecordID'"); break; case '2': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc', `unit_location`='$BrandLocation' WHERE `id` = '$EditRecordID'"); break; case '8': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc', `selling_dealer`='$BrandSellingDealer',`unit_location`='$BrandLocation' WHERE `id` = '$EditRecordID'"); break; case '0': mysql_query("UPDATE `db_vehicle_inventory` SET `year_model`='$brandYear', `cs_number`='$brandCSNumber', `description`='$brandDesc' WHERE `id` = '$EditRecordID'"); break; } echo "<p style='font-family:Arial;font-size:16px;padding:5px;'>UNIT INFORMATION HAS BEEN UPDATED</p>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings