Is there any way to print the actual query that mysqli->execute() makes?

by

If your statement is failing, you should check $stmt->error (as opposed to $dbi->error). As far as getting the actual text of the query: it’s not possible. When using prepared statements, the library is using a special protocol that doesn’t generate an actual query string for each ->execute() call.

More Related Contents:

  1. About how does mysqli_query() Function and mysqli_fetch_array($result) work?
  2. Can I mix MySQL APIs in PHP?
  3. Turning query errors to Exceptions in MySQLi [duplicate]
  4. How to change mysql to mysqli?
  5. Best way to INSERT many values in mysqli?
  6. Call to a member function bind_param() on a non-object [duplicate]
  7. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  8. Why can’t I run two mysqli queries? The second one fails [duplicate]
  9. MySQLi prepared statements error reporting [duplicate]
  10. How can I get an unknown username given an ID?
  11. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  12. mysqli_query() expects parameter 1 to be mysqli, object given
  13. MySQLi query returns only one row
  14. MySQLi count(*) always returns 1
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. Use one bind_param() with variable number of input vars
  17. Using Mysqli bind_param with date and time columns?
  18. PHP UPDATE prepared statement
  19. SELECT * FROM in MySQLi
  20. Mysqli fetch_assoc vs fetch_array
  21. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  22. Is mysqli extension enabled in this php configuration?
  23. php warning: mysqli_close() expects parameter 1 to be mysqli
  24. Is mysqli_real_escape_string safe?
  25. Getting error mysqli::real_connect(): (HY000/2002): No such file or directory when I try to access my project on live server [duplicate]
  26. Get number of rows matched by UPDATE query with PHP mysqli
  27. How to use mysqli_query() in PHP?
  28. mysqli_fetch_array returning only one result
  29. PHP: mysql v mysqli v pdo [closed]
  30. How do I ensure I caught all errors from MySQLi::multi_query?

Leave a Comment