PHP PDO删除按钮

Question

我尝试了各种方法，但它不起作用

选项.php

if (isset($_GET['agentsdelete'])) {
$agents_id=$_GET['agents_id'];
$delete=$db->prepare("DELETE FROM agents WHERE agents_id=:agents_id");
$control=$delete->execute(array(
    'agents_id' => $_GET['agents_id']
));
if ($control) {
    Header("Location:agents.php??durum=ok&agents_id=$agents_id");
} else {
    Header("Location:agents.php??durum=no&agents_id=$agents_id");
}

这是PHP脚本

索引.php

  <a href="option.php?agentsdelete=<?php echo $agentget['agents_id'];  ?>" class="btn btn-danger btn-sm btn-icon icon-left">
            <i class="entypo-cancel"></i>
            Delete
        </a>

这个是索引.php其中按钮

Answer 1

<?php
if (isset($_GET['agentsdelete'])) {
    $agents_id = $_GET['agentsdelete'];

    $delete = $db->prepare("DELETE FROM agents WHERE agents_id= ? ");
    if ($delete->execute(array(
        $agents_id
    ))) {
        Header("Location:agents.php??durum=ok&agents_id=$agents_id");
    } else {
        Header("Location:agents.php??durum=no&agents_id=$agents_id");
    }
}
?>

Answer 2

if (isset($_GET['agentsdelete'])) {
    $agents_id = $_GET['agentsdelete'];
    $delete = $db->prepare("DELETE FROM agents WHERE agents_id= ? ");
    header('location:agents.php');
    $delete-> execute();
}

这是足够的代码，不要让它变得复杂。
这很容易。