how to create a Zend_Db_Table_Select through a string query php

Question

I have been taking a look, for if there any way to create a Zend_Db_Table_Select or Zend_Db_Select instance with a literal sql query. I mean, I've got a complex query and I want through this query create an object of that one. I have been reading the docs for this classes and I didn't find anything. I guess that this is not possible.

Do you know something about it?

Thank you very much.

liyakat · Accepted Answer · 2013-04-25 12:57:18Z

1

I think your best bet would be to write this in your model:

public function customQuery ($table, $id) {
    return $this
        ->getDefaultAdapter()
        ->query("SELECT * FROM ? WHERE id = ?",
            array($table,$id)
        )
        ->fetchAll()
    ;
}

and also one more link would be very useful to you

answered Apr 25, 2013 at 12:57

liyakat

11.9k2 gold badges42 silver badges47 bronze badges

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

1 Comment

jortsc Over a year ago

Thank you very much, interesting way. I'm going to try it

Collectives™ on Stack Overflow

how to create a Zend_Db_Table_Select through a string query php

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