Variable not recognized in function, laravel

Question

This is my code:

public function userprofile($id)
{
    $users = DB::table('users')->where('username', $id)->get();

    $myposts = DB::table('posts')->where('maker', $id)->get();

    $user_id = $id;

    $postsvotes = DB::table('posts')
    ->join('upvotes', function($join)
    {
        $join->on('post_id', '=', 'upvotes.post_id')
             ->where('upvotes.user_id', $user_id);
    })
    ->get();

    return View::make('users.profile')->with('users', $users)->with('myposts', $myposts)->with('myvotes', $postsvotes);
}

I'm working with a join and as you can see in the where I have this variable $user_id and this should be the $id you get as an argument from the function userprofile($id) but I can't seem to get that argument into that where clause.

Regards,

Mikk · Accepted Answer · 2014-11-02 18:13:47Z

2

Go ahead and try (notice the use ($user_id) part):

->join('upvotes', function($join) use ($user_id)
{
    $join->on('post_id', '=', 'upvotes.post_id')
         ->where('upvotes.user_id', $user_id);
})

This probably is a variable scoping problem. See Example #3 Closures and scoping from http://php.net/manual/en/functions.anonymous.php

answered Nov 2, 2014 at 18:13

Mikk

2,2293 gold badges32 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Variable not recognized in function, laravel

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