Mysqli update throwing Call to a member function bind_param() error [duplicate]

by

O, let’s try a canonical answer.

Call to a member function (or expects parameter 1 to be mysqli_result, boolean given for the procedural style) is not an error itself but just a symptom, for some other problem.
This very error message means that no object was created where should.

So – there was a problem with creating an $stmt object.
Most likely it’s a problem with the query.
So, we need to track that error down.

Mysqli won’t tell you what’s going on unless asked explicitly. So, you have to always check the result of every mysqli function interacting with server and if result is FALSE – check $mysqli->error.

It is also very important to convert mysqli error message into PHP error, to let it go according site-wide error reporting settings.

If you are using mysqli_query() all over the application code without encapsulating it into some helper class, trigger_error() is a good way to raise a PHP error, as it will tell you also the file and the line number where error occurred

So, all your prepare(), execute() and query() calls have to be written this way:

$stmt = $mysqli->prepare($query) or trigger_error($mysqli->error."[$query]");

or in procedural style

$res = mysqli_query($mysqli,$query) or trigger_error(mysqli_error($mysqli)."[$query]");

in all your scripts
and since then you will be notified of the reason, why the object weren’t created.
(If you’re curious of this or syntax, I’ve explained it here)
Note that query also included in the error message, to let you inspect it visually and test in another environment.

However, if you’re encapsulating your query into some class, file and line from trigger error will be quite useless as they will point to the call itself, not the application code that caused certain problem. So, when running mysqli commands encapsulated, another way have to be used:

$result = $mysqli->query($sql);
if (!$result) {
    throw new Exception($mysqli->error." [$query]");
}

as Exception will provide you with a stack trace, which will lead you the the place from which an erroneous query were called.

Note that you have to be able to see PHP errors in general. On a live site you have to peek into error logs, so, settings have to be

error_reporting(E_ALL);
ini_set('display_errors',0);
ini_set('log_errors',1);

while on a local development server it’s all right to make errors on screen:

error_reporting(E_ALL);
ini_set('display_errors',1);

and of course you should never ever use error suppression operator (@) in front of your statements.

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. MySQL vs MySQLi when using PHP [closed]
  4. Fatal error: Call to undefined function mysqli_connect()
  5. PHP error: “Cannot pass parameter 2 by reference”
  6. Warning: mysqli_query() expects parameter 1 to be mysqli, null given in
  7. MySQLi prepared statements error reporting [duplicate]
  8. Why is mysqli giving a “Commands out of sync” error?
  9. Warning: mysqli_select_db() expects exactly 2 parameters, 1 given
  10. mysqli fetch_all() not a valid function?
  11. Dynamic select mysqli query with dynamic parameters returns error doesn’t match number of bind variables [duplicate]
  12. Headers and client library minor version mismatch
  13. MySQLi Bind Param with an array for IN [duplicate]
  14. SELECT * FROM in MySQLi
  15. PHP PDO and MySQLi [duplicate]
  16. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  17. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  18. mysqli query results to show all rows
  19. mysqli_real_connect(): (HY000/2002): No such file or directory
  20. mysqli + xdebug breakpoint after closing statement result in many warnings
  21. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  22. php password_verify() hash and pass won’t match
  23. PHP to MySQL SSL Connections
  24. Call to undefined method mysqli_result::fetch()
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. prepared parameterized query with PDO
  27. How to make mysqli connect function?
  28. Dynamically bind mysqli_stmt parameters and then bind result
  29. Check to see if an email is already in the database using prepared statements
  30. How to insert into MySQL using mysqli

Leave a Comment