File manager - Edit - /home/autoph/public_html/connect/home/save_new_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'])){ $unitDiscount = mysql_escape_string($_POST['unitDiscount']); $unitComm = mysql_escape_string($_POST['unitComm']); $unitDesc = mysql_escape_string($_POST['unitDesc']); $activeCompany = mysql_escape_string($_POST['activeCompany']); $model = mysql_escape_string($_POST['model']); $unitPrice = mysql_escape_string($_POST['unitPrice']); //$empIDNO = mysql_escape_string($_POST['empIDNO']); $unitCommA = str_replace(',', '', $unitComm); $unitDiscountA = str_replace(',', '', $unitDiscount); $unitPriceA = str_replace(',', '', $unitPrice); //===================================================================================================================================================== //===================================================================================================================================================== mysql_query("INSERT INTO unit_price_history (unit_description, date_encoded, unit_price, discount_price, unit_comm, effectivity_date,encoded_by, comp_id) VALUES('{$unitDesc}','{$toDate}','{$unitPriceA}','{$unitDiscountA}','{$unitCommA}','','{$userID}','{$activeCompany}')"); echo "Price for unit. ".$unitDesc." has been saved"; mysql_query("UPDATE db_vehicle_inventory SET `price`='$unitPriceA',`discount`='$unitDiscountA',`commission`='$unitCommA' WHERE description ='$unitDesc' AND `company`='$activeCompany' AND `status`!='Demo'"); exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings