Zend Framework Queries on Mysql

Question

I am working with zend framework and I am new to it. The Site which is built has lots of transactions to/from mysql and there are lots of errors. Is there any way to understand the queries which are made by Zend Framework? If i could see them , I could easily change correct them but unfortunatly I didnt find how to do that. Thanks!

Mr Coder · Accepted Answer · 2012-06-26 09:16:10Z

1

Queries in ZF are instance of Zend_Db_Select , simply

$query = Zend_Db_Table::getDefaultAdapter()->select()->from('user')->where('id = ?',1);

To see its sql representation simply do

echo $query ; 

or 

echo $query->__toString();

answered Jun 26, 2012 at 9:16

Mr Coder

8,1965 gold badges49 silver badges74 bronze badges

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

1 Comment

Abadis Over a year ago

There is another problem now.Imagine you have to get a log of your system to say later that who did what.

Collectives™ on Stack Overflow

Zend Framework Queries on Mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related