Zend Framework 2: Use SQL Select with multiple "OR" in Loop

Question

Iam new to Zend Framework 2, and have some trouble to create an WHERE SQL Statement with multiple "OR" clauses.

$ids = array("A1","A2","A3","A4","A5","A6","A7");

foreach ($ids as $id) {
    $select->where->equalTo('id', $id);      
    // how to add OR for remaining ids
}

Is there any simple solution for this case?

Mubo · Accepted Answer · 2014-03-07 13:57:29Z

3

This has worked for me about a month ago. in version 2.2

$ids = array("A1","A2","A3","A4","A5","A6","A7");

$select->where->in('id', $ids);

answered Mar 7, 2014 at 13:57

Mubo

1,0808 silver badges16 bronze badges

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

1 Comment

Mubo Over a year ago

Zend is beautiful but tricky and alot of work to know all work arounds

segarci · Accepted Answer · 2014-03-07 13:45:58Z

3

You can use the SQL IN operator:

$select->where('id IN (?)', $ids);

answered Mar 7, 2014 at 13:45

segarci

7351 gold badge11 silver badges19 bronze badges

1 Comment

Tim Fountain Over a year ago

FYI this was the ZF1 syntax.

Collectives™ on Stack Overflow

Zend Framework 2: Use SQL Select with multiple "OR" in Loop

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related