PHP - 删除功能不起作用


PHP - DELETE function not working

$query = "SELECT * FROM categories";
$select_categories = mysqli_query($connection, $query);
while ($row = mysqli_fetch_assoc($select_categories)) {
$cat_id = $row['cat_id'];
$cat_title = $row['cat_title'];
echo "<tr>";
echo "<td>{$cat_id}</td>";
echo "<td>{$cat_title}</td>";
echo "<td><a href='categories.php?delete={$cat_id}'>Delete</a></td>";
echo "</tr>";
}
?>
<?php 
//DELETE QUERY;
if(isset($_GET['detele'])) {
$the_cat_id = $_GET['delete'];
$query = "DELETE FROM categories WHERE cat_id = {$the_cat_id} ";
$delete_query = mysqli_query($connection,$query);
header("Location: categories.php");
}
?>     
所以,我

有一个页面,它向我展示了我数据库中的每个项目(类别(,我让它们按 id 排序,除了一件事之外,一切都很好。当我尝试删除项目时,没有任何反应。问题是我没有错误,这让我徘徊为什么不起作用。

可能是if(isset($_GET['detele']))中的拼写错误,detele应该delete检查您的代码

是的拼写错误,因此它永远不会进入条件,也永远不会运行删除查询。请更正并确认。

不對:

if(isset($_GET['detele']))

正确:

if(isset($_GET['delete']))