query("SELECT COUNT(*) AS count FROM users")->fetch_assoc()['count'];
$total_donations = $conn->query("SELECT COUNT(*) AS count FROM material_donations")->fetch_assoc()['count'];
$pending_donations = $conn->query("SELECT COUNT(*) AS count FROM material_donations WHERE status = 'pending'")->fetch_assoc()['count'];
// Fetch users and donations
$users = $conn->query("SELECT * FROM users ORDER BY created_at DESC");
$donations = $conn->query("SELECT * FROM material_donations ORDER BY created_at DESC");
?>
Admin Dashboard