How to echo a MySQLi prepared statement?

by

I don’t think you can – at least not in the way that you were hoping for. You would either have to build the query string yourself and execute it (ie without using a statement), or seek out or create a wrapper that supports that functionality. The one I use is Zend_Db, and this is how I would do it:

$id = 5;
$baz = 'shazam';
$select = $db->select()->from('bar','foo')
                       ->where('id = ?', $id)
                       ->where('baz = ?', $baz); // Zend_Db_Select will properly quote stuff for you
print_r($select->__toString()); // prints SELECT `bar`.`foo` FROM `bar` WHERE (id = 5) AND (baz = 'shazam')

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. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  7. Example of how to use bind_result vs get_result
  8. mysqli::query(): Couldn’t fetch mysqli
  9. get array of rows with mysqli result
  10. How to start and end transaction in mysqli?
  11. How to install MySQLi on MacOS
  12. How do I iterate over the results in a MySQLi result set?
  13. PHP MySQLI Prevent SQL Injection [duplicate]
  14. The mysqli extension is missing. Please check your PHP configuration
  15. How to test if a MySQL query was successful in modifying database table data?
  16. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  17. PHP Commands Out of Sync error
  18. Warning: mysqli_error() expects exactly 1 parameter, 0 given error
  19. Executing mysqli_query inside a function
  20. using nulls in a mysqli prepared statement
  21. Can’t return a result set in the given context
  22. store_result() and get_result() in mysql returns false
  23. Checking if mysqli_query returned any values?
  24. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  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. Using Prepared Statement, how I return the id of the inserted row?
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. When should I close a database connection in PHP?

Leave a Comment