prepare("UPDATE complaints SET status = ? WHERE id = ?"); $stmt->execute([$status, $complaint_id]); $message = 'Complaint status updated successfully.'; } catch (Exception $e) { $error = 'Error: ' . $e->getMessage(); } } // Handle delete if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['action']) && $_POST['action'] == 'delete_complaint') { try { $complaint_id = (int)$_POST['complaint_id']; $stmt = $pdo->prepare("DELETE FROM complaints WHERE id = ?"); $stmt->execute([$complaint_id]); $message = 'Complaint deleted successfully.'; } catch (Exception $e) { $error = 'Error: ' . $e->getMessage(); } } // Fetch all complaints $stmt = $pdo->query("SELECT * FROM complaints ORDER BY created_at DESC"); $complaints = $stmt->fetchAll(PDO::FETCH_ASSOC); $pageTitle = 'Manage Complaints'; include 'includes/header.php'; ?>

Complaints List

ID	Name	Mobile	Email	Subject	Status	Created At	Actions
No complaints found.