query("SELECT COUNT(*) as count FROM members"); $total_members = $total_members_result->fetch_assoc()['count']; $pending_approval_result = $conn->query("SELECT COUNT(*) as count FROM members WHERE is_verified = 1 AND is_approved = 0"); $pending_approval = $pending_approval_result->fetch_assoc()['count']; $active_members_result = $conn->query("SELECT COUNT(*) as count FROM members WHERE is_approved = 1 AND payment_status = 1"); $active_members = $active_members_result->fetch_assoc()['count']; $total_surveys_result = $conn->query("SELECT COUNT(*) as count FROM survey_sites"); $total_surveys = $total_surveys_result->fetch_assoc()['count']; $new_tickets_result = $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'new'"); $new_tickets = $new_tickets_result->fetch_assoc()['count']; $page_title = 'Admin Dashboard'; include '../includes/header.php'; ?>

Admin Dashboard

Total Members

Pending Approval

Active Members

Survey Sites

New Tickets

0): ?> !

Manage Tickets 0): ?> New Manage Members + Add Survey Site Manage Surveys Settings