Laravel where clause not returning expected result

Question

While making a request to my Laravel database something goes wrong. I'm trying to get different recipes on user input but Postman is returning 'No recipes found'. My Laravel controller code:

public function search(Request $request) {
    $fields = $request->validate([
        'search' => 'required|string'
    ]);

    // return response($request);

    $recipes = Recipe::where('title', 'LIKE', '%'.$request.'%')->get();

    if (count($recipes) > 0 ) {
        return response($recipes);
    } else {
        return response('No recipes found');
    }
}

if I return the response it returns "search": "maken" with the request http://127.0.0.1:8000/api/search?search=maken. When I however hardcode the where clause to $recipes = Recipe::where('title', 'LIKE', 'maken')->get(); it returns some recipes and the search function works. Now I'm not sure whether the error is in my Postman request or in my search function in Laravel. Any help would be greatly appreciated!

matiaslauriti · Accepted Answer · 2021-07-03 21:27:07Z

2

You have to use $request->INPUT_NAME or $request->input('name') to get the value, so your code should be:

$recipes = Recipe::where('title', 'LIKE', '%'.$request->search.'%')->get();

answered Jul 3, 2021 at 21:27

matiaslauriti

8,2004 gold badges37 silver badges48 bronze badges

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

Comments

Sarwar Ahmed · Accepted Answer · 2021-07-04 05:23:10Z

1

Try this way

$recipes = Recipe::where('title', 'like', '%' . request('search') . '%')->get();

if ($recipes->count() > 0 ) {
    return response($recipes);
} else {
    return response('No recipes found');
}

answered Jul 4, 2021 at 5:23

Sarwar Ahmed

1,0442 gold badges10 silver badges16 bronze badges

Collectives™ on Stack Overflow

Laravel where clause not returning expected result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related