Custom filter/Search with Laravel Datatables Example
By Hardik Savani May 16, 2019 Category : PHP LaravelHere, i want to show you how to add custom search with yajra datatables laravel. if you need to add custom filter like for datepicker, dropdown or specific fields of database then you can do it using laravel datatable.
Laravel yajra datatables provide default global search, in that search it will search entire row of table. But if you need to add for only one specific column like for created date search with datepicker or status with dropdown then you must have to implement custom filtering in your datatable.
Bellow i write step by step for how to add custom search filter with laravel 6, laravel 7, laravel 8 and laravel 9 datatables. just follow few steps and you will get simple example:
Step 1: Install Laravel 5.8
In this step, if you haven't laravel 5.8 application setup then we have to get fresh laravel 5.8 application. So run bellow command and get clean fresh laravel 5.8 application.
composer create-project --prefer-dist laravel/laravel blog
Step 2 : Install Yajra Datatable Package
We need to install yajra datatable composer package for datatable, so you can install using following command:
In this is step we need to create route for datatables layout file and another one for getting data. so open your routes/web.php file and add following route.
In this point, now we should create new controller as UserController. this controller will manage layout and getting data request and return response, so put bellow content in controller file:
app/Http/Controllers/UserController.php
<?php namespace App\Http\Controllers; use App\User;use Illuminate\Http\Request;use DataTables;use Illuminate\Support\Str; class UserController extends Controller{ /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { if ($request->ajax()) { $data = User::latest()->get(); return Datatables::of($data) ->addIndexColumn() ->filter(function ($instance) use ($request) { if (!empty($request->get('email'))) { $instance->collection = $instance->collection->filter(function ($row) use ($request) { return Str::contains($row['email'], $request->get('email')) ? true : false; }); } if (!empty($request->get('search'))) { $instance->collection = $instance->collection->filter(function ($row) use ($request) { if (Str::contains(Str::lower($row['email']), Str::lower($request->get('search')))){ return true; }else if (Str::contains(Str::lower($row['name']), Str::lower($request->get('search')))) { return true; } return false; }); } }) ->addColumn('action', function($row){ $btn = '<a href="javascript:void(0)" class="edit btn btn-primary btn-sm">View</a>'; return $btn; }) ->rawColumns(['action']) ->make(true); } return view('users'); }}
Step 6: Create View
In Last step, let's create users.blade.php(resources/views/users.blade.php) for layout and we will write design code here and put following code:
Here, i want to show you how to add custom search with yajra datatables laravel. if you need to add custom filter like for datepicker, dropdown or specific fields of database then you can do it using laravel datatable.
