Zend DB - where And Or Query

Question

Could someone please tell me the correct syntax for a Zend DB query to represent the last line (the and (xxx or xxx)

...
where
    id = 1241487470
and (contract=0 or is_work IS NOT NULL)
...

I'm stuck at this:

->where('id = ?', 1241487470)
->where(...)

score 3 · Accepted Answer · answered Jul 05 '12 at 04:19

3

This seemed logical and worked. So Yay.

->where('id = ?', 1241487470)
->where('contract= ? or is_work IS NOT NULL)

answered Jul 05 '12 at 04:19

Jarrod

This is the correct way of handling this situation. However did you mean Zend DB rather than Form? – John C Jul 05 '12 at 04:50
Yes I did :) must have been a long day. I've corrected it. Cheers. – Jarrod Jul 06 '12 at 06:57

score 2 · Answer 2 · answered Jul 03 '14 at 09:22

2

This seems works too and preserve zend db escapement

->where('id = ?', 1241487470);
->where('(contract = ?', 0);
->orWhere('is_work IS NOT NULL)');

answered Jul 03 '14 at 09:22

Vulman

2 Answers2