删除查询不'；不起作用 - delete query doesn't work

delete query doesn't work

本文关键字：不起作用查询删除 | 更新日期: 2023-09-27

我做了一个删除查询。删除查询用于删除管理员发布的帖子，但如果我点击删除按钮，我会转到一个没有找到对象的屏幕。我将显示删除查询：

    include '../db/db.php';
$id = $_GET['0'];
$query = "DELETE FROM pages WHERE paginaNummer = :id";
$stmt = $dbcon->prepare($query);
$stmt->execute(array(':id' => $id));
$row=$stmt->fetch();
header("Location: http://127.0.0.1/cmsFenB/index.php");

这是数据库连接：

<?php
try {
    $db = new PDO('mysql:host=localhost;dbname=register', 'root', '');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}   catch(PDOException $e) {
    echo $e->getMessage();
    die();
}
?>

这里是这个脚本的链接：

echo "&nbsp;<a class='delete' href='fucntions/admin/delete.php?id=" . $pageNumber . " '>Delete</a>";

我希望你能帮我解决这个问题。

您在引用链接中有一个拼写错误。它应该是这样的：

echo "&nbsp;<a class='delete' href='functions/admin/delete.php?id=" . $pageNumber . " '>Delete</a>";

$id=$_GET['0'];？我想你的意思是$_GET['id']

$id=$_GET['id'];
$query = "DELETE FROM pages WHERE paginaNummer = :id";
$stmt = $db->prepare($query);
$stmt->execute(array(':id' => $id));