我有一行需要通过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语句,我检查了一下。条件已满足,但不执行删除操作。我该如何解决这个问题呢?
发布于 2014-12-08 01:42:25
此语法应适用于任何数据库:
DELETE FROM stocks WHERE id = XXX我不知道? $_SESSION[id]应该做什么。在没有?的情况下尝试
DELETE FROM stocks WHERE id = $_SESSION[id]也就是说,您应该参数化查询,而不是将参数放入查询字符串中。
https://stackoverflow.com/questions/27345614
复制相似问题