convert Zend Db Select query to sql query

Question

Are there any ways to convert Zend db Select or Zend DB query to SQL query before querying the database? Any other workarounds?

As I want to build a more complex SQL query that Zend DB cannot handle, without modifying my current Zend db code structure.

You are going to handcode an SQL query ? I am not sure how you can do that without changing or removing the Zend_Db_Select specific code — Amit Dugar
– Amit Dugar, Commented Sep 2, 2012 at 17:24

Nandakumar V · Accepted Answer · 2012-09-11 14:48:11Z

6

You can convert a Zend db Select object to string by $select->__toString()

answered Sep 11, 2012 at 14:48

Nandakumar V

4,7255 gold badges33 silver badges50 bronze badges

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

Comments

kasztelan · Accepted Answer · 2012-09-01 01:44:24Z

3

You can always echo $select which will return string with plain SQL query.

answered Sep 1, 2012 at 1:44

kasztelan

1,7714 gold badges17 silver badges24 bronze badges

edi9999 · Accepted Answer · 2014-10-21 08:12:47Z

3

For a Zend\Db\Sql\Select object (In Zend 2.2),

$select->getSqlString(); worked for me.

answered Oct 21, 2014 at 8:12

edi9999

20.7k15 gold badges98 silver badges136 bronze badges

Sajjad Ashraf · Accepted Answer · 2021-06-12 15:51:50Z

1

For Zend Framework 1.* you can use assemble

echo $select->assemble();

answered Jun 12, 2021 at 15:51

Sajjad Ashraf

3,8741 gold badge37 silver badges36 bronze badges