File manager - Edit - /home/autoph/public_html/connect/home/update_unit_price.php
Back
<?php include 'core/init.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); $userID=$user_data['u_id']; $toDate = date_create() ->format("Y/m/d"); ?> <?php //if submit/ save to databasevar " if(isset($_POST['done'])){ $selectedVIN = mysql_escape_string($_POST['selectedVIN']); $sDiscount = mysql_escape_string($_POST['sDiscount']); $sComm = mysql_escape_string($_POST['sComm']); $sPrice = mysql_escape_string($_POST['sPrice']); $EditRecordID = $_POST['EditRecordID']; $sDiscount = str_replace(',', '', $sDiscount); $sComm = str_replace(',', '', $sComm); $sPrice = str_replace(',', '', $sPrice); //===================================================================================================================================================== //===================================================================================================================================================== //mysql_query("INSERT INTO unit_price_history (unit_description, date_encoded, unit_price,discount_price,unit_comm,effectivity_date,encoded_by) //VALUES('{$unitDesc}','{$toDate}','{$unitPriceA}','{$unitDiscountA}','{$unitCommA}','','{$userID}')"); //echo "Price for unit. ".$unitDesc." has been changed"; echo "<b style='display:block;background:yellow;width:100%;padding:10px;font-family:Arial;font-size:18px;'> Price for unit. ".$unitDesc." has been changed </p>"; mysql_query("UPDATE db_vehicle_inventory SET `price`='$sPrice',`discount`='$sDiscount',`commission`='$sComm' WHERE id ='$EditRecordID'"); exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings