How to print exact sql query in zend framework ?

Question

I have the following piece of code which i taken from model,

    ...
                  $select = $this->_db->select()
                    ->from($this->_name)
                    ->where('shipping=?',$type)
                    ->where('customer_id=?',$userid);
                 echo  $select; exit; // which gives exact mysql query.
            .....

When i use update query in zend like ,

$up_value = array('billing'=> '0');
$this->update($up_value,'customer_id ='.$userid.' and address_id <> '.$data['address_Id']);      

Here i want to know the exact mysql query. Is there any possible way to print the mysql query in zend ? kindly advice

Answer 1

Use this:-

echo $select->query();

or

Zend_Debug::dump($select->query();

Answer 2

You can use Zend_Debug::Dump($select->assemble()); to get the SQL query.

Or you can enable Zend DB FirePHP profiler which will get you all queries in a neat format in Firebug (even UPDATE statements).

EDIT: Profiling with FirePHP also works also in FF6.0+ (not only in FF3.0 as suggested in link)

Answer 3

even shorter:

echo $select->__toString()."\n";

and more shorter:

echo  $select .""; die;

Answer 4

Now on Zend2:

$select->getSqlString();

Displaying the generated SQL from ZendDbSql object

Answer 5

you can print..

print_r($select->assemble());

Answer 6

Check out the Zend_Db_Profiler. This allows you to log any SQL statement as it is prepared and executed. It works for UPDATE statements as well as SELECT queries.