query($sql); // Get statistics $stats = [ 'new' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'new'")->fetch_assoc()['count'], 'in_progress' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'in_progress'")->fetch_assoc()['count'], 'resolved' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'resolved'")->fetch_assoc()['count'], 'closed' => $conn->query("SELECT COUNT(*) as count FROM contact_messages WHERE ticket_status = 'closed'")->fetch_assoc()['count'], ]; $page_title = 'Manage Tickets'; include '../includes/header.php'; ?>
← Back to Dashboard

Ticket Management

New
In Progress
Resolved
Closed
Reset
num_rows > 0): ?>
fetch_assoc()): ?>
ID Type Name Email Message Status Date Actions
# Member Visitor
() 		100 ? substr($msg, 0, 100) . '...' : $msg; ?> 'background: #ffc107; color: #000;', 'in_progress' => 'background: #17a2b8; color: #fff;', 'resolved' => 'background: #28a745; color: #fff;', 'closed' => 'background: #6c757d; color: #fff;' ]; $status_text = ucfirst(str_replace('_', ' ', $ticket['ticket_status'])); ?> View/Reply

Total: num_rows; ?> ticket(s)

No tickets found matching your criteria.