PDO queryString with binded data

问题:

If I have a prepared statement like SELECT * FROM users WHERE userid = :userid, i can read this SQL statement via PDOStatement::$queryString. For logging i want to have the string, which is executed, e.g. ... WHERE userid = 42. How do i get this string?

回答1:

PDOStatement->debugDumpParams is what you want. You may need to use output buffering though as the results are echoed out.