How to print exact sql query in zend framework ?

Select objects have a __toString() method in Zend Framework.

From the Zend Framework manual:

$select = $db->select()             ->from('products');$sql = $select->__toString();echo "$sql\n";// The output is the string://   SELECT * FROM "products"

An alternative solution would be to use the Zend_Db_Profiler.i.e.

$db->getProfiler()->setEnabled(true);// your code$this->update($up_value,'customer_id ='.$userid.' and address_id <> '.$data['address_Id']); Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQuery());Zend_Debug::dump($db->getProfiler()->getLastQueryProfile()->getQueryParams());$db->getProfiler()->setEnabled(false);

http://framework.zend.com/manual/en/zend.db.select.html

from >= 2.1.4

echo $select->getSqlString()

I have traversed hundred of pages, googled a lot but i have not found any exact solution.Finally this worked for me. Irrespective where you are in either controller or model. This code worked for me every where. Just use this

//Before executing your query$db = Zend_Db_Table_Abstract::getDefaultAdapter();$db->getProfiler()->setEnabled(true);$profiler = $db->getProfiler();// Execute your any of database query here like select, update, insert//The code below must be after query execution$query  = $profiler->getLastQueryProfile();$params = $query->getQueryParams();$querystr  = $query->getQuery();foreach ($params as $par) {    $querystr = preg_replace('/\\?/', "'" . $par . "'", $querystr, 1);}echo $querystr;

Finally this thing worked for me.