Laravel with Packages | Laravel Datatables Filter with Dropdown Example

4 min readOct 16, 2022

Now, let’s see an example of a laravel datatables filter dropdown example. We will use laravel datatables custom filter with dropdown. I would like to show you the laravel datatables dropdown filter example. it’s a simple example of a datatables dropdown filter with laravel. You just need to do some steps to do the yajra datatable dropdown filter with laravel.

you can easily add a dropdown filter with yajra datatables in laravel 6, laravel 7, laravel 8, and laravel 9.

In this tutorial, I will show you how to add a custom filter with a dropdown with laravel yajra datatable. we will add a status column in the users table and we will display the status “Active” and “Deactive” in-out table. add a dropdown with active and deactivate at the top so you can select and filter it.

So let’s follow this tutorial and you will get the layout as like below:

Preview:

Step 1: Install Laravel

In this step, if you haven’t laravel application setup then we have to get a fresh laravel 7 application. So run the bellow command and get a clean fresh laravel 7 application.

composer create-project --prefer-dist laravel/laravel blog

Step 2 : Install Yajra Datatable

We need to install yajra datatable composer package for datatable so that you can install using the following command:

composer require yajra/laravel-datatables-oracle

After that, you need to set providers and alias.

config/app.php

.....'providers' => [....Yajra\DataTables\DataTablesServiceProvider::class,]'aliases' => [....'DataTables' => Yajra\DataTables\Facades\DataTables::class,].....

Step 3: Add Status Column to Users Table

Here, we need to create a migration for adding a status column, so let’s run the bellow command to create a migration:

php artisan make:migration add_status_column

database/migrations/2020_07_02_032158_add_status_column.php

<?php
  
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
  
class AddStatusColumn extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('users', function (Blueprint $table) {
            $table->boolean('status')->default(0);
        });
    }
  
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
         
    }
}

Now we can run our migration:

php artisan migrate

Step 4: Add Dummy Records

In this step, we will create some dummy users using the tinker factory. so let’s create dummy records using below command:

php artisan tinkerfactory(App\User::class, 200)->create();

Step 5: Add Route

In this step we need to create a route for datatables layout file and another one for getting data. so open your routes/web.php file and add the following route.

routes/web.php

Route::get('users', ['uses'=>'UserController@index', 'as'=>'users.index']);

Step 6: Create Controller

At this point, now we should create a new controller as UserController. this controller will manage the layout and getting data request and return response, so put the below content in the controller file:

app/Http/Controllers/UserController.php

<?php
       
namespace App\Http\Controllers;
      
use App\User;
use Illuminate\Http\Request;
use DataTables;
      
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $data = User::select('*');
            return Datatables::of($data)
                    ->addIndexColumn()
                    ->addColumn('status', function($row){
                         if($row->status){
                            return '<span class="badge badge-primary">Active</span>';
                         }else{
                            return '<span class="badge badge-danger">Deactive</span>';
                         }
                    })
                    ->filter(function ($instance) use ($request) {
                        if ($request->get('status') == '0' || $request->get('status') == '1') {
                            $instance->where('status', $request->get('status'));
                        }
                        if (!empty($request->get('search'))) {
                             $instance->where(function($w) use($request){
                                $search = $request->get('search');
                                $w->orWhere('name', 'LIKE', "%$search%")
                                ->orWhere('email', 'LIKE', "%$search%");
                            });
                        }
                    })
                    ->rawColumns(['status'])
                    ->make(true);
        }
        
        return view('users');
    }
}

Step 7: Create a View

In the Last step, let’s create users.blade.php(resources/views/users.blade.php) for layout and we will write design code here and put the following code:

resources/views/users.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel Datatables Filter with Dropdown Example - raviyatechnical</title>
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
    <link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
    <script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
    <script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
</head>
<body>
     
<div class="container">
    <h1>Laravel Datatables Filter with Dropdown Example - raviyatechnical</h1>
      
    <div class="card">
        <div class="card-body">
            <div class="form-group">
                <label><strong>Status :</strong></label>
                <select id='status' class="form-control" style="width: 200px">
                    <option value="">--Select Status--</option>
                    <option value="1">Active</option>
                    <option value="0">Deactive</option>
                </select>
            </div>
        </div>
    </div>
  
    <table class="table table-bordered data-table">
        <thead>
            <tr>
                <th>No</th>
                <th>Name</th>
                <th>Email</th>
                <th width="100px">Status</th>
            </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>
     
</body>
     
<script type="text/javascript">
  $(function () {
      
    var table = $('.data-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: {
          url: "{{ route('users.index') }}",
          data: function (d) {
                d.status = $('#status').val(),
                d.search = $('input[type="search"]').val()
            }
        },
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'status', name: 'status'},
        ]
    });
  
    $('#status').change(function(){
        table.draw();
    });
      
  });
</script>
</html>

Now we are ready to run our example so run the bellow command or a quick run:

php artisan serve

Now you can open bellow URL on your browser:

http://localhost:8000/users

I hope it can help you...

Sponsor @bhargavraviya on GitHub Sponsors

@bhargavraviya's goal is to earn $10 per month I'll be able to work on open source! and create your flutter…

github.com