PHP Laravel Variable Scope in functions

Question

I have the following code in a Laravel controller, but the given parameter variable $idea is undefined in the 'whereIn' function. How can I access $idea there? Thank you!

public static function getIdea($idea = null) {
    if ($idea != "") {
        return DB::table('test')->select('foo')
            ->whereIn('bar', function($query)
              {
                  $query->select('foobar')
                        ->from('bar2')
                        ->where('foo2', '=', $idea)
                        ->get();
              })
            ->get();
    }
}

Moak · Accepted Answer · 2017-07-06 13:19:58Z

3

Use the use keyword! See Example #3 Inheriting variables from the parent scope on anonymous functions

public static function getIdea($idea = null) {
    if ($idea != "") {
        return DB::table('test')->select('foo')
            ->whereIn('bar', function($query) use ($idea)
              {
                  $query->select('foobar')
                        ->from('bar2')
                        ->where('foo2', '=', $idea)
                        ->get();
              })
            ->get();
    }
}

answered Jul 6, 2017 at 13:19

Moak

12.9k27 gold badges117 silver badges168 bronze badges

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

Collectives™ on Stack Overflow

PHP Laravel Variable Scope in functions

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