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'])){ $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(); $brcname = trim($_POST['brchname_text']); //$folder_brname = preg_replace("/\s+/", "", $brcname); // initialize object $stmt = $emp->qr_read(); $num = $stmt->rowCount(); } //$total_pages = ceil($num / $no_of_records_per_page); ?> STATS
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
0) { ?>
fetch(PDO::FETCH_ASSOC)) { $empid = $row['empid']; $brch_name = urlencode($row['brch_name']); $url = "dashboard.employee.qr.php?empid=$empid&foldername=$brch_name"; ?>
ID Name Branch Name Action

No results to display!

Select branch and print the employee list with QR Code