How to pass a variable to join?

Question

Laravel

Have a request

DB::table('users')
        ->join('contacts', function($join)
        {
            $join->on('users.id', '=', 'contacts.user_id')
                 ->where('contacts.user_id', '>', 5);
        })
        ->get();

I want to pass the value of a variable to the condition

$id = 5;
DB::table('users')
        ->join('contacts', function($join)
        {
            $join->on('users.id', '=', 'contacts.user_id')
                 ->where('contacts.user_id', '=', $id);
        })
        ->get();

But inside the anonymous function, the value of this variable is not visible. How to implement it?

Answer 1

Use use :

function($join) use ($id){
  $join->on('users.id', '=', 'contacts.user_id')
    ->where('contacts.user_id', '=', $id);
}