Should I manually check for errors when calling “mysqli_stmt_prepare”?

by

Is there a good reason to manually check the return value of that
function as it is shown in the manual?

Nope, there isn’t.

Mysqli can check for errors automatically, you just have to ask it to do so.
Configure mysqli to throw an exception every time it gets an error, and you won’t have to check any mysqli function for the error manually anymore!

Hence, add the following line before mysqli_connect()

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

and that’s all!

Note that you have to deal with possible errors the right way. You can read about it in my article, PHP error reporting

More Related Contents:

  1. PHP create new array by value
  2. PHP Mysqli query update not working with variable
  3. Turning a SQL row into an array
  4. How to insert database rows if there are no answers
  5. two person chat room
  6. Pagination data
  7. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. Fatal error: Call to a member function fetch_assoc() on a non-object [duplicate]
  11. MySQLi equivalent of mysql_result()?
  12. How to fix Trying to access array offset on value of type null error
  13. How to convert mysqli result to JSON? [duplicate]
  14. mysqli_fetch_array while loop columns
  15. How to bind an array of strings with mysqli prepared statement?
  16. How can I use mysqli_fetch_array() twice?
  17. Warning: mysqli_error() expects exactly 1 parameter, 0 given error
  18. Executing mysqli_query inside a function
  19. using nulls in a mysqli prepared statement
  20. Can’t return a result set in the given context
  21. store_result() and get_result() in mysql returns false
  22. Checking if mysqli_query returned any values?
  23. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. Fatal error: Call to undefined method mysqli_result::fetch_all()
  26. How to run the bind_param() statement in PHP?
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Set character set using MySQLi
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment