What is Yajra Datatables Plugin in Laravel & How to implement it

[breadcrumb]

Data is an essential part of every web application. It holds the information regarding that particular app. So, the developer should properly carry out the data displaying task. The importance of displaying information effectively is a necessity for any application to be able to be User Friendly. Fortunately, Laravel has a plugin called Yajra Datatables, which simplifies this task. 

What is Yajra  plugin?

Yajra datatables is a JQuery plugin used to implement pagination in the web page and helps in sorting, searching, and arranging the data

How to use Yajra Datatables Plugin?

Step 1: Install Yajra Package 

First, you have to install Yajra Datatables Package, run this command to install Yajra Datatables

composer require yajra/laravel-datatables-oracle.

Step 2: Set Providers and Alias

Open config/app.php File

….. 

‘providers’ => [ 

   …. 

   Yajra\DataTables\DataTablesServiceProvider::class, 

] 

‘aliases’ => [ 

   …. 

   ‘DataTables’ => Yajra\DataTables\Facades\DataTables::class, 

] 

Step 3: Create Dummy Records

Now create some dummy records to fill the datatables, run this command in command-line 

php artisan tinker 

factory(App\User::class, 1000)->create();

This command creates a fake data in your database.

Step 4: Create Route 

Open your routes/web.php file and create this route:

Route::get(‘user’, ‘UserController@index’)->name(‘user.list);

Step 5: Create Controller

Open app/http/controllers/ folder, create UserController file with this code. 

<?php

namespace App\Http\Controllers; 

use App\User; 

use Illuminate\Http\Request; 

use DataTables; 

    

class UserController extends Controller 

{ 

   public function index(Request $request)    { 

       if ($request->ajax())    { 

           $data = User::latest()->get(); 

           return Datatables::of($data) 

                   ->addIndexColumn() 

                   ->addColumn(‘action’, function($row)    { 

                          $btn = ‘<a href=”javascript:void(0)” class=”edit btn btn-primary btn-sm”>Edit</a>’; 

                           return $btn; 

                   }) 

                   ->rawColumns([‘action’]) 

                   ->make(true); 

       } 

       return view(‘users’); 

   } 

} 

Step 6: Create View 

Create a resources/views/index.blade.php file and create a view like this.

<!DOCTYPE html> 

<html> 

<head> 

   <title>Datatable</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”> 

</head> 

<body> 

   

<div class=“container”> 

   <table class=“table table-bordered data-table”> 

       <thead> 

           <tr> 

               <th>No</th> 

               <th>Name</th> 

               <th>Email</th> 

               <th>Action</th> 

           </tr> 

       </thead> 

       <tbody> 

       </tbody> 

   </table> 

</div> 

</body> 

  

<script type=“text/javascript”> 

 $(function () { 

   

   var table = $(‘.data-table’).DataTable({ 

       processing: true, 

       serverSide: true, 

       ajax: “{{ route(‘user.list’) }}”, 

       columns: [ 

           {data: ‘DT_RowIndex’, name: ‘DT_RowIndex’}, 

           {data: ‘name’, name: ‘name’}, 

           {data: ’email’, name: ’email’}, 

           {data: ‘action’, name: ‘action’, orderable: false, searchable: false}, 

       ] 

   }); 

   

 }); 

</script> 

</html> 

Now your code is ready to be executed, run this command:

php artisan serve 

Conlusion

I hope this tutorial was informative and helpful for your Laravel development. For more such tuts, please check our blog and share this article with your other Laravel learner buddies. Happy Coding!! 

If you are looking for a software firm to create your business website or mobile app, your search ends here. We build affordable and robust software solutions for businesses to digitally thrive on. Contact us to get a quote. You can mail us on [email protected] or WhatsApp us on +91 95 37 84 38 39.