How to pass a variable into an internal function in Laravel 5.3?

Question

I am trying to pass the locale data to the eloquent query but it cannot get it. $locale value is taken from the URI.

class MyController extends Controller { public function index($locale = 'en') { $news = News::join('categories', 'categories.id', '=', 'news.catid') ->select('news.*', 'categories.category') ->where([['news.published', '1'], ['news.deleted', '0']]) ->where(function ($query) { $query->where('news.language', $locale) //$locale is not recognized naturally ->orWhere('news.language', 'all'); }) ->orderBy('news.published_at', 'desc') ->take(4) ->get(); . . . } }

How can I pass $locale value into the subquery?

function ($query) use ($locale) {

Clive
– Clive

2017-01-09 21:51:03 +00:00
Commented Jan 9, 2017 at 21:51 — Clive
– Clive, Commented Jan 9, 2017 at 21:51

Jeff Lambert · Accepted Answer · 2017-01-09 21:50:51Z

There is the use construct that you can use to create a closure around the variable:

->where(function ($query) use($locale) { $query->where('news.language', $locale) ->orWhere('news.language', 'all'); })

See Example #3 in the manual, "Inheriting variables from the parent scope".

Very good. Actually, I did not know about naming my problem in order to make a Google search. Thanks.

Collectives™ on Stack Overflow

How to pass a variable into an internal function in Laravel 5.3?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related