PHP Mysqli query update not working with variable

by

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.

More Related Contents:

  1. Turning query errors to Exceptions in MySQLi [duplicate]
  2. Should we ever check for mysqli_connect() errors manually?
  3. How to prevent duplicate usernames when people register?
  4. How to use mysqli prepared statements?
  5. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  6. Why can’t I run two mysqli queries? The second one fails [duplicate]
  7. Call to a member function prepare() on a non-object PHP Help
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. MySQLi query returns only one row
  12. How to call a MySQL stored procedure from within PHP code?
  13. How do I migrate my site from mysql to mysqli? [duplicate]
  14. Converting MySQL result array to JSON [duplicate]
  15. Fatal error: Cannot use object of type mysqli_result [closed]
  16. Do I have to guard against SQL injection if I used a dropdown?
  17. Inserting data to table (mysqli insert) [duplicate]
  18. Using MySQLi from another class in PHP
  19. How to echo a MySQLi prepared statement?
  20. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  21. MySQLi prepared statements with IN operator [duplicate]
  22. MySQLI binding params using call_user_func_array
  23. Unknown database error in PHP but it exists in PHPMyAdmin
  24. Can I blindly replace all mysql_ functions with mysqli_?
  25. Is mysqli_real_escape_string safe?
  26. Set character set using MySQLi
  27. mysqli persistent connection
  28. Create mysql trigger via PHP?
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment