File manager - Edit - /home/autoph/public_html/pms_v1/mancom/saveSenergySales.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']); $sql = "UPDATE mancom_synergy_sales SET `actual_sales`='$rtActualJan',`target_sales`='$rtTargetJan',`target_vs_actual_rate`='$rtRateJan',`added_by`='$userID'='', `time_stamp`='$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