PDO bindParam() with prepared statement isn’t working

Using bindParam() the variable is bound as a reference.

A string can’t be passed by reference.

The following things can be passed by reference:

Variables, i.e. foo($a)

New statements, i.e. foo(new foobar())

References returned from functions

Try using bindValue()

$STH->bindValue(':id', '1', PDO::PARAM_STR);

Related Posts:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDOException SQLSTATE[HY000] [2002] No such file or directory
  3. PDO with INSERT INTO through prepared statements
  4. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  5. Call to a member function on null?
  6. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  7. What is the advantage of using try {} catch {} versus if {} else {}
  8. Deprecated: mysql_query() [duplicate]
  9. How to log in to phpMyAdmin with WAMP, what is the username and password?
  10. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  11. Fatal error: Call to undefined function mysql_connect()
  12. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  13. Mysql query- How to use contains?
  14. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  15. Invalid column count in CSV input on line 1 Error
  16. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  17. Invalid column count in CSV input on line 1 Error
  18. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  19. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  20. phpMyAdmin: secret passphrase?
  21. Forbidden :You don’t have permission to access /phpmyadmin on this server
  22. Creating a search form in PHP to search a database?
  23. How can I do ‘insert if not exists’ in MySQL?
  24. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  25. pdo – Call to a member function prepare() on a non-object
  26. MySqli Commands out of sync; you can’t run this command now
  27. Trying to get property of non-object in
  28. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  29. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  30. Commands out of sync; you can’t run this command now
  31. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  32. Are PDO prepared statements sufficient to prevent SQL injection?
  33. PDO closing connection
  34. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  35. How can I do ‘insert if not exists’ in MySQL?
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. Object of class DateTime could not be converted to string
  38. What does it mean to escape a string?
  39. Convert from MySQL datetime to another format with PHP
  40. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  41. mysqli::query(): Couldn’t fetch mysqli
  42. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  43. Uncaught Error: Call to undefined function mysql_escape_string()
  44. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  45. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  46. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  47. MySQL query to get column names?
  48. What does MYSQLI_NUM mean and do?
  49. Mysql where id is in array
  50. select * from table where column = value ^ column2= value
  51. No query results for model [App\Products] Laravel
  52. Fatal error: Call to a member function query() on null
  53. mysqlworkbench giving version error on exporting database
  54. How to make DROP INDEX IF EXISTS for mysql?
  55. What is the meaning of sprintf(): Too few arguments
  56. Having a problem getting mysqli_query to execute
  57. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  58. Can I store images in MySQL 
  59. MySQL Daemon Failed to Start – centos 6
  60. How to insert TIMESTAMP into my MySQL table?
  61. How to remove index.php from WordPress site URL
  62. PHP Like thing similar to MySQL Like, for if statement?
  63. How get value from URL
  64. How to use Memcached with PHP7?
  65. select count(*) from table of mysql in php
  66. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  67. regex match any whitespace
  68. How do I resolve a HTTP 414 “Request URI too long” error?
  69. xajax expanding list query
  70. Data source name not found, and no default driver specified
  71. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  72. Illegal string offset Warning PHP
  73. Fatal error: Call to undefined function mysqli_connect()
  74. Could not open input file: artisan
  75. Why php tag is not working in html file?
  76. How to create cron job using PHP?
  77. Imploding an associative array in PHP
  78. curl POST format for CURLOPT_POSTFIELDS
  79. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  80. Easy way to password-protect php page
  81. Check if URL has certain string with PHP
  82. Subtracting days, months or years from date using php
  83. PHP date() format when inserting into datetime in MySQL
  84. PHP Multiple Checkbox Array
  85. Add value to usermeta without removing previous values?
  86. How can I call a row of user specific data from a custom table added to the WP Database
  87. theme options echoing multiple times
  88. how to echo all tables that start with a prefix
  89. Display data on Word Press site posts and pages from mysql table
  90. Accessing data from a non-WP database/table within a page content
  91. WordPress member notification
  92. Most commented posts by time period (last 12h, last 24h and etc)
  93. How to unserialize data from MySQL
  94. Known Issues in WordPress When Upgrading PHP to ver 7
  95. How to get database connection details without longing to cpanel in WordPress?
  96. Weird fonts showing which are coming from database
  97. autocomplete in wordpress using ajax with json-data
  98. SQL Query Search page
  99. How to pass username into form that sends data to database
  100. PHP Creating a formula from mysql db values and db stored math operator

Leave a Comment