Doctrine – How to print out the real sql, not just the prepared statement?

by

Doctrine is not sending a “real SQL query” to the database server : it is actually using prepared statements, which means :

  • Sending the statement, for it to be prepared (this is what is returned by $query->getSql())
  • And, then, sending the parameters (returned by $query->getParameters())
  • and executing the prepared statements

This means there is never a “real” SQL query on the PHP side — so, Doctrine cannot display it.

More Related Contents:

  1. Doctrine2: Best way to handle many-to-many with extra columns in reference table
  2. Why doesn’t MySQL support millisecond / microsecond precision?
  3. Doctrine Query Language get Max/Latest Row Per Group
  4. PHP ORMs: Doctrine vs. Propel
  5. How can I use DATE() in Doctrine 2 DQL?
  6. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  7. regarding installation of php in windows
  8. save user images in MYSQL database by which method? [closed]
  9. How to apply bindValue method in LIMIT clause?
  10. Best way to INSERT many values in mysqli?
  11. php/mysql with multiple queries
  12. Notice: Array to string conversion in
  13. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  14. Find total number of results in mySQL query with offset+limit
  15. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  16. PDO multiple queries
  17. How to efficiently find the closest locations nearby a given location
  18. Turn database result into array
  19. How to set up entity (doctrine) for database view in Symfony 2
  20. Update query with PDO and MySQL
  21. (mysql, php) How to get auto_increment field value before inserting data?
  22. Category Hierarchy (PHP/MySQL)
  23. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  24. How to convert ISO8601 to Date format in php
  25. belongsToMany relationship in Laravel across multiple databases
  26. Algorithm for generating a random number
  27. return one value from database with mysql php pdo
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. MySQL & PHP Parameter 1 as Resource
  30. How to check if a value already exists to avoid duplicates?

Leave a Comment