File manager - Edit - /home/autoph/public_html/pms_v1/mancom/saveJan.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['saveTheMan'])){ $selectedRecord = sanitize($_POST['selectedRecord']); $dealerID = sanitize($_POST['dealerID']); $companyID = sanitize($_POST['companyID']); $manHeadercomID = sanitize($_POST['manHeadercomID']); $rtTargetJan = sanitize($_POST['rtTargetJan']); $rtActualJan = sanitize($_POST['rtActualJan']); $rtRateJan = sanitize($_POST['rtRateJan']); $flTargetJan = sanitize($_POST['flTargetJan']); $flActualJan =sanitize($_POST['flActualJan']); $flRateJan = sanitize($_POST['flRateJan']); $opsTargetJan = sanitize($_POST['opsTargetJan']); $opsActualJan = sanitize($_POST['opsActualJan']); $opsRateJan = sanitize($_POST['opsRateJan']); $manTargetJan = sanitize($_POST['manTargetJan']); $manActualJan = sanitize($_POST['manActualJan']); $manRateJan = sanitize($_POST['manRateJan']); $sql = "UPDATE mancom_data SET `retail_actual_sales`='$rtActualJan',`retail_target_sales`='$rtTargetJan',`retail_target_vs_actual_rate`='$rtRateJan', `fleet_actual_sales`='$flActualJan',`fleet_target_sales`='$flTargetJan',`fleet_target_vs_actual`='$flRateJan', `ops_total_sales`='$opsActualJan',`ops_total_target`='$opsTargetJan',`ops_target_vs_actual`='$opsRateJan', `plant_target_sales`='$manTargetJan',`plant_actual_sales`='$manActualJan',`plant_target_vs_actual`='$manRateJan', `updated_by`='$userID'='', `date_updated`='$myTimeStamp' WHERE `mancom_hdr_id`='$manHeadercomID' AND `month_id`='$selectedRecord'"; // AND `comp_id`='$companyID' AND `deal_id`='$dealerID' if($conn->query($sql) === TRUE) { } else { } echo "Record updated."; $conn->close(); } //1 jan 1 1 //3 jan 1 3 ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings