File manager - Edit - /home/autoph/public_html/pms_v1/mar/saveActionData.php
Back
<?php include_once("../../../cfg/conn.php"); if(isset($_POST['saveAction'])){ $selActionID = $_POST['selActionID']; $userID = $_POST['userID']; $selActionDate = $_POST['selActionDate']; $selActionPerson = $_POST['selActionPerson']; $getMarHeader = $_POST['getMarHeader']; $getEmpRecordID = $_POST['getEmpRecordID']; if($selActionDate=="" && $selActionPerson==""){ $isDeleted="1"; }else{ $isDeleted="0"; } if($selActionDate !=""){ $isCheck ="checked"; }else{ $isCheck =""; } //Check if same KRA has been added $kraCode $chkAction = "SELECT * FROM `mar_actions_data` WHERE `deleted`='0' AND `emp_record_id`='$getEmpRecordID' AND `action_id`='$selActionID' AND `mar_header_id`='$getMarHeader'"; $getChkAction = mysqli_query($conn,$chkAction); $stRow = mysqli_num_rows($getChkAction); if($stRow > 0){ $updateKRA = "UPDATE `mar_actions_data` SET `action_date`='$selActionDate', `action_person`='$selActionPerson', `deleted`='$isDeleted' WHERE `emp_record_id` = '$getEmpRecordID' AND `action_id`='$selActionID' AND `mar_header_id`='$getMarHeader'"; if ($conn->query($updateKRA) === TRUE) { //echo "New record created successfully"; } else { //echo "Error: " . $sql . "<br>" . $conn->error; } }else{ $sql = "INSERT INTO mar_actions_data ( `id`, `emp_record_id`, `mar_header_id`, `action_id`, `action_value`, `action_date`, `action_person`, `date_added`, `added_by` ) VALUES ('', '$getEmpRecordID', '$getMarHeader', '$selActionID', $isCheck, '$selActionDate', '$selActionPerson', '$myTimeStamp', '$userID')"; if ($conn->query($sql) === TRUE) { } else { } } $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings