Zend Framework output ready prepared statement

Question

How to output sql statement right before it's launched?

To check all placed data inside prepared statement.

Answer 1

Zend_Db doesn't have a mechanism itself to output the sql statements that it generates. What you can do is modify the public method "query" in Zend/Db/Adapter/Abstract.php(line 445 in 1.10.6) to output the $sql local variable. The query method is called by both the update and insert methods.