Laravel query builder not using variable from get method

Question

I have this function in one of my controller.

public function tourList($country, $category)
{
    $tour = Tour::whereHas('country', function($q) {
                    $q->where('name','=', $country);
                })
                ->whereHas('category', function($r) {
                    $r->where('name','=', $category);
                })
                ->get();

    return view('tour-list.blade.php')->withTour('$tour');
}

Though have passed two variables from get method. But i am getting error of

Undefined variable: country

Route::get('tour/{country}/{categpry}', ['as' => 'tour.list', 'uses' => 'PublicController@tourList']); — Zachary Dale
– Zachary Dale, Commented Nov 26, 2016 at 16:18
Change '$tour' to $tour as we have to pass variable in withTour. — PassionInfinite
– PassionInfinite, Commented Nov 26, 2016 at 16:21

Amit Gupta · Accepted Answer · 2016-11-26 16:21:55Z

3

You are missing use in anonymous function so your query willl be as:

$tour = Tour::whereHas('country', function($q) use($country) {
                $q->where('name','=', $country);
            })
            ->whereHas('category', function($r) use($category) {
                $r->where('name','=', $category);
            })
            ->get();

Docs

answered Nov 26, 2016 at 16:21

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Laravel query builder not using variable from get method

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