How to get list of data with where condition in Laravel 5

Question

I want to get REST url to retrieve data where name="hello" and category="main"

This is my Model

public function show($name, $category)
    {
        $FodMap = FodMap::find($name, $category);
        return $FodMap;


    }

Routes

Route::get('FodMap/{name}/{category}', 'FodMapController@show');

What I want is when I type localhost/api/FodMap/hello/main

All result should display which matches with hello and main

Please advise me to proceed.... I'm new to Laravel.

Answer 1

The eloquent query is something like this:

FodMap::where('name','=',$name)->where('category','=',$category)->get()

That will return an Eloquent Collection instance.