Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]

by

Add more error handling.
When the connection fails, mysqli_connect_error() can tell you more details.
When preparing the statement fails mysqli_error() has more infos about the error.
When executing the statement fails, ask mysqli_stmt_error(). And so on and on…
Any time a function/method of the mysqli module returns false to indicate an error, a) handle that error and b) decide whether it makes sense or not to continue. E.g. it doesn’t make sense to continue with database operations when the connection failed. But it may make sense to continue inserting data when just one insertion failed (may make sense, may not).

For testing you can use something like this:

$connection = mysqli_connect(...);
if ( !$connection ) {
  die( 'connect error: '.mysqli_connect_error() );
}

$query = "INSERT INTO entries (name, dob, school, postcode, date) VALUES (?,?,?,?,?)";
$stmt1 = mysqli_prepare($connection, $query);
if ( !$stmt1 ) {
  die('mysqli error: '.mysqli_error($connection);
}
mysqli_stmt_bind_param($stmt1, 'sssss',$name,$dob,$school,$postcode,$date);
if ( !mysqli_execute($stmt1) ) {
  die( 'stmt error: '.mysqli_stmt_error($stmt1) );
}
...

For a real production environment this approach is to talkative and dies to easily 😉

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. PHP error: “Cannot pass parameter 2 by reference”
  5. Warning: mysqli_query() expects parameter 1 to be mysqli, null given in
  6. How to get count of rows in MySQL table using PHP?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. How to bind mysqli bind_param arguments dynamically in PHP?
  9. Warning: mysqli_select_db() expects exactly 2 parameters, 1 given
  10. How can I enable the MySQLi extension in PHP 7?
  11. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  12. Headers and client library minor version mismatch
  13. Advantages Of MySQLi over MySQL [closed]
  14. check if the query results empty row mysqli [duplicate]
  15. Is mysql_real_escape_string() necessary when using prepared statements?
  16. Updating from MYSQL to MYSQLI [duplicate]
  17. mysqli_stmt::execute() expects exactly 0 parameters, 1 given
  18. Mysqli get_result alternative
  19. mysqli query results to show all rows
  20. mysqli_real_connect(): (HY000/2002): No such file or directory
  21. mysqli + xdebug breakpoint after closing statement result in many warnings
  22. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  23. php password_verify() hash and pass won’t match
  24. PHP to MySQL SSL Connections
  25. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Is there any way to print the actual query that mysqli->execute() makes?
  28. When should I close a database connection in PHP?
  29. MySqli Commands out of sync; you can’t run this command now [duplicate]
  30. PHP and MySQLi – Cannot pass parameter 2 by reference in [duplicate]

Leave a Comment