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, Sep 02 '12 at 17:24

score 6 · Answer 1 · answered Sep 11 '12 at 14:48

6

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

answered Sep 11 '12 at 14:48

Nandakumar V

score 3 · Answer 2 · answered Sep 01 '12 at 01:44

3

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

answered Sep 01 '12 at 01:44

kasztelan

score 3 · Answer 3 · answered Oct 21 '14 at 08:12

3

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

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

answered Oct 21 '14 at 08:12

edi9999

score 1 · Answer 4 · answered Jun 12 '21 at 15:51

1

For Zend Framework 1.* you can use assemble

echo $select->assemble();

answered Jun 12 '21 at 15:51

Sajjad Ashraf

4 Answers4