PHP error: “Cannot pass parameter 2 by reference”

by

The error means that the 2nd argument is expected to be a reference to a variable.

Since you are not handing a variable but an integer of value 0, it generates said error.

To circumvent this do:

$a = 0;
$update->bind_param("is", $a, $selectedDate);  //LINE 13

In case you want to understand what is happening, as opposed to just fixing your Fatal error, read this: http://php.net/manual/en/language.references.pass.php

More Related Contents:

  1. Object of class mysqli_result could not be converted to string
  2. SELECT COUNT(*) AS count – How to use this count
  3. Strict Standards: mysqli_next_result() error with mysqli_multi_query
  4. Why does mysqli num_rows always return 0?
  5. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  6. What is the difference between MySQL, MySQLi and PDO? [closed]
  7. parameters in MySQLi
  8. Retrieving Multiple Result sets with stored procedure in php/mysqli
  9. Mysql No connection could be made because the target machine actively refused it
  10. How to connect to MySQL database in PHP using mysqli extension?
  11. How do I count query result rows?
  12. $stmt->execute() : How to know if db insert was successful?
  13. Bind Param with array of parameters
  14. How do you use IN clauses with mysqli prepared statements [duplicate]
  15. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  16. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  17. How to fetch all in assoc array from a prepared statement?
  18. Fatal error: Call to undefined function mysqli_result()
  19. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  20. Why I am getting an error when using w3school tutorial? [duplicate]
  21. Using wildcards in prepared statement
  22. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  23. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? [duplicate]
  24. How to remove the fatal error when fetching an assoc array
  25. Fatal error: Call to undefined method mysqli_stmt::get_result()
  26. PHP MySQLi Multiple Inserts
  27. Fatal error: Call to a member function prepare() on a non-object in
  28. Using Prepared Statement, how I return the id of the inserted row?
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. When should I close a database connection in PHP?

Leave a Comment