Using variable in laravel 4.1 Query Builder

Question

How can use variable in laravel query builder. Here is my code.

$role = 1;
$user = DB::table('users')
                    ->join('assigned_roles', function($join)
                    {
                        $join->on('users.id', '=', 'assigned_roles.user_id')
                             ->where('assigned_roles.role_id', '=', $role );
                    })
                    ->get();

But it return Undefined variable: role. How can I solve this problem. Help me plz.

Maerlyn · Accepted Answer · 2014-01-16 10:55:30Z

12

You need to import variables from the local scope to the anonymous function's scope:

function ($join) use ($role) {}

See the example in the docs.

answered Jan 16, 2014 at 10:55

Maerlyn

34.2k18 gold badges99 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

Using variable in laravel 4.1 Query Builder

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