File manager - Edit - /home/autoph/public_html/pms_v1/apr/addPEFEvaluator.php
Back
<?php include_once("../../../cfg/conn.php"); include ("../functions/users.php"); //error_reporting(0); if(isset($_POST['pefe'])){ $errorMSG=""; $selUnitID = $_POST['selUnitID']; $userID = $_POST['userID']; $lcomp = $_POST['pefe']; switch ($lcomp){ case 1: //LOAD break; case 2: //ADD //check if exist $employeeSearchID = $_POST['employeeSearchID']; $chkIfExist = "SELECT * FROM `pef_parttwo_evaluator` WHERE `deleted`=0 AND `emp_id`='$selUnitID' AND `pef_evaluator_id`='$employeeSearchID'"; $valExist = mysqli_query($conn,$chkIfExist); $valRow = mysqli_num_rows($valExist); if($valRow > 0){ $errorMSG="Record already exist."; }else{ //store data $sql = "INSERT INTO pef_parttwo_evaluator ( `id`, `emp_id`, `pef_evaluator_id`, `type`, `added_by`) VALUES ( '', '$selUnitID', '$employeeSearchID', 'PEF', '$userID')"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been saved."; } else { $errorMSG="Error saving record"; } } break; case 3: //DELETE aprID $aprID = $_POST['aprID']; $sql = "UPDATE pef_parttwo_evaluator SET deleted = 1 WHERE `id`='$aprID'"; if ($conn->query($sql) === TRUE) { $errorMSG="Record has been deleted."; } else { $errorMSG="Error saving record."; } break; } $getCApprover = "SELECT * FROM `pef_parttwo_evaluator` WHERE `deleted`=0 AND `type` ='PEF' AND `emp_id`='$selUnitID' ORDER BY `id` ASC LIMIT 20"; $getApr = mysqli_query($conn,$getCApprover); $statRow = mysqli_num_rows($getApr); while($row = mysqli_fetch_array($getApr)){ $approverID = $row['pef_evaluator_id']; ?><tr onclick="javascript:aprDataDeal(this);" style="width:100%"><?php echo "<td style='width:10%;border:0px solid red'>".$row['id']."</td>"; echo "<td style='width:15%;border:0px solid red'>"; echo $row['emp_id']; echo "</td>"; echo "<td style='width:70%;border:0px solid red'>"; echo getEmployeeEmpInformationB($approverID)[2] . ", ". getEmployeeEmpInformationB($approverID)[3]; echo "</td>"; echo "<td style='width:5%'> <abbr title='Delete record'><i class='fa fa-trash ' aria-hidden='true' style='cursor:pointer;color:#FF0800;font-size:14px'></i></abbr> </td>"; echo "<tr>"; } echo "<tr><td colspan=4 style='padding:20px;color:red;font-size:14px;text-align:left;background:white;border:0px solid white'>".$errorMSG."</td></tr>"; $conn->close(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings