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

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.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?