zend-framework output Zend_Db_Table's select() statement generated query

Question

i want to output the query generated by Zend_Db_Table's select() statement for testing porposes but i dont know how.

David Snabel-Caunt · Accepted Answer · 2009-07-16 15:11:12Z

15

It's actually really easy. The select object implements a toString method.

$select = $table->select()->....
echo $select; //prints SQL

Or

$sql = $select->__toString();

answered Jul 16, 2009 at 15:11

58.4k13 gold badges118 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fancyPants · Accepted Answer · 2012-12-11 13:46:02Z

2

or cast it to string and then use it:

(string)$table->select();

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

answered Dec 11, 2012 at 13:26

obotezat

1,13316 silver badges23 bronze badges