how to write sql statement in zend framework?

Question

How to write this sql statement

SELECT * FROM `astrology` where ((commu_time_from  >= '10:30' and commu_time_from <= '10:40') or (commu_time_to  >= '10:30' and commu_time_to <= '10:40'))

in zend framework ?

This framework.zend.com/manual/en/zend.db.select.html didn't helped you? — KingCrunch
– KingCrunch, Commented Jul 7, 2011 at 12:41

Hubidubi · Accepted Answer · 2011-07-07 12:53:13Z

1

I think, this works:

 $model=new Default_Model_Astronomy();
 $select=$model->getMapper()->getDbTable()->getAdapter()->select();
 $select=$select->from('astrology')
                ->where("commu_time_from  >= '10:30' and commu_time_from <= '10:40'")
                ->orWhere("commu_time_to  >= '10:30' and commu_time_to <= '10:40'");

answered Jul 7, 2011 at 12:53

Hubidubi

8805 gold badges18 silver badges34 bronze badges

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

Comments

JellyBelly · Accepted Answer · 2011-07-07 12:47:09Z

1

so:

        $db = Zend_Db::factory('Pdo_Mysql', array(
                                             'host' => '127.0.0.1',
                                             'username' => 'webuser',
                                             'password' => 'xxxxxxxx',
                                             'dbname' => 'test'
                                        ));

    $select = $db->select()
            ->from("...specify table and columns ... ")
            ->where(" ...specify search criteria ... ")
            ->order(" ...specify sorting criteria ... ");

in your specific case:

        $select = $db->select()
            ->from("astrology")
            ->where("commu_time_from  >= '10:30' AND commu_time_from <= '10:40'")
            ->orWhere("commu_time_to  >= '10:30' AND commu_time_to <= '10:40'");

answered Jul 7, 2011 at 12:47

JellyBelly

2,4312 gold badges21 silver badges42 bronze badges

1 Comment

David Snabel-Caunt Over a year ago

I think the OP is struggling with the exact parameters to the from and where methods.

burntblark · Accepted Answer · 2011-07-07 12:57:15Z

0

Using the select object from an instance of a Zend_Db_Table ($table in my case), Try this:

$table->select()->where('(commu_time_from >= "10:30"')
                ->where('commu_time_from <= "10:40")')
                ->orWhere('(commu_time_to >= "10:30")')
                ->where('commu_time_to <= "10:40")')

Note that the $table variable is the instance of Zend_Db_Table with the $_name property set to "astrology"

answered Jul 7, 2011 at 12:57

burntblark

1,7101 gold badge15 silver badges25 bronze badges

Collectives™ on Stack Overflow

how to write sql statement in zend framework?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related