prepare("SELECT * FROM artist_profiles WHERE shop_slug = ? AND subscription_status = 'active'"); $stmt->bind_param("s", $slug); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) { $artist = $result->fetch_assoc(); } else { // Forgiving Search $slug_clean = str_replace([' ', '+', '%20'], '', $slug); $stmt = $conn->prepare("SELECT * FROM artist_profiles WHERE REPLACE(shop_slug, ' ', '') = ? AND subscription_status = 'active'"); $stmt->bind_param("s", $slug_clean); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) $artist = $result->fetch_assoc(); } $stmt->close(); if ($artist) $artist_id = $artist['user_id']; } elseif (isset($_GET['id']) && !empty($_GET['id'])) { // Search by ID $artist_id = intval($_GET['id']); $stmt = $conn->prepare("SELECT * FROM artist_profiles WHERE user_id = ? AND subscription_status = 'active'"); $stmt->bind_param("i", $artist_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) $artist = $result->fetch_assoc(); $stmt->close(); } // 3. IF ARTIST NOT FOUND if (!$artist) { include 'header.php'; echo "

Profile Unavailable

"; include 'footer.php'; exit(); } // 4. FETCH PAINTINGS $paintings = []; $p_stmt = $conn->prepare("SELECT id, title, image_path, price, sale_price FROM paintings WHERE artist_id = ? ORDER BY uploaded_at DESC"); $p_stmt->bind_param("i", $artist_id); $p_stmt->execute(); $p_result = $p_stmt->get_result(); if ($p_result) $paintings = $p_result->fetch_all(MYSQLI_ASSOC); $p_stmt->close(); // 5. FETCH ACHIEVEMENT PHOTOS (NEW) $ach_photos = []; $a_stmt = $conn->prepare("SELECT image_path FROM artist_achievements WHERE user_id = ? ORDER BY uploaded_at DESC"); $a_stmt->bind_param("i", $artist_id); $a_stmt->execute(); $a_res = $a_stmt->get_result(); if ($a_res) $ach_photos = $a_res->fetch_all(MYSQLI_ASSOC); $a_stmt->close(); // --- DATA PREPARATION --- $full_name = htmlspecialchars($artist['first_name'] . ' ' . $artist['last_name']); $shop_name = htmlspecialchars($artist['shop_name']); $bio = htmlspecialchars(strip_tags($artist['bio'] ?? '')); $short_bio = mb_substr($bio, 0, 150) . '...'; $image_url = "https://unitedculturalforum.com/" . ($artist['profile_image_path'] ?? 'images/default_avatar.png'); if (!empty($artist['shop_slug'])) { $page_url = "https://unitedculturalforum.com/artist/" . rawurlencode($artist['shop_slug']); } else { $page_url = "https://unitedculturalforum.com/artist_profile.php?id=" . $artist['user_id']; } $share_text = "Check out the artwork of $full_name on UCF!"; include 'header.php'; ?>
<?php echo $shop_name; ?>

query("SELECT id FROM followers WHERE customer_id=".$_SESSION['user_id']." AND artist_id=".$artist_id); if($chk && $chk->num_rows > 0) $is_following = true; } ?> Login to Follow

Biography

Details

Subjects
Achievements
Achievement Photos

Artwork Gallery

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

₹ View Details

This artist hasn't uploaded any artwork yet.