Or_where array

nico077

Hello Allan,

I have a little question.

Can I use a or_where with an array.

Example :

->where( function ($q) {
$q->or_where( 'column1', 'value1', '=' );
$q->or_where( 'column2', 'value2', '=' );
} )

--> It's work

But when i use:
->where( function ($q) {
$q->or_where( 'column1', array('value1','value2'), '=' );
} )

Best Regards,
Nicolas

nico077

I find this link :
https://datatables.net/forums/discussion/24880/where-in-clause-on-server-side

allan

Yes. See also the complex conditional part of the manual.

Allan

nico077

Thank you Allan,

Finally, i do it like this :

->where( function ($q) {
foreach ($array as $value){
$q->or_where( 'id1', $value, '=' );
}
} )
->where( function ($q) {
$q->and_where( 'id2', $value2, '=' );
} )