laravel query return Undefined

Question

I do a search with 3 inputs and then input can be empty

i get variables from the front-end

$addressSearch = $request->json()->get('addressSearch');
$typeSearch    = $request->json()->get('typeSearch');
$statusSearch  = $request->json()->get('statusSearch');

I do this search use the function inside the query

$property = Property::where('id', '1')
                      ->Where(function($query)
                       {
                           $query->Where('type',typeSearch)
                                   ->orWhere('status',$statusSearch)
                                   ->orWhere('street','LIKE',"% $addressSearch}%");
                        })
                        ->get();

and I get this error:

message: "Undefined property: App\Http\Controllers\PropertyController::$typeSearch

the variable receives the value normally

typeSearch in line 4 should have $ sign, also check that which line error refer to — Ali Akbar Azizi
– Ali Akbar Azizi, Commented Apr 3, 2020 at 16:56

Ohgodwhy · Accepted Answer · 2020-04-03 17:02:20Z

1

You have type errors, and you're not passing any variables to the closure function, so they don't exist anyway:

$property = Property::where('id', '1')
                     ->where(function($query) use ($typeSearch, $statusSearch, $addressSearch)
                     {
                          $query->where('type',$typeSearch)
                                ->orWhere('status',$statusSearch)
                                ->orWhere('street','LIKE',"%{$addressSearch}%");
                     })->get();

answered Apr 3, 2020 at 17:02

Ohgodwhy

50.9k11 gold badges86 silver badges114 bronze badges

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

Collectives™ on Stack Overflow

laravel query return Undefined

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