Laravel 5 Query Builder Search Filter

You can use get request to accomplish this. Lets say you have a form in your view that looks like that:

<form method="GET">
    <input type="text" name="name">
    <input type="checkbox" name="hasCoffeeMachine" value="1"><span> Apply Filter</span>
</form>

You should specify the route in your routes.php file like that:

Route::get('/', 'SearchController@search');

In your SearchController you'd have a method search that takes the values and performs the query:

class SearchController extends Controller {

    public function search() {

        // Sets the parameters from the get request to the variables.
        $name = Request::get('name');
        $hasCoffeeMachine = Request::get('hasCoffeeMachine');

        // Perform the query using Query Builder
        $result = DB::table('customers')
            ->select(DB::raw("*"))
            ->where('name', '=', $name)
            ->where('has_coffee_machine', '=', $hasCoffeeMachine)
            ->get();

        return $result;
    }
}

How do I do this with an Input field on the same page? This is my question from: http://stackoverflow.com/questions/34799481/laravel-5-php-filter-results-with-input-value

I have this where I get all my tournaments $tournaments = Tournament::all();.

Now I want to let the user filter these on the go in the view... I would like to have an <input> where the user enters a few characters and then the results filter on tournaments that have those characters in the name.

I have found this* online but I dont know how to populate that $keyword. It would be best if the results filter after every character that is entered in the inputfield. If this is not possible, then make this a form that sends this $keyword to Controller and retrieves the new results on the same page! * $tournament = Tournament::where('name', 'LIKE', '%'.$keyword.'%')->get();

How do I do this? I don't know... Please provide some code in the answer.

Thx

https://laracasts.com/series/eloquent-techniques/episodes/4

I was needing to do exactly this but with anywhere from 10-25 filter criteria which gave birth to the EloquentFilter package which does exactly this.

https://github.com/Tucker-Eric/EloquentFilter

Disclaimer: I am the author of this package.

Do you mean something like this. https://drive.google.com/file/d/0B1_PFw--3o74YjVreHNBOWU2aEE/view?usp=sharing

#jlrdw.. how can I get it??

It's just a little search form at top, just like on this forum. The search logic is in controller:

$query = Dog::where('dogname', 'like', $dogsch);
        if ($aval == "n") {
            $query->where('adopted', '=', 1);
        } else if ($aval == "y") {
            $query->where('adopted', '=', 0);
        }
        $dogs = $query->orderBy('lastedit', 'DESC')->paginate(5);

I suggest using this package :

https://github.com/mohammad-fouladgar/eloquent-builder

@kgadzhev Very helpful code