Untitled Page

prepare("SELECT filename, edited_webpath, title, description, username, category, price, buttons FROM uploads WHERE pmk = ?"); $stmt->bind_param("s", $pmk); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows === 0) { http_response_code(404); throw new Exception("This artwork does not exist or has been removed."); } $stmt->bind_result($filename, $editedWebPath, $title, $description, $username, $category, $price, $buttons); $stmt->fetch(); $stmt->close(); $filePath = $editedWebPath ?: $filename ?: 'thumbnails/default-thumb.jpg'; $profileUrl = "profile.php.php?user=" . urlencode($username); $sessionId = session_id(); $btns = json_decode($buttons ?? '{}', true); $selectedBtns = $btns['selected'] ?? []; $showShareIcons = in_array('Share', $selectedBtns); $showDownload = in_array('Download', $selectedBtns); $profilePic = 'thumbnails/default-profile.jpg'; $userStmt = $mysqli->prepare("SELECT profile_icon FROM users WHERE username = ?"); $userStmt->bind_param("s", $username); $userStmt->execute(); $userStmt->bind_result($profileIcon); if ($userStmt->fetch() && $profileIcon) { $profilePic = $profileIcon; } $userStmt->close(); $updateViews = $mysqli->prepare("UPDATE uploads SET views = views + 1 WHERE pmk = ?"); $updateViews->bind_param("s", $pmk); $updateViews->execute(); $updateViews->close(); $liked = false; $check = $mysqli->prepare("SELECT 1 FROM likes_tracker WHERE z_pmk = ? AND session_id = ?"); $check->bind_param("ss", $pmk, $sessionId); $check->execute(); $check->store_result(); $liked = $check->num_rows > 0; $check->close(); $meta = $mysqli->prepare("SELECT likes, views FROM uploads WHERE pmk = ?"); $meta->bind_param("s", $pmk); $meta->execute(); $meta->bind_result($likes, $views); if (!$meta->fetch()) { $likes = 0; $views = 0; } $meta->close(); } catch (Exception $e) { $errorMessage = $e->getMessage(); } ?> <?= isset($title) ? htmlspecialchars($title) : "Artwork Error" ?>

Error:

Views

Comments (0)

Explore More

prepare("SELECT pmk, filename, title FROM uploads WHERE filetype IN ('jpg','jpeg','png','gif') AND username != ? ORDER BY RAND() LIMIT 25"); $explore->bind_param("s", $username); $explore->execute(); $explore->bind_result($rowPmk, $rowFilename, $rowTitle); while ($explore->fetch()): ?>

close(); ?>

Image Share Functionality

URL Copied to Clipboard!

Home

Acc

Profile

Gemart

Dashboard

Notifications

Hide Menu

Show Menu