Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/.cursor-server/data/User/History/-25f091e9/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
require_once 'config/database.php';

$pdo = getDBConnection();
$artist_id = 9;

// Get artist data
$stmt = $pdo->prepare("
    SELECT 
        u.id,
        u.name as username,
        up.genres,
        up.music_style,
        up.artist_highlights,
        up.influences,
        up.equipment,
        up.achievements,
        up.artist_statement
    FROM users u
    LEFT JOIN user_profiles up ON u.id = up.user_id
    WHERE u.id = ?
");

$stmt->execute([$artist_id]);
$artist = $stmt->fetch();

echo "<h1>Profile Data Test</h1>";
echo "<pre>";
print_r($artist);
echo "</pre>";

echo "<h2>Decoded Data:</h2>";
$genres = json_decode($artist['genres'] ?? '[]', true);
$highlights = json_decode($artist['artist_highlights'] ?? '[]', true);
$achievements = json_decode($artist['achievements'] ?? '[]', true);

echo "Genres: ";
print_r($genres);
echo "<br>";

echo "Highlights: ";
print_r($highlights);
echo "<br>";

echo "Achievements: ";
print_r($achievements);
echo "<br>";

echo "<h2>Display Test:</h2>";

// Test genre display
if (!empty($genres)) {
    echo '<div class="genre-tags">';
    foreach ($genres as $genre) {
        echo '<span class="genre-tag">' . htmlspecialchars($genre) . '</span>';
    }
    echo '</div>';
} else {
    echo "No genres found";
}

// Test music style
if ($artist['music_style']) {
    echo '<div class="music-style">';
    echo '<div class="style-label">🎵 Style:</div>';
    echo '<div class="style-text">' . htmlspecialchars($artist['music_style']) . '</div>';
    echo '</div>';
} else {
    echo "No music style found";
}

// Test highlights
if (!empty($highlights)) {
    echo '<div class="highlights-list">';
    foreach ($highlights as $highlight) {
        echo '<div class="highlight-item">';
        echo '<i class="fas fa-star"></i>';
        echo '<span>' . htmlspecialchars($highlight) . '</span>';
        echo '</div>';
    }
    echo '</div>';
} else {
    echo "No highlights found";
}
?>