whereHas where multiple (must contain)

Just use has() instead of with(). Has() excepts your constraints too.

   $keys = array_keys($request->genres);

    $list = Movie::whereHas('genres', function ($query) use($keys) {
            $query->whereIn('id', $keys); // use whereIn
    })->limit(3)->get();

@InaniELHoussain that will select any movie that contains any of the keys, since genres is selected (it must contain all keys).

@jekinney The (with, limit) is just for debugging, other than getting the movies, it's not needed at al. I've tried the has function, but... To no avail, perhaps I'm not thinking correctly regarding it :P?

could you explain what you want to get?

I got a form with genres that you can select with checkboxes, it will give a array with genre id's on submit to the controller.

Those id's must be used to select movies (all of the id's must exist within the results of the movie -> genres).

In other words I select Adventure(id:1) and Action(id:2), it will select all movies that contains both genres (1 & 2)

@ilaurens thats what I wrote for you, the Movies that its genre's id belongs to the $keys array, have you tried it?

Yes, I tried it already, whereIn was also my first guess :P

The Keys as reference: array(2) { [0]=> int(6) [1]=> int(80) }

The first result will return: 6 | 21 | 76 | 10 | 15 | 13

You can see the '6' that is correct, but there is no '80'. Both must exist for it to be selected. I think whereIn detect whether id is inside the array, which is not good for my purpose (because all of it must be AND WHERE).

Thank you for your time btw, :)

@ilaurens now I got it now, what about this

$keys = array_keys($request->genres);

$list = Movie::whereHas('genres', function ($query) use($keys) {
foreach($keys as $key){
$query= $query>where('id', $key); 
}
        
})->limit(3)->get();

@InaniELHoussain Thank you, but that does not seem to work either ;(

Tried something like that already, but did not work before either, did test it though, just to be sure :)

I think where selects a single of many results, and when id is 2, it cannot also be 5 for example. ;(

got a feeling it's something easy, but perhaps I'm looking something over the head...

Oke, I found something, it seems like this does the trick, but I think there must be a better way to do this.

        $keys = array_keys($request->genres);

        $list = Movie::with('genres');

        foreach($keys as $k => $v) {
            $list->whereHas('genres', function ($query) use($v) {
                $query->where('id', $v);
            });
        }

dd($list->limit(3)->get()->toArray());

It kinda feel like this will give a lot of overhead, is this the best way? Any other & better ways will be appreciated :) Solution mark will go to the best.

@ilaurens did you ever get a better way to solve this? Having exactly the same problem

@hesesses You can also use whereHas()'s third and fourth parameter in combination with whereIn():

$keys = array_keys($request->genres);

$list = Movie::with('genres');

$list->whereHas('genres', function ($query) use ($keys) {
    $query->whereIn('id', $keys);
}, '=', count($keys));

dd($list->limit(3)->get()->toArray());

Thank you for suggesting but this doesnt help. Using whereIn is OR operator and this needs to be done with AND

I know this is an old post, but came across it while seeking a solution to a similar problem. Here is my solution.

->when(
	$request->filled('tags'), 
	fn($q) => array_reduce(
		$request->tags, 
		fn($carry, $tag_id) => $carry->whereHas('tags', fn($qu) => $qu->where('id', $tag_id)), 
		$q
	)
)