query("SHOW COLUMNS FROM contact_messages LIKE 'updated_at'"); if ($checkColumn->rowCount() > 0) { // Column exists, use it $stmt = $pdo->prepare("UPDATE contact_messages SET status = ?, updated_at = NOW() WHERE id = ?"); } else { // Column doesn't exist, skip it $stmt = $pdo->prepare("UPDATE contact_messages SET status = ? WHERE id = ?"); } $stmt->execute([$status, $id]); $success = 'Message status successfully updated.'; header("Location: contact-messages.php?success=" . urlencode($success)); exit; } } elseif ($_POST['action'] === 'delete') { $id = (int)$_POST['id']; $stmt = $pdo->prepare("DELETE FROM contact_messages WHERE id = ?"); $stmt->execute([$id]); $success = 'Message successfully deleted.'; header("Location: contact-messages.php?success=" . urlencode($success)); exit; } } catch (PDOException $e) { $error = 'Database error: ' . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); logError($error); } } } // Get all contact messages try { $stmt = $pdo->query("SELECT * FROM contact_messages ORDER BY created_at DESC"); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { $error = 'Database error: ' . htmlspecialchars($e->getMessage(), ENT_QUOTES, 'UTF-8'); logError($error); $messages = []; } // $pageTitle = 'Contact Message Management'; include 'includes/header.php'; ?>

Contact Messages

Total: Pending: Resolved:

ID	Name	Contact	Topic	Message	Date	Status	Actions
No messages found
				50 ? substr($description, 0, 50) . '...' : $description; ?> 50): ?>	Updated:

Found messages. Pending: , Resolved: