How can I combine both of these conditions? in laravel

Question

I'am new with laravel. How can I combine both of these conditions?

public function student($classroom_id)
    {
        $members = Classroom::findOrFail($classroom_id,)->members->load('role');
        $members = User::where([
            ['role_id', 2]
        ])->get();

        return response()->json($members);
    }

Can you show your relationship in the model as well as DB structure? and what are you trying to access with combine? — Dilip Hirapara, Mar 22 '20 at 06:27
Did you want to get a Classroom who have User that have `role_id` 2? — Adrian Edy Pratama, Mar 22 '20 at 07:02

Adrian Edy Pratama · Answer 1 · 2020-03-22T08:17:07.507

0

Try this:

public function student($classroom_id)
{
    $members = Classroom::whereHas('members.role', function ($query) {
        $query->where('id', '2');
    })->findOrFail($classroom_id)->members->load('role');

    return response()->json($members);

}

edited Mar 22 '20 at 08:17

answered Mar 22 '20 at 06:33

Adrian Edy Pratama

3,841
2
9
24

How can I combine both of these conditions? in laravel

1 Answers1