我有 2 个网页,修改新闻博客,如果我想删除博客,它会打开删除.php。
我使用
$query = $db->prepare('SELECT * FROM `news` order by date DESC');
$query->execute();
$query->store_result();
$query->bind_result($id,$title);
while ($query->fetch()) {
$_SESSION['id'] = $id ;
$_SESSION['title'] = $title ;
<a href="deletenews.php">
}
我为$id
和$title
做了 2 次会议。我有一个删除按钮,可以删除.php,
$id = $_SESSION['id'];
$title = $_SESSION['title'];
$query = $db->prepare('DELETE FROM `news` WHERE id = ? and title = ?');
$query->bind_param('ss', $id, $title);
$query->execute();
unset($_SESSION['id']);
unset($_SESSION['title']);
header("location: news.php");
我调用$id
和$title
会话进行测试,在修改页面上,它工作正常,但是当它转到删除.php时,它会发生变化。它正在从数据库中删除,但不是例如 id 1,它将删除 id 2,它将删除数据库中列表中的下一个。我觉得很奇怪。
如果有人能帮忙...
如果您有 2 条记录,则第一个 id = 1,第二个 id = 2
while ($query->fetch()) {
$_SESSION['id'] = $id ;
//First loop $_SESSION['id'] = 1
//second loop $_SESSION['id'] = 2
$_SESSION['title'] = $title ;
<a href="deletenews.php">
}
// at the end $_SESSION['id'] = 2
你想做的是
while ($query->fetch()) {
<a href="deletenews.php?id=$id&title=$title">
//it will link the link ;) with the id of the news
}
删除.php中的更改将是:
$id = $_GET['id'];
$title = $_GET['title'];
玩得愉快