我是stackoverflow的新手,这是我在这个平台上的第一个问题:我的delete.php文件会给我一个";记录已删除";消息,但是,该项并没有从我的sql数据库中删除这是我的密码!你们能发现这个有什么问题吗?
<?php
require_once "pdo.php";
session_start();
if(isset($_POST['delete']) && isset($_POST['user_id'])){
$sql="DELETE FROM users WHERE user_id= :zip";
$stmt= $pdo->prepare($sql);
$stmt->execute(array(':zip' =>$_POST['user_id']));
$_SESSION['success']='Record Deleted';
header('Location: index.php');
return;}
$stmt=$pdo->prepare("SELECT name, user_id from users where user_id= :xyz");
$stmt->execute(array(":xyz"=>$_GET['user_id']));
$row = $stmt->fetch(PDO::FETCH_ASSOC);
if($row===false){
$_SESSION['error']="bad value for user id";
header('Location: index.php');
return;}
?>
<p>Confirm Deleting <?=htmlentities($row['name'])?></p>
<form method="post">
<input type="hidden" name="user_id" value="<?$row['user_id']?>">
<input type="submit" value="delete" name="delete">
<a href="index.php">Cancel</a>
</form>
对于那些有兴趣了解代码错误的人:
"<?$row['user_id']?>"
已更改为
"<?=$row['user_id']?>"
谢谢!