seantrant
10/10/2016 - 1:53 PM

Simplest Search Function

Simplest Search Function

Source: laracasts.com/series/laravel-5-fundamentals

Add the following code to your eloquent user model

public function scopeSearchByKeyword($query, $keyword)
    {
        if ($keyword!='') {
            $query->where(function ($query) use ($keyword) {
                $query->where("name", "LIKE","%$keyword%")
                    ->orWhere("email", "LIKE", "%$keyword%")
                    ->orWhere("blood_group", "LIKE", "%$keyword%")
                    ->orWhere("phone", "LIKE", "%$keyword%");
            });
        }
        return $query;
    }
Then you can easily do

$keyword = Input::get('keyword', '');
$users = User::SearchByKeyword($keyword)->get();