PHP MySQL 查询不起作用，但可以从终端运行

Question

这是我的代码:

$gid = (int) stripslashes($_POST['id']);
echo $gid;<p></p>

<p>$db = dbConnect();
$test = $db->query('update games set played = played + 1 where id = "$gid"');
echo $db->error;
echo $db->errno;
die();
}
</p>

它在终端上工作正常，并且正确打印出 $gid，并且没有返回任何错误。我是否漏掉了一些非常明显的东西？

Answer 1

您将查询括在单引号中。并且在单引号中变量插值(也称为替换)不会发生。

简单的例子:

$who = 'harry potter';
echo 'hi "$who"'; // prints hi "$who"
echo "hi '$who'"; // prints hi 'harry potter'

将您的代码更改为:

$test = $db->query("update games set played = played + 1 where id = '$gid'");

同样来自行:$gid = (int) stripslashes($_POST['id']); 很明显 $gid 是一个整数并且有不需要在查询中将其括在引号中。所以我们有:

$test = $db->query("update games set played = played + 1 where id = $gid");