query("SELECT role FROM users WHERE id = '$user_id'")->fetch_assoc();
if (($check_admin['role'] ?? '') !== 'admin') {
die("ACCESS DENIED. You are not an administrator.");
}
// 2. Fetch System Stats
$total_users = $conn->query("SELECT COUNT(*) as c FROM users")->fetch_assoc()['c'];
$total_qrs = $conn->query("SELECT COUNT(*) as c FROM qrcodes")->fetch_assoc()['c'];
$total_scans = $conn->query("SELECT COUNT(*) as c FROM qr_scans")->fetch_assoc()['c'];
?>
Admin Panel - Master Control
System Overview
Total Users
Total QR Codes
Total Scans Processed
Online
System Status
Recent Signups
ID
Name
Email
Joined
query("SELECT * FROM users ORDER BY created_at DESC LIMIT 5");
while($u = $recent->fetch_assoc()):
?>