Where and or_where

marneu · Oct 2025

I need a clause with a “where” and an “or_where” condition together in GC: 2.0.2 CE:
WHERE x=a AND (y=b OR y=c)

How do I have to code this together:
$crud->where('x', a);
and ???

marneu · Oct 2025

In deed, I’m looking for a WHERE x=a AND y IN(b, c)
Can someone point me to the direction please?

johnny · Oct 2025

I hope this helps:

$crud->where([
    'x' => 'a',
    'y' => ['b', 'c']
]);

Topic	Views	Activity
How can I trim search fields in datagrid before the search starts? Grocery CRUD Community Edition	2	479	May 9
At least in v1.x: primary key not encoded in read / action URLs Grocery CRUD Community Edition	0	445	May 3
Grocery crud 1.6+ stable export filtered data Grocery CRUD Community Edition	0	308	Aug 3
[RESOLVED] Error in “validate.php” in the “_get_language_mapping()” function Uncategorized	10	1.9k	Mar 31
[RESOLVED] Updated Grocery CRUD Enterprise from 3.2.4 to 3.2.7 Uncategorized	1	842	Jan 14

post by marneu on Oct 14, 2025