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/-319a696b/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

echo "<h1>🎵 Playlist Debug</h1>";
echo "<style>body{font-family:Arial;background:#0a0a0a;color:white;padding:20px;} .section{background:#1a1a1a;padding:20px;margin:20px 0;border-radius:8px;} .error{color:#ff6b6b;} .success{color:#51cf66;}</style>";

try {
    $pdo = getDBConnection();
    echo "<div class='section success'>✅ Database connection successful</div>";
    
    // Check if tables exist
    $tables = ['users', 'artist_playlists', 'playlist_tracks', 'music_tracks'];
    foreach ($tables as $table) {
        $stmt = $pdo->query("SHOW TABLES LIKE '$table'");
        if ($stmt->rowCount() > 0) {
            echo "<div class='section success'>✅ Table '$table' exists</div>";
        } else {
            echo "<div class='section error'>❌ Table '$table' does not exist</div>";
        }
    }
    
    // Check users
    echo "<div class='section'>";
    echo "<h3>👥 Users in Database:</h3>";
    $stmt = $pdo->query("SELECT id, name, email FROM users LIMIT 10");
    $users = $stmt->fetchAll();
    if (empty($users)) {
        echo "<p class='error'>No users found</p>";
    } else {
        echo "<ul>";
        foreach ($users as $user) {
            echo "<li>ID: {$user['id']} - Name: {$user['name']} - Email: {$user['email']}</li>";
        }
        echo "</ul>";
    }
    echo "</div>";
    
    // Check artist playlists
    echo "<div class='section'>";
    echo "<h3>🎵 Artist Playlists:</h3>";
    $stmt = $pdo->query("SELECT * FROM artist_playlists LIMIT 10");
    $playlists = $stmt->fetchAll();
    if (empty($playlists)) {
        echo "<p class='error'>No artist playlists found</p>";
    } else {
        echo "<ul>";
        foreach ($playlists as $playlist) {
            echo "<li>ID: {$playlist['id']} - Name: {$playlist['name']} - User: {$playlist['user_id']}</li>";
        }
        echo "</ul>";
    }
    echo "</div>";
    
    // Check music tracks
    echo "<div class='section'>";
    echo "<h3>🎶 Music Tracks:</h3>";
    $stmt = $pdo->query("SELECT * FROM music_tracks LIMIT 10");
    $tracks = $stmt->fetchAll();
    if (empty($tracks)) {
        echo "<p class='error'>No music tracks found</p>";
    } else {
        echo "<ul>";
        foreach ($tracks as $track) {
            echo "<li>ID: {$track['id']} - Title: {$track['title']} - Status: {$track['status']} - User: {$track['user_id']}</li>";
        }
        echo "</ul>";
    }
    echo "</div>";
    
    // Test the API directly
    echo "<div class='section'>";
    echo "<h3>🔗 API Test:</h3>";
    echo "<p>Testing artist playlist API for artist ID 1:</p>";
    
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, "http://" . $_SERVER['HTTP_HOST'] . "/api/get_artist_playlist.php?artist_id=1");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_TIMEOUT, 10);
    $response = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
    curl_close($ch);
    
    echo "<p>HTTP Code: $httpCode</p>";
    echo "<p>Response: <pre>" . htmlspecialchars($response) . "</pre></p>";
    echo "</div>";
    
} catch (Exception $e) {
    echo "<div class='section error'>❌ Error: " . $e->getMessage() . "</div>";
}
?>

<div class='section'>
    <h3>🎯 Quick Fix Options:</h3>
    <ol>
        <li><strong>Add Test Data:</strong> Create a test artist and tracks in the database</li>
        <li><strong>Use Demo Playlist:</strong> Modify the player to use hardcoded demo tracks</li>
        <li><strong>Fix API:</strong> Debug why the API calls are failing</li>
    </ol>
</div>