In PHP with PDO, how to check the final SQL parametrized query? [duplicate]

by

So I think I’ll finally answer my own question in order to have a full solution for the record. But have to thank Ben James and Kailash Badu which provided the clues for this.

Short Answer

As mentioned by Ben James: NO.

The full SQL query does not exist on the PHP side, because the query-with-tokens and the parameters are sent separately to the database.
Only on the database side the full query exists.

Even trying to create a function to replace tokens on the PHP side would not guarantee the replacement process is the same as the SQL one (tricky stuff like token-type, bindValue vs bindParam, …)

Workaround

This is where I elaborate on Kailash Badu’s answer.
By logging all SQL queries, we can see what is really run on the server.
With mySQL, this can be done by updating the my.cnf (or my.ini in my case with Wamp server), and adding a line like:

log=[REPLACE_BY_PATH]/[REPLACE_BY_FILE_NAME]

Just do not run this in production!!!

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to apply bindValue method in LIMIT clause?
  3. PDOException “could not find driver”
  4. Row count with PDO
  5. PDO get the last ID inserted
  6. How do I use password hashing with PDO to make my code more secure? [closed]
  7. Error when preparing a multiple insert query
  8. How to view query error in PDO PHP
  9. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  10. Insert/update helper function using PDO
  11. Resetting array pointer in PDO results
  12. PDO multiple queries
  13. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  14. Insert multiple rows with PDO prepared statements
  15. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  16. PDO::PARAM for type decimal?
  17. Update query with PDO and MySQL
  18. Is “SET CHARACTER SET utf8” necessary?
  19. Alternative for mysql_num_rows using PDO
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Set PDO to throw exceptions by default [duplicate]
  22. PDO: MySQL server has gone away
  23. How do detect that transaction has already been started?
  24. return one value from database with mysql php pdo
  25. Trying to access array offset on value of type bool
  26. return multiple response data in one response
  27. How to get a query error from prepare() in PDO PHP?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment