prepare($query);
$stmt->bind_param('i', $post_id);
$stmt->execute();
$post = $stmt->get_result()->fetch_assoc();
$stmt->close();
if (!$post) {
header('Location: index.php');
exit;
}
// Handle comment submission
$errors = [];
$success = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$commenter_name = trim($_POST['commenter_name'] ?? '');
$comment_text = trim($_POST['comment_text'] ?? '');
if (empty($commenter_name) || empty($comment_text)) {
$errors[] = 'Name and comment are required.';
} else {
$query = "INSERT INTO blog_comments (post_id, commenter_name, comment_text) VALUES (?, ?, ?)";
$stmt = $conn->prepare($query);
$stmt->bind_param('iss', $post_id, $commenter_name, $comment_text);
if ($stmt->execute()) {
$success = 'Comment posted successfully.';
} else {
$errors[] = 'Failed to post comment: ' . $stmt->error;
}
$stmt->close();
}
}
// Fetch comments
$query = "SELECT commenter_name, comment_text, created_at FROM blog_comments WHERE post_id = ? ORDER BY created_at DESC";
$stmt = $conn->prepare($query);
$stmt->bind_param('i', $post_id);
$stmt->execute();
$comments = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();
?>
<?php echo htmlspecialchars($post['title']); ?> - WebsiteUnder999
Posted on
Tags:
Comments
No comments yet.
Leave a Comment
Back to Blog
close();
?>