根据单击的按钮从数据库中删除

Question

我有一个脚本在屏幕上打印一个表的所有数据。与每一行数据相关联，我有一个delete按钮，我希望，当任何一行的按钮被裁剪时，该行将被删除。为此，我有以下代码：

$con = mysqli_connect("","","","");

$result = mysqli_query($con,"SELECT * FROM `clientes_pmt`");

while($row = mysqli_fetch_array($result)){
    ?> <button name="delete" value="<?php echo $row['id']; ?>" type="submit"><img src="paginas/borrar.jpg" /></button>
    <a href="page<?php echo $row['nombre']; ?>">
        <div><p><?php echo $row['nombre']; ?></p></div>
        <div><p><?php echo $row['pais']; ?></p></div>
    </a>
    <section class="clearboth"></section><br><?php
}

if(isset($_POST['delete'])){
    $id = $_POST['delete'];
    $result = mysqli_query($con,"DELETE FROM `clientes_pmt` WHERE id = '$id'");
}

mysqli_close($con);

我没有收到任何错误，但是该行没有被删除。

Answer 1

将按钮封装在form元素中，并设置适当的action和method属性，如下所示：

<form action="/delete.php" method="POST">
  <button ...> [your button]
</form>

Answer 2

你必须修改这些行

$con = mysqli_connect("localhost","root","","YOUR DATABASE NAME");

Answer 3

要查看结果，可以在这部分代码的末尾放置一个header()：

if(isset($_POST['delete'])){
    $id = $_POST['delete'];
    $result = mysqli_query($con,"DELETE FROM `clientes_pmt` WHERE id = '$id'");

    header('location:your_page_where_the_rows_are.php');
}