Zend Framework Between Query

Question

How can I write the following query in Zend Framework?

select * from hosted_plans where hp_id=15 and curdate() between discount_start_date and discount_end_date

In the query above the discount_start_date and discount_end_date columns are date fields in the table

Thanks in advance.

akond · Accepted Answer · 2012-03-14 10:25:03Z

4

$query = $database->select ()
    ->from ('hosted_plans')
    ->where ('hp_id = ?', 15)
    ->where ('curdate() between discount_start_date and discount_end_date');

$database being a Zend_Db_Adapter_Abstract descendant.

answered Mar 14, 2012 at 10:25

akond

16.1k4 gold badges37 silver badges58 bronze badges

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

Comments

Fernando_Jr · Accepted Answer · 2014-12-18 11:34:13Z

2

One possible form with Zend 2:

    $select = $this->tableGateway->getSql()->select();
    $select->where(array('hp_id' => 15, new \Zend\Db\Sql\Predicate\Expression('curdate() BETWEEN discount_start_date AND discount_end_date')));
    $resultSet = $this->tableGateway->selectWith($select);

edited Dec 18, 2014 at 11:34

answered Dec 18, 2014 at 11:28

Fernando_Jr

4305 silver badges10 bronze badges

Comments

vascowhite · Accepted Answer · 2012-03-14 11:39:09Z

1

Alternatively:-

$query = $database->select ()
    ->from('hosted_plans')
    ->where('hp_id = ?', 15)
    ->where('curdate() >= discount_start_date')
    ->where('curdate() <= discount_end_date');

Would also work.

answered Mar 14, 2012 at 11:39

vascowhite

18.5k9 gold badges64 silver badges79 bronze badges

Collectives™ on Stack Overflow

Zend Framework Between Query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related