OR, AND with Where by using Zend\Db\Sql\Sql

Question

I'm trying to change this normal SQL statment, where I use "where" with or, to a Zend\Db\Sql\Sql Object.

However I cant figure out how to write the "where" clause.

this is the code before:

 SELECT column 
 FROM Table
 WHERE value = num OR value2 = num

and this is how i'm trying to make it look like:

 $sql = new Sql($adapter);
 $select = $sql->select();
 $select->from(Table);
 $select->where(?);

What class are you using?

hoangvu68
– hoangvu68

2014-04-17 08:48:44 +00:00
Commented Apr 17, 2014 at 8:48 — hoangvu68
– hoangvu68, Commented Apr 17, 2014 at 8:48
it is Zend\Db\Sql\Sql

Leen Rihawi
– Leen Rihawi

2014-04-17 08:50:12 +00:00
Commented Apr 17, 2014 at 8:50 — Leen Rihawi
– Leen Rihawi, Commented Apr 17, 2014 at 8:50
$sql->where(array('id = ?' => $id)); would work, too.

Sam
– Sam

2014-04-17 10:07:24 +00:00
Commented Apr 17, 2014 at 10:07 — Sam
– Sam, Commented Apr 17, 2014 at 10:07

hoangvu68 · Accepted Answer · 2014-04-17 10:10:49Z

3

In simple case, only have AND. You can use

$select ->where(array('cloumn1'=>'A', 'column2'=>'B'));

In complex case:

$where = new \Zend\Db\Sql\Where();

$where
    ->nest()
    ->equalTo('table1.column2', 2)
    ->or
    ->equalTo('table1.column3', 3)
    ->unnest()
    ->and
    ->equalTo('table1.column1', 1);
$select->where($where)

edited Apr 17, 2014 at 10:10

answered Apr 17, 2014 at 8:56

hoangvu68

8632 gold badges13 silver badges29 bronze badges

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

1 Comment

Sam Over a year ago

Could you shift your answer? Moving the simple case solution on top and the extended version for complex statements to the bottom? For reference purposes? :)

Collectives™ on Stack Overflow

OR, AND with Where by using Zend\Db\Sql\Sql

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