Retrieve (or simulate) full query from PDO prepared statement

by

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.

More Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. PHP – Using PDO with IN clause array
  3. PDO Prepared Inserts multiple rows in single query
  4. PDO prepared statement – what are colons in parameter names used for?
  5. pdo prepared statements with wildcards
  6. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  7. Get last insert id after a prepared insert with PDO
  8. How do I use pdo’s prepared statement for order by and limit clauses?
  9. Insert multiple rows with PDO prepared statements
  10. Replacing mysql_* functions with PDO and prepared statements
  11. PHP PDO::bindParam() data types.. how does it work?
  12. Binding params for PDO statement inside a loop
  13. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  14. Calling stored procedure with Out parameter using PDO
  15. When *not* to use prepared statements?
  16. Which tokens can be parameterized in PDO prepared statements?
  17. PDO error: SQLSTATE[HY000]: General error: 2031
  18. Use of PDO in classes [duplicate]
  19. Error while using PDO prepared statements and LIMIT in query [duplicate]
  20. Why does this PDO statement silently fail?
  21. Cleansing User Passwords
  22. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  23. Why is using a mysql prepared statement more secure than using the common escape functions?
  24. How can I Use Prepared Statements in CodeIgniter
  25. Why is constructing PDO connection slow?
  26. mySQLi prepared statement unable to get_result()
  27. how to properly use while loop in PDO fetchAll
  28. PDO MySQL: Insert multiple rows in one query
  29. PHP 7 RC3: How to install missing MySQL PDO
  30. I’m getting this error code: Invalid argument supplied for foreach() [duplicate]

Leave a Comment