Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

by

You need to use bindValue, not bindParam

bindParam takes a variable by reference, and doesn’t pull in a value at the time of calling bindParam. I found this in a comment on the PHP docs:

bindValue(':param', null, PDO::PARAM_INT);

P.S. You may be tempted to do this bindValue(':param', null, PDO::PARAM_NULL); but it did not work for everybody (thank you Will Shaver for reporting.)

More Related Contents:

  1. What is the best way to insert multiple rows in PHP PDO MYSQL?
  2. MySQL and PHP – insert NULL rather than empty string
  3. MySQL, how to insert null dates
  4. PHP PDO and Mysql [closed]
  5. PDO Fetch statement only retrieves first column
  6. PHP – Using PDO with IN clause array
  7. How to properly set up a PDO connection
  8. PHP PDO prepared statements
  9. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  10. PDO binding values for MySQL IN statement [duplicate]
  11. PDO mysql: How to know if insert was successful
  12. How can I properly use a PDO object for a parameterized SELECT query
  13. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  14. PHP/MySQL Insert null values
  15. implement LIKE query in PDO
  16. PHP PDO prepared statement — MySQL LIKE query
  17. Fetching single row, single column with PDO
  18. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  19. PDO Connection Test
  20. How do I loop through a MySQL query via PDO in PHP?
  21. using nulls in a mysqli prepared statement
  22. PDO error: SQLSTATE[HY000]: General error: 2031
  23. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  24. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  25. Use of PDO in classes [duplicate]
  26. How to handle PDO exceptions [duplicate]
  27. Check if row exists in the database before inserting
  28. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  29. PDO and MySQL Fulltext searches
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment