我有一行需要通过 PHP 从 SQL 表中删除。该表有 3 列:id、Symbol 和 Shares:
foreach ($rows as $row)
{
if($row["Symbol"] === $_POST["symbol"])
{
// I tried these combinations, but none of them works:
// $sql = ("DELETE FROM stocks WHERE id = ? $_SESSION[id]");
// $sql = ("DELETE row FROM stocks WHERE id = $_SESSION[id]");
// $sql = ("DELETE * FROM stocks WHERE id = $_SESSION[id]");
// $sql = ("DELETE id, Symbol, Shares FROM stocks WHERE id = $_SESSION[id]");
// DELETE FROM stocks WHERE id = $_SESSION["id"];
}
}
我的程序输入了一个 if 语句,我对此进行了检查。条件已满足,但 DELETE 未执行。我怎样才能解决这个问题?
此语法应该适用于任何数据库:
DELETE FROM stocks WHERE id = XXX
我不知道什么? $_SESSION[id]
应该是在做的。尝试不使用?
:
DELETE FROM stocks WHERE id = $_SESSION[id]
也就是说,您应该参数化查询,而不是将参数放入查询字符串中。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)