prepare("INSERT INTO tickets (user_id, order_id, subject, status) VALUES (?, ?, ?, 'open')"); $stmt->execute([$user_id, $order_id, $subject]); $ticket_id = $pdo->lastInsertId(); // Add First Message $stmtMsg = $pdo->prepare("INSERT INTO ticket_messages (ticket_id, sender, message) VALUES (?, 'user', ?)"); $stmtMsg->execute([$ticket_id, $message]); $msg = "Ticket #$ticket_id Created Successfully!"; } } // 2. FETCH USER TICKETS $tickets = $pdo->prepare("SELECT * FROM tickets WHERE user_id = ? ORDER BY created_at DESC"); $tickets->execute([$user_id]); $my_tickets = $tickets->fetchAll(); // 3. FETCH USER ORDERS (For Dropdown) $orders = $pdo->prepare("SELECT id FROM orders WHERE user_id = ? ORDER BY id DESC"); $orders->execute([$user_id]); $my_orders = $orders->fetchAll(); ?>

My Support Tickets

0): ?>
ID Subject Status Date Action
# 0): ?> Order #
 Pending Answered Closed View

You have no support tickets.

Open New Ticket