How to use whereIn to check multiple columns?

Question

I have this query:

$query->whereHas($key,function($q) use($option){
            $q->whereIn('district', $option);
            $q->whereIn('region', $option);
          });

But its not working. I want to check district and region and i get an array from $option

Answer 1

For AND use:

$query->whereHas($key,function($q) use($option){
        $q->whereIn('district', $option)
          ->whereIn('region', $option);
    });

For OR:

$query->whereHas($key,function($q) use($option){
        $q->whereIn('district', $option)
          ->orWhereIn('region', $option);
    });