Laravel eloquent and query with two join tables criterias

Question

Here the situation.

I have a user table, a role table (different users can have the same role) and a post table (different users can be linked to a same post - multi authors post). I also have two join tables that link user and role and user and post. I have built all relationships (many-to-many).

But now I try to get all users that have a particular role ('id' = 2 for example) and have contributed to a particular post ('id' = 45 for example).

I can do it with one criteria :

$roles = App\Role::where('id', 2)->first();
foreach ($roles->users as $user) {

}

But I didn't find the solution with two criterias (role id and post id).

Tharaka Dilshan · Accepted Answer · 2019-08-11 07:49:53Z

3

You can use relationship existence to to achieve your goal. And the whereHas() function is for checking relationship existence.

Assuming that you have defined relationships on models

$roleId = 2;
$postId = 45;

$users = User::whereHas('role', function($query) use ($roleId) {
    $query->where('id', $roleId);
})
->whereHas('post', function ($query) use ($postId) {
    $query->where('id', $postId);
})
->get();

answered Aug 11, 2019 at 7:49

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

Laravel eloquent and query with two join tables criterias

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related