query($sql) === TRUE) {
//echo "New record created successfully";
} else {
//echo "Error: " . $sql . "
" . $conn->error;
}
?>
ID | EMP. ID | EMPLOYEE NAME | COMPANY | POSITION | CURRENT ACCESS | 0){ while($row = mysqli_fetch_array($qEmp)){ $myCompID = $row['comp_id']; $myDealID = $row['branch_id']; $myPosID = $row['position']; $role = $row['access_role']; $accSta = $row['account_status']; if($accSta==0){ $textColor = '#A09E9E'; }else{ $textColor = '#494A4B'; } ?> |
---|---|---|---|---|---|
".$row['emp_id']." | "; echo "".$row['last_name'].", ".$row['first_name']." | "; echo ""; $getCompany = "SELECT `comp_code` FROM `vts_company` WHERE `comp_id`='$myCompID'"; $getC = mysqli_query($conn,$getCompany); while($rowX = mysqli_fetch_array($getC)){ echo $rowX['comp_code']; } echo " | "; echo ""; $getPos = "SELECT `position_name` FROM `pms_positions_tbl` WHERE `id`='$myPosID'"; $getP = mysqli_query($conn,$getPos); while($rowP = mysqli_fetch_array($getP)){ echo $rowP['position_name']; } echo " | "; echo ""; $getFile = "SELECT `profile_name` FROM `user_profile` WHERE `id`='$role' LIMIT 1"; $qFile = mysqli_query($conn,$getFile); $pC = mysqli_num_rows($qFile); if($pC > 0){ while($pro = mysqli_fetch_array($qFile)){ echo $pro['profile_name']; } }else{ echo "Default"; } echo " | "; echo "";?> "; echo " |