query("SELECT id, name FROM categories ORDER BY name ASC"); if ($cat_result) { $categories = $cat_result->fetch_all(MYSQLI_ASSOC); } // --- 3. BUILD THE DYNAMIC SQL QUERY --- // UPDATED: Added ap.shop_slug to the SELECT list $sql = "SELECT DISTINCT p.id, p.title, p.image_path, p.price, p.sale_price, p.artist_id, ap.shop_slug, CONCAT(ap.first_name, ' ', ap.last_name) as artist_name FROM paintings p LEFT JOIN artist_profiles ap ON p.artist_id = ap.user_id LEFT JOIN painting_categories pc ON p.id = pc.painting_id"; $where_clauses = []; $bind_params = []; $types = ''; // Add search query filter if (!empty($search_query)) { $where_clauses[] = "p.title LIKE ?"; $types .= 's'; $bind_params[] = '%' . $search_query . '%'; } // Add category filter if ($category_id > 0) { $where_clauses[] = "pc.category_id = ?"; $types .= 'i'; $bind_params[] = $category_id; } // Add price filter $where_clauses[] = "COALESCE(p.sale_price, p.price) <= ?"; $types .= 'i'; $bind_params[] = $max_price; if (!empty($where_clauses)) { $sql .= " WHERE " . implode(" AND ", $where_clauses); } $sql .= " ORDER BY p.uploaded_at DESC"; // --- 4. EXECUTE THE QUERY --- $paintings = []; $stmt = $conn->prepare($sql); if ($stmt) { if (!empty($bind_params)) { $stmt->bind_param($types, ...$bind_params); } $stmt->execute(); $result = $stmt->get_result(); if ($result) { $paintings = $result->fetch_all(MYSQLI_ASSOC); } $stmt->close(); } ?>

Browse Artwork

Discover unique paintings from talented artists.

<?php echo htmlspecialchars($painting['title']); ?>

by Unknown Artist

0): ?> ₹ ₹ ₹

No Paintings Found

No artwork matched your filter criteria. Please try again.