getConnection();
// Get all messages
$query = "SELECT * FROM contact_messages ORDER BY created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$messages = $stmt->fetchAll(PDO::FETCH_ASSOC);
$message = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['mark_read'])) {
$msg_id = $_POST['message_id'];
$query = "UPDATE contact_messages SET is_read = 1 WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$msg_id]);
$message = 'تم تحديث حالة الرسالة!';
header("Location: messages.php");
exit;
} elseif (isset($_POST['delete_message'])) {
$msg_id = $_POST['message_id'];
$query = "DELETE FROM contact_messages WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$msg_id]);
$message = 'تم حذف الرسالة بنجاح!';
header("Location: messages.php");
exit;
}
}
?>
الرسائل - Roz Skin