real_escape_string($_GET['search']) : ''; $category_filters = isset($_GET['category']) && is_array($_GET['category']) ? array_map('intval', $_GET['category']) : []; $tag_filter = isset($_GET['tag']) ? $conn->real_escape_string($_GET['tag']) : ''; // Build Where Clause for Active Blogs $whereClauses = ["is_active = 1"]; if ($search) { $whereClauses[] = "(title LIKE '%$search%' OR content LIKE '%$search%')"; } if ($tag_filter) { // tags are JSON array $whereClauses[] = "JSON_CONTAINS(tags, '\"$tag_filter\"')"; } if (!empty($category_filters)) { $cat_clauses = []; foreach($category_filters as $cf) { $cat_clauses[] = "JSON_CONTAINS(categories, '\"$cf\"')"; } // Match ANY of the checked categories (OR) $whereClauses[] = "(" . implode(" OR ", $cat_clauses) . ")"; } $whereSQL = "WHERE " . implode(" AND ", $whereClauses); // Fetch Total For Pagination $total_query = $conn->query("SELECT COUNT(id) as total FROM blogs $whereSQL"); $total_blogs = $total_query->fetch_assoc()['total']; $total_pages = ceil($total_blogs / $limit); // Fetch Blogs $blogs_sql = "SELECT id, title, slug, image, short_desc, categories, published_at FROM blogs $whereSQL ORDER BY published_at DESC LIMIT $offset, $limit"; $blogs_result = $conn->query($blogs_sql); // Fetch All Categories for Sidebar (flat list) $cats_q = $conn->query("SELECT id, name FROM blog_categories WHERE is_active = 1 ORDER BY name ASC"); $categories = []; if ($cats_q && $cats_q->num_rows > 0) { while($cat = $cats_q->fetch_assoc()) { $categories[] = $cat; } } // Fetch Recent Posts for Sidebar $recent_sql = "SELECT title, slug, image, categories FROM blogs WHERE is_active = 1 ORDER BY published_at DESC LIMIT 4"; $recent_result = $conn->query($recent_sql); // Fetch All Unique Tags for Sidebar (parsing JSON tags column) $tags_q = $conn->query("SELECT tags FROM blogs WHERE is_active = 1 AND tags != '[]' AND tags IS NOT NULL"); $all_tags_list = []; while($t = $tags_q->fetch_assoc()) { $decoded = json_decode($t['tags'], true); if(is_array($decoded)){ foreach($decoded as $tag){ $tag = trim($tag); if(!empty($tag) && !in_array($tag, $all_tags_list)){ $all_tags_list[] = $tag; } } } } // Helper block to fetch main category name for blog cards function getCatName($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'; } // Generate base query string for pagination $pagination_qs = []; if($search) $pagination_qs[] = "search=".urlencode($search); if($tag_filter) $pagination_qs[] = "tag=".urlencode($tag_filter); if(!empty($category_filters)) { foreach($category_filters as $cf) { $pagination_qs[] = "category[]=".intval($cf); } } $base_qs = empty($pagination_qs) ? "all-blogs?" : "all-blogs?" . implode("&", $pagination_qs) . "&"; ?>

Blogs

Search Results for: ""

Filtering by Tag: ""

num_rows > 0): ?> fetch_assoc()): $image_path = "uploads/blogs/" . $blog['image']; if(!file_exists($image_path) || empty($blog['image'])) $image_path = "assets/images/placeholder.jpg"; // Get first Category Name $b_cats = json_decode($blog['categories'], true); $first_cat = 'Blog'; $first_cat_id = 0; if(is_array($b_cats) && count($b_cats) > 0){ $first_cat_id = $b_cats[0]; $first_cat = getCatName($first_cat_id, $conn); } ?>

No blogs found.

Clear Filters
1): ?>