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/-3dd57cae/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

$pdo = getDBConnection();

if (!$pdo) {
    die("Database connection failed!");
}

$track_id = 34; // Daniel track ID

echo "🗑️ Deleting track ID $track_id (Daniel)...\n";

try {
    // Start transaction
    $pdo->beginTransaction();
    
    // 1. Delete track likes
    $stmt = $pdo->prepare("DELETE FROM track_likes WHERE track_id = ?");
    $stmt->execute([$track_id]);
    $likes_deleted = $stmt->rowCount();
    echo "✅ Deleted $likes_deleted track likes\n";
    
    // 2. Delete track comments
    $stmt = $pdo->prepare("DELETE FROM track_comments WHERE track_id = ?");
    $stmt->execute([$track_id]);
    $comments_deleted = $stmt->rowCount();
    echo "✅ Deleted $comments_deleted track comments\n";
    
    // 3. Delete track plays
    $stmt = $pdo->prepare("DELETE FROM track_plays WHERE track_id = ?");
    $stmt->execute([$track_id]);
    $plays_deleted = $stmt->rowCount();
    echo "✅ Deleted $plays_deleted track plays\n";
    
    // 4. Delete the main track record
    $stmt = $pdo->prepare("DELETE FROM music_tracks WHERE id = ?");
    $stmt->execute([$track_id]);
    $track_deleted = $stmt->rowCount();
    
    if ($track_deleted > 0) {
        echo "✅ Deleted track record\n";
    } else {
        echo "❌ Track not found\n";
    }
    
    // Commit transaction
    $pdo->commit();
    
    echo "\n🎉 Track deletion completed successfully!\n";
    echo "Summary:\n";
    echo "- Track likes deleted: $likes_deleted\n";
    echo "- Track comments deleted: $comments_deleted\n";
    echo "- Track plays deleted: $plays_deleted\n";
    echo "- Track record deleted: $track_deleted\n";
    
} catch (Exception $e) {
    // Rollback transaction on error
    $pdo->rollBack();
    echo "❌ Error deleting track: " . $e->getMessage() . "\n";
}

// Verify deletion
$stmt = $pdo->prepare("SELECT COUNT(*) FROM music_tracks WHERE id = ?");
$stmt->execute([$track_id]);
$remaining = $stmt->fetchColumn();

if ($remaining == 0) {
    echo "\n✅ Verification: Track completely removed from database\n";
} else {
    echo "\n❌ Verification: Track still exists in database\n";
}
?>