php - 如何从 SQL 表中删除一行？

Question

我需要通过 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 未执行。我该如何解决这个问题？

Answer 1

此语法应该适用于任何数据库:

DELETE FROM stocks WHERE id = XXX

我不知道是什么？ $_SESSION[id] 应该是这样做的。尝试不使用 ?:

DELETE FROM stocks WHERE id = $_SESSION[id]

也就是说，您应该对查询进行参数化，而不是将参数放入查询字符串中。