real_escape_string($_GET['slug']); // Fetch active blog by slug $sql = "SELECT * FROM blogs WHERE slug = '$slug' AND is_active = 1"; $result = $conn->query($sql); if ($result->num_rows == 0) { // Blog not found or inactive header("Location: all-blogs"); exit; } $blog = $result->fetch_assoc(); // Parse Image $main_image = "uploads/blogs/" . $blog['image']; if (!file_exists($main_image) || empty($blog['image'])) { $main_image = "assets/images/placeholder.jpg"; // fallback } // Parse Author $author = !empty($blog['published_by']) ? htmlspecialchars($blog['published_by']) : 'Admin'; // Parse Categories for primary label $b_cats = json_decode($blog['categories'], true); $primary_cat_name = 'Blog'; if (is_array($b_cats) && count($b_cats) > 0) { $cat_id = intval($b_cats[0]); $cat_q = $conn->query("SELECT name FROM blog_categories WHERE id = $cat_id"); if ($cat_q && $cat_q->num_rows > 0) { $primary_cat_name = $cat_q->fetch_assoc()['name']; } } // Parse Tags $tags = json_decode($blog['tags'], true); // Fetch Related Posts (3 active, preferring same categories, excluding current) $related_blogs = []; if (is_array($b_cats) && count($b_cats) > 0) { // First try to find blogs sharing the same categories $cat_clauses = []; foreach($b_cats as $rc) { $cat_clauses[] = "JSON_CONTAINS(categories, '\"" . intval($rc) . "\"')"; } $cat_where = "(" . implode(" OR ", $cat_clauses) . ")"; $related_sql = "SELECT id, title, slug, image, categories, published_at FROM blogs WHERE is_active = 1 AND id != {$blog['id']} AND $cat_where ORDER BY published_at DESC LIMIT 3"; $related_result = $conn->query($related_sql); if ($related_result && $related_result->num_rows > 0) { while($r = $related_result->fetch_assoc()) { $related_blogs[] = $r; } } } // If not enough related by category, fill with latest if (count($related_blogs) < 3) { $exclude_ids = [$blog['id']]; foreach($related_blogs as $rb) $exclude_ids[] = $rb['id']; $exclude_str = implode(',', $exclude_ids); $fill_sql = "SELECT id, title, slug, image, categories, published_at FROM blogs WHERE is_active = 1 AND id NOT IN ($exclude_str) ORDER BY published_at DESC LIMIT " . (3 - count($related_blogs)); $fill_result = $conn->query($fill_sql); if ($fill_result && $fill_result->num_rows > 0) { while($r = $fill_result->fetch_assoc()) { $related_blogs[] = $r; } } } // Helper to get category name function getRelatedCatName($cat_id, $conn) { $q = $conn->query("SELECT name FROM blog_categories WHERE id = ".intval($cat_id)); if($q && $q->num_rows > 0) return $q->fetch_assoc()['name']; return 'Blog'; } // Dynamic Page URL for Sharing $page_url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]"; $encoded_url = urlencode($page_url); $encoded_title = urlencode($blog['title']); $site_url = "https://www.jthompsontextiles.com"; $meta_title = !empty($blog['seo_title']) ? trim($blog['seo_title']) : trim($blog['title']) . " | James Thompson Textiles"; $meta_description = !empty($blog['seo_desc']) ? trim($blog['seo_desc']) : trim($blog['short_desc']); if ($meta_description === '') { $meta_description = "Read blog updates from James Thompson Textiles."; } $seo_keywords_arr = json_decode($blog['seo_keywords'], true); if (!is_array($seo_keywords_arr)) { $seo_keywords_arr = []; } $seo_keywords_arr = array_values(array_filter(array_map('trim', $seo_keywords_arr))); $tags_keywords_arr = json_decode($blog['tags'], true); if (!is_array($tags_keywords_arr)) { $tags_keywords_arr = []; } $tags_keywords_arr = array_values(array_filter(array_map('trim', $tags_keywords_arr))); $meta_keywords = !empty($seo_keywords_arr) ? implode(', ', $seo_keywords_arr) : (!empty($tags_keywords_arr) ? implode(', ', $tags_keywords_arr) : "blog, james thompson textiles"); // Blog image is always used as SEO image (seo_image = image set on upload) $meta_image_path = "assets/images/others/share-img.png"; if (!empty($blog['image']) && file_exists("uploads/blogs/" . $blog['image'])) { $meta_image_path = "uploads/blogs/" . $blog['image']; } elseif (!empty($blog['seo_image']) && file_exists("uploads/blogs/" . $blog['seo_image'])) { $meta_image_path = "uploads/blogs/" . $blog['seo_image']; } $title = $meta_title; $description = $meta_description; $keywords = $meta_keywords; $image = $site_url . "/" . ltrim($meta_image_path, '/'); $current_url = $site_url . "/blog-detail?slug=" . urlencode($blog['slug']); ?>

0): ?>

Related Blogs

0) { $rel_cat_id = $rel_cats[0]; $rel_cat_name = getRelatedCatName($rel_cat_id, $conn); } ?>