getConnection(); // Check admin permission $usr = new user($db); $adminpermission = $usr->check_admin_permission($_SESSION["user"]); // initialize object $off = new office($db); // read office will be here // query office $stmtoff = $off->off_read(); $numoff = $stmtoff->rowCount(); $num = 0; if(isset($_POST['submit'])){ // initialize object $emp = new employee($db); // read employee attendance will be here // query employee attendance $emp->ts_brid = $_POST['offbranch']; $stmt = $emp->emp_read(); $num = $stmt->rowCount(); } if (isset($_GET['status']) && $_GET['status'] === 'success' && isset($_GET['successCount'])) { $successCount = intval($_GET['successCount']); echo ""; } // Check if there's an error message if (isset($_GET['status']) && $_GET['status'] === 'error' && isset($_GET['file'])) { $fileName = $_GET['file']; // Get the error file name from the URL echo ""; } ?> STATS 0){ $expostatus = ""; } ?>
Employee View
Selected Branch
prepare("SELECT brch_name FROM acts_branch WHERE brch_id = ?"); $stmtBranch->execute([$selectedBranchId]); $branch = $stmtBranch->fetch(PDO::FETCH_ASSOC); echo $branch ? $branch['brch_name'] : 'Branch not found'; } else { echo 'Not Selected'; } ?>
Total Employees:
Add New Employee
Sign Out
0) { ?>
fetch(PDO::FETCH_ASSOC)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
ID Name Location Edit Delete
" . $row["empid"] . "" . $row["empname"] . "" . $row["loname"] . "

No results to display!

"; } ?>

Select branch to view employee details

Select office name above and click search before export to XLS file.