prepare("SELECT CONCAT(first_name, ' ', last_name) as full_name FROM artist_profiles WHERE user_id = ?"); $name_stmt->bind_param("i", $artist_id); $name_stmt->execute(); $name_res = $name_stmt->get_result(); if($row = $name_res->fetch_assoc()) { $artist_name = $row['full_name']; } // --- HANDLE EDIT MODE --- if ($action === 'edit' && isset($_GET['id'])) { $edit_mode = true; $painting_id = filter_var($_GET['id'], FILTER_SANITIZE_NUMBER_INT); $stmt = $conn->prepare("SELECT * FROM paintings WHERE id = ? AND artist_id = ?"); $stmt->bind_param("ii", $painting_id, $artist_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) $painting_to_edit = $result->fetch_assoc(); else { header('Location: paintings.php?error=not_found'); exit(); } $stmt->close(); } // Fetch Paintings $paintings = []; $stmt = $conn->prepare("SELECT id, title, price, sale_price, image_path, description FROM paintings WHERE artist_id = ? ORDER BY uploaded_at DESC"); $stmt->bind_param("i", $artist_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows > 0) $paintings = $result->fetch_all(MYSQLI_ASSOC); $stmt->close(); ?>

My Paintings

Add New Painting

>

Current image:

Separate keywords with commas or spaces.

>

I confirm that I hold the full copyright for this painting, including the right to authorize its display, promotion, and sale on United Cultural Forum.

Cancel

Your Uploaded Artwork

Image Title Price Actions
₹ | Edit