prepare("INSERT INTO canned_replies (message) VALUES (?)"); $stmt->execute([$_POST['message']]); $_SESSION['feedback'] = ['type' => 'success', 'text' => 'Response added successfully!']; } elseif ($action === 'delete' && !empty($_POST['id'])) { $stmt = $pdo->prepare("DELETE FROM canned_replies WHERE id = ?"); $stmt->execute([$_POST['id']]); $_SESSION['feedback'] = ['type' => 'success', 'text' => 'Response deleted successfully!']; } elseif ($action === 'update' && !empty($_POST['id']) && !empty($_POST['message'])) { $stmt = $pdo->prepare("UPDATE canned_replies SET message = ? WHERE id = ?"); $stmt->execute([$_POST['message'], $_POST['id']]); $_SESSION['feedback'] = ['type' => 'success', 'text' => 'Response updated successfully!']; } elseif ($action === 'edit' && !empty($_POST['id'])) { // This is a GET-like action, but we use POST for simplicity $stmt = $pdo->prepare("SELECT * FROM canned_replies WHERE id = ?"); $stmt->execute([$_POST['id']]); $message_to_edit = $stmt->fetch(); $edit_mode = true; } } catch (PDOException $e) { $_SESSION['feedback'] = ['type' => 'danger', 'text' => 'Database error: ' . $e->getMessage()]; } if (!$edit_mode) { header("Location: admin.php"); exit(); } } // Fetch all canned replies to display $replies = $pdo->query("SELECT * FROM canned_replies ORDER BY id DESC")->fetchAll(); // Get feedback message from session $feedback = $_SESSION['feedback'] ?? null; unset($_SESSION['feedback']); ?> Admin - Manage Canned Responses

Manage Canned Responses

Existing Responses

No canned responses found. Add one above!