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'];
?>".$row['id']."";
echo "| ";
echo $row['emp_id'];
echo " | ";
echo "";
echo getEmployeeEmpInformationB($approverID)[2] . ", ". getEmployeeEmpInformationB($approverID)[3];
echo " | ";
echo "
| ";
echo "
";
}
echo "
| ".$errorMSG." |
";
$conn->close();
}
?>