getConnection();
$slug = $_GET['slug'] ?? '';
if (!$slug) {
header('Location: blog.php');
exit;
}
// جلب المنشور
$stmt = $conn->prepare("SELECT * FROM posts WHERE slug = ? AND status = 'published'");
$stmt->execute([$slug]);
$post = $stmt->fetch(PDO::FETCH_ASSOC);
if (!$post) {
header('Location: blog.php');
exit;
}
// زيادة عدد المشاهدات
$conn->prepare("UPDATE posts SET views_count = views_count + 1 WHERE id = ?")->execute([$post['id']]);
// جلب منشورات ذات صلة
$related = $conn->prepare("SELECT * FROM posts WHERE category = ? AND id != ? AND status = 'published' ORDER BY published_at DESC LIMIT 3");
$related->execute([$post['category'], $post['id']]);
$related_posts = $related->fetchAll(PDO::FETCH_ASSOC);
$site_name = 'Roz Skin';
?>
<?php echo htmlspecialchars($post['title']); ?> - <?php echo $site_name; ?>
🏷️ الوسوم: