prepare("SELECT id FROM competition_entries WHERE merchant_transaction_id = ?"); $stmt->bind_param("s", $reg_code); $stmt->execute(); if ($stmt->get_result()->num_rows === 0) { die("Invalid Registration Code."); } $stmt->close(); // --- FILE UPLOAD LOGIC --- $upload_dir = 'uploads/competitions/'; if (!is_dir($upload_dir)) { mkdir($upload_dir, 0755, true); } $user_photo_path = null; $artwork_path = null; try { // 1. Upload User Photo if (isset($_FILES['user_photo']) && $_FILES['user_photo']['error'] === UPLOAD_ERR_OK) { $ext = pathinfo($_FILES['user_photo']['name'], PATHINFO_EXTENSION); $filename = 'user_' . $reg_code . '.' . $ext; if (move_uploaded_file($_FILES['user_photo']['tmp_name'], $upload_dir . $filename)) { $user_photo_path = $upload_dir . $filename; } } // 2. Upload Artwork if (isset($_FILES['artwork_photo']) && $_FILES['artwork_photo']['error'] === UPLOAD_ERR_OK) { $ext = pathinfo($_FILES['artwork_photo']['name'], PATHINFO_EXTENSION); $filename = 'art_' . $reg_code . '.' . $ext; if (move_uploaded_file($_FILES['artwork_photo']['tmp_name'], $upload_dir . $filename)) { $artwork_path = $upload_dir . $filename; } } if (!$user_photo_path || !$artwork_path) { throw new Exception("File upload failed. Please try again."); } // 3. Update Database $stmt = $conn->prepare("UPDATE competition_entries SET user_photo_path = ?, artwork_photo_path = ? WHERE merchant_transaction_id = ?"); $stmt->bind_param("sss", $user_photo_path, $artwork_path, $reg_code); $stmt->execute(); $stmt->close(); // Success! echo ""; echo "

"; echo "

Upload Successful!

"; echo "

Your entry has been fully submitted. Good luck!

"; echo "Return Home"; echo "

"; } catch (Exception $e) { echo "Error: " . $e->getMessage(); } ?>