How to echo a MySQLi prepared statement

Question

In my current projects I always like to echo out a query string while coding, just to make sure that everything is correct, and to quickly debug my code. But how can I do this with a prepared MySQLi statement?

Example:

$id = 1;
$baz = 'something';

if ($stmt = $mysqli->prepare("SELECT foo FROM bar WHERE id=? AND baz=?")) {
  $stmt->bind_param('is',$id,$baz);
  // how to preview this prepared query before acutally executing it?
  // $stmt->execute();
}

Any help?

Answer 1

Hello @kartik,

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 , or seek out or create a wrapper that supports that functionality. The one I use:

$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')

Hope it helps!!