Laravel Eloquent Query -> Undefined Variable

Question

Attached is a screenshot of the error I am facing. I have the log show the value of the $team variable. What am I doing wrong?

It should be function($query) use ($team) (string: 18) to import this variable into closure from parent scope — Alexey Chuhrov
– Alexey Chuhrov, Commented Jul 7, 2018 at 10:27
Thanks Dan. You were the first to answer, but since it is a comment, I cant upvote you. — Vishnoo Rath
– Vishnoo Rath, Commented Jul 7, 2018 at 10:42
You might also find using a good IDE like PhpStorm help debug before you test. If you use PhpStorm for example you'd have seen this mistake. — omitobi
– omitobi, Commented Jul 7, 2018 at 10:48

vadim savin · Accepted Answer · 2018-07-07 10:30:39Z

10

You don't have access to parents variables from a closure, you need to explicitly send variables to the closure with use keyword

function($query) use ($team)

answered Jul 7, 2018 at 10:30

vadim savin

2592 silver badges8 bronze badges

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

Comments

Davit Zeynalyan · Accepted Answer · 2018-07-07 10:31:58Z

4

Use forget to use $team variable inside your closure. It must be function($query) use ($team)

$data = User::whereHas('roles' => function($query) use ($team) {
    $query->where('role_code', '=', $team)
})->get();

answered Jul 7, 2018 at 10:31

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges