query("SELECT COUNT(*) as c FROM bookings WHERE DATE(event_date) = CURDATE() AND status NOT IN ('cancelled')")->fetch_assoc()['c']; $pending_count = $conn->query("SELECT COUNT(*) as c FROM bookings WHERE status = 'pending'")->fetch_assoc()['c']; ?>