douxu3732
2016-08-06 00:28
浏览 81
已采纳

PHP Mysqli查询更新无法使用变量

I have this query:

$date = "january";
mysqli_query($connection->dbconn, "UPDATE monthly_visitors SET '$date' = 0");

But for some reason it does not work. The variable doesn't seem to work inside the query. Ideas why this is happening?

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

1条回答 默认 最新

  • douanrang4728 2016-08-06 00:35
    最佳回答

    It seems like you're trying to set the value in a column called "january" to zero for all rows. Is that really what you want to do? If so then try to remove the quotes around "$date". It shouldn't be quoted because it's a column name.

    Also, note that if $date would come from a user then this code snippet would be susceptible for SQL injections. Never use user input directly in a query. Verify it / escape it / use parameters instead.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题