How to add GREATER_THAN / LESS_THAN operator to DB query in Zend\Db\Sql?

Question

I need to add special operators to my query. Query:

SELECT "contests".*
FROM "contests" WHERE "status" = '-1' 
AND "level1" = '1' AND "level2" = '1' AND "level3" = '1' AND "level10" = '1' 
AND DATE(`contests`.`start`) >= '2012-03-17' AND DATE(`contests`.`stop`) <= '2013-12-20'

In Zend Framework 2:

$from = '2012-03-17';
$to = '2013-12-20';
  $sql = new Sql($this->adapter);
  $select = $sql->select('contests')
     ->where($where, $combination = new Predicate\Operator($from, Predicate\Operator::OPERATOR_GREATER_THAN_OR_EQUAL_TO, $to));

But this doesn't work.

Mubo · Accepted Answer · 2013-12-13 20:19:10Z

5

What about if you write your where clause like this:-

$select->where->equalTo('status', '-1'); 
$select->where->equalTo('level1', '1');

and etc

$select->where->greaterThanOrEqualTo('start', '2012-03-17');
$select->where->greaterThanOrEqualTo('stop', '2013-12-20');

answered Dec 13, 2013 at 20:19

Mubo

1,0808 silver badges16 bronze badges

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

1 Comment

Prifulnath Over a year ago

is there a lessThanOrEqualTo function ?

Ender Akgül · Accepted Answer · 2015-03-15 18:13:01Z

1

I am using table gateway. It is more clear to use. you can use where clause.

public function getGelecek()
{
    $select = $this->tableGateway->getSql()->select();
    $select->where(array('active' => '1'));
    $select->where->greaterThan('tarih', '123');
    $resultset = $this->tableGateway->selectWith($select);
    return $resultset;
}

answered Mar 15, 2015 at 18:13

Ender Akgül

621 silver badge2 bronze badges

Collectives™ on Stack Overflow

How to add GREATER_THAN / LESS_THAN operator to DB query in Zend\Db\Sql?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related