prepare("DELETE FROM contact_messages WHERE id = :id");
$stmt->execute(['id' => $delete_id]);
header("Location: " . BASE_URL . "admin/messages.php?success=deleted");
exit();
} catch (PDOException $e) {
$error_msg = "Failed to delete message: " . $e->getMessage();
}
}
// Mark All as Read action
if (isset($_GET['action']) && $_GET['action'] === 'read_all') {
try {
$pdo->query("UPDATE contact_messages SET is_read = 1");
header("Location: " . BASE_URL . "admin/messages.php?success=read_all");
exit();
} catch (PDOException $e) {
$error_msg = "Failed to update messages: " . $e->getMessage();
}
}
// Load a specific message details and flag as read
$selected_msg = null;
if ($id > 0) {
try {
// Flag message as read
$stmt_read = $pdo->prepare("UPDATE contact_messages SET is_read = 1 WHERE id = :id");
$stmt_read->execute(['id' => $id]);
$stmt = $pdo->prepare("SELECT * FROM contact_messages WHERE id = :id");
$stmt->execute(['id' => $id]);
$selected_msg = $stmt->fetch();
} catch (PDOException $e) {
$error_msg = "Error reading message: " . $e->getMessage();
}
}
// Load all messages
$all_messages = [];
try {
$stmt = $pdo->query("SELECT * FROM contact_messages ORDER BY is_read ASC, id DESC");
$all_messages = $stmt->fetchAll();
} catch (PDOException $e) {
// offline
}
require_once __DIR__ . '/header.php';
require_once __DIR__ . '/navbar.php';
?>
| Client Name |
Subject |
Date Received |
Status |
Actions |
|
|
QUOTE
|
|
Read
Unread
|
|
| No message entries. Your customer contact logs are empty. |
Inquiry Details
Client Identity
Name:
Email:
Phone:
Message details not found.