Is it possible to get a query string from a PDO object with bound parameters without executing it first? I have code similar to the following (where $dbc is the PDO object):
$query = 'SELECT * FROM users WHERE username = ?';
$result = $dbc->prepare($query);
Currently, this will echo out a SQL statement like: “SELECT * FROM users WHERE username = ?”. However, I would like to have the bound parameter included so that it looks like: ‘SELECT * FROM users WHERE username=”bob””. Is there a way to do that without executing it or replacing the question marks with the parameters through something like preg_replace?