<?php 
if (isset($_GET['deleteUser'])) {
    $filmId = $_GET['deleteUser'];

    // Check if this film is linked to any Plage
    $checkStmt = $LINK->prepare("SELECT isActif FROM CinePerson WHERE pk_person = ?");
    $checkStmt->bind_param('i', $filmId);
    $checkStmt->execute();
    $checkStmt->bind_result($count);
    $checkStmt->fetch();
    $checkStmt->close();

    if ($count > 0) {
        echo "<p style='color:red;'>Cannot delete User: Linked to a Plage.</p>";
        
        echo "<a href='?Users'><button type='button'>Go Back</button></a>";

    } else {
        // Safe to delete
        $deleteStmt = $LINK->prepare("DELETE FROM CinePerson WHERE pk_person = ?");
        $deleteStmt->bind_param('i', $filmId);
        $deleteStmt->execute();
        $deleteStmt->close();
        echo "<p style='color:green;'>Film deleted successfully.</p>";

        // Optional redirect to refresh the list
        header("Location: ?Users");
        exit();
    }
}
?>