Undefined variable: request in Laravel query

I want to create a nested parameter grouping in my query where the value of one of my nested where is gotten from the form.

if($request->view != '') {
    $query->where(function ($query) {
    $query->where('type', $request->view)
            ->orWhere('type', 2);
    })->get();
}

Right now I'm getting Undefined variable: request. How do I get the value of $request->view in the function?

tisuchi

6 years ago

Best Answer

Level 70

@ivanleoncz69

Try this-

if($request->view != '') {
    $query->where(function ($query) use($request) { // <-- without use, your 
      $query->where('type', $request->view)         //     anonymous function
            ->orWhere('type', 2);                   //     cannot access $request
    })->get();
}

9 likes

ivanleoncz69

6 years ago

Level 1

@tisuchi Working man. Thanks a lot.

Please or to participate in this conversation.