试图删除表中的条目。 查询不删除行，不知道如何调试

Question

I'm trying to delete an entry in my database using the code below. The javascript function takes me to index.php?delpost= with the correct "adventureID" but when I check my database the row is still there. I've very recently started using PDO so I'm wondering if the execute() statement might be the issue. $dbh connect to my database at the top of the page and it is working as it prints every row from the table I'm trying to delete rows from. My goal is to successfully delete a row when I call the javascript function. The issue is - it doesn't.

<script language="JavaScript" type="text/javascript">
    function delpost(adventureID, title)
    {
        if (confirm("Are you sure you want to delete '" + title + "'" + " '" + adventureID + "'"))
        {
            window.location.href = 'index.php?delpost=' + adventureID;
        }
    }
</script>


<?php
    if(isset($_GET['delpost'])){
        $stmt = $dbh->prepare("DELETE FROM adventure WHERE adventureID = :adventureID");
        $stmt->execute(array(':adventureID' => $_GET['delpost']));
        header('Location: index.php?action=deleted');
        exit;
    }
?>


<?php
if(isset($_GET['action'])){
    echo '<h3>Post '.$_GET['action'].'.</h3>';
}

try {
    foreach($dbh->query("SELECT adventureID, title, postDate FROM adventure ORDER BY adventureID DESC") as $row) {
        echo '<tr>';
        echo '<td>'.$row['title'].'</td>';
        echo '<td>'.date('jS M Y', strtotime($row['postDate'])).'</td>';
        ?>

        <td>
            <a href="javascript:delpost('<?php echo $row['adventureID'] ?>','<?php echo $row['title'] ?>')">Delete</a>
        </td>

        <?php
        echo '</tr>';

    }

} catch(PDOException $e) {
    echo $e->getMessage();
}
?>

Answer 1

Probably you are facing problem with MYSQL SAFE UPDATES being ON. To avoid it and be able to finally delete rows, you can engage in the following tactics:

SET SQL_SAFE_UPDATES = 0;

--- YOUR DELETE STATEMENT ---

SET SQL_SAFE_UPDATES = 1;

To check if you have SQL_SAFE_UPDATES enabled you can do by running:

SHOW VARIABLES LIKE 'sql_safe_updates'