Retrieve (or simulate) full query from PDO prepared statement
pdo, php, prepared-statement
Solution
I believe this is mentioned in the original question that was reference in this one. However there is actually supposed to be a method for retrieving this data.
`PDOStatement::debugDumpParams`
However it isn't currently working as documented. There is a bug report and patch submitted for it here http://bugs.php.net/bug.php?id=52384 in case anyone is interested in voting on it. Until it's fixed it seems like you are left to use query logging or setting a custom statement class using the PDO::ATTR_STATEMENT_CLASS attribute.
Problem
I stumbled upon this question from two years ago. Is there a way to get the raw SQL string executed when calling PDOStatement::execute() on a prepared statement? For debugging purposes this would be extremely useful. The winning answer states that [...] You can also get what you want if you set the PDO attribute PDO::ATTR_EMULATE_PREPARES. In this mode, PDO interpolate parameters into the SQL query and sends the whole query when you execute(). But it doesn't mention how to get the resulting query string. I know it's a bad idea performance wise but that doesn't bother me in debug mode. Does anybody know how to do this? PS If there is some way I could have reopened / drawn attention to the original two year old topic instead of opening a new one, please let me know.