prepare($sql); $stmt->bind_param("i", $artist_user_id); $stmt->execute(); $result = $stmt->get_result(); $profile = $result->fetch_assoc(); if (!$profile) { $profile = array_fill_keys(['first_name', 'last_name', 'shop_name', 'shop_slug', 'phone', 'address', 'bio', 'achievements', 'artist_statement', 'art_specialization', 'subjects', 'awards', 'additional_notes', 'bank_name', 'bank_account_iban', 'profile_image_path'], ''); } $stmt->close(); // 2. Fetch Achievement Photos (NEW) $ach_photos = []; $ach_stmt = $conn->prepare("SELECT id, image_path FROM artist_achievements WHERE user_id = ? ORDER BY uploaded_at DESC"); $ach_stmt->bind_param("i", $artist_user_id); $ach_stmt->execute(); $ach_res = $ach_stmt->get_result(); if($ach_res) $ach_photos = $ach_res->fetch_all(MYSQLI_ASSOC); $ach_stmt->close(); // Social Link Logic $base_url = "https://unitedculturalforum.com/artist_profile.php?name="; $shop_url = $base_url . urlencode($profile['shop_slug'] ?: 'your-shop-name'); ?>

Manage Your Profile

View Public Profile

Public Profile

First Name

Last Name

Phone

Profile Picture

Address

Artist Details

Biography

Art Specialization

Main Subjects

Achievements / Exhibitions Your Uploaded Photos:

Add New Photos

Awards

Shop Settings

Shop Name

Shop URL (Slug)

close(); include 'footer.php'; ?>