Laravel 'whereIn' every element in array

Question

I want to filter the data with array, but return null if one of element in array is false.

for example my existing cars color is ['black', 'white', 'red']

I already try with whereIn but in the docs say given containing value within the given array thats why it's still return the data.

In my controller:

// the request param is /cars?color=black,white,yellow
$cars = Car::latest()->filter(request(['color', ...etc]))->get();
// $cars should empty

// the request param is /cars?color=black,white,red
$cars = Car::latest()->filter(request(['color', ...etc]))->get();
// $cars shouldn't empty

In my model:

public function colors() {
    return $this->hasMany(Color::class);
}

public function scopeFilter($query, array $filters) {
    $query->when($filters['color'] ?? false, function ($query, $colors) {
        $colors = explode(',', $color);
        $query->whereHas('colors', function ($q) use ($color) {
            $q->whereIn('color_name', $colors);
        });
    });
}

please update your code also so that we can help ;)

JEJ
– JEJ

2022-08-04 06:02:14 +00:00
Commented Aug 4, 2022 at 6:02 — JEJ
– JEJ, Commented Aug 4, 2022 at 6:02
What have you tried? edit and post your code

STA
– STA

2022-08-04 06:08:24 +00:00
Commented Aug 4, 2022 at 6:08 — STA
– STA, Commented Aug 4, 2022 at 6:08

Yinci · Accepted Answer · 2022-08-04 07:15:13Z

1

It sounds like you want a where condition for each selected colour:

$cars = Car::whereHas('colors', function($q) use ($filter) {
    foreach ($filter as $color) {
        $q->where('color_name', $color);
    }
})->get();

answered Aug 4, 2022 at 7:15

Yinci

2,5901 gold badge6 silver badges17 bronze badges

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

3 Comments

Kevin Y Over a year ago

Yeah, this looks right.

Tuti Herwiyati Over a year ago

thanks for answer it, but it works when the filter array has 1 element, if more than element doesn't work

Yinci Over a year ago

@TutiHerwiyati Because? What is the expected behaviour if there are no colours filtered? Seems like then you'd just get all cars that have at least one colour?

Here we go again · Accepted Answer · 2022-08-04 11:43:40Z

0

Laravel has the function whereIn Documentation here

$filter = ['black', 'white', 'yellow'];
$cars = Car::whereIn('color_name', $filter)->get();

answered Aug 4, 2022 at 11:43

Here we go again

6161 gold badge7 silver badges14 bronze badges

Collectives™ on Stack Overflow

Laravel 'whereIn' every element in array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related