Laravel Datatables | Yajra Datatables For Laravel 7

Hello Artisan 

In this tutorial, I am going to share with you how to install and use datatables in laravel 7 application. In this laravel demo datatable tutorial, i will use datatables laravel datatables plugin. I will write step by step tutorial for laravel datatables ajax.

Datatables provide you with quick search, ordering, sorting, pagination, etc. Datatables is a jQuery plugin that allows us to add some advanced interaction controls to your HTML tables data.

Datatables also provide ajax for data searching and getting. you can give a very quick layout for search and sorting using Datatables. We can also implement Datatables in your laravel 7 application.

Step 1: Install Laravel 7

In this step, we have to download a fresh laravel app to create step by step laravel yajra datatable example. So download it by the following command.

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

Step 2 : Install Yajra Datatable Package

Now we have to install yajra datatable package in our laravel app. So run the below command to install it.

composer require yajra/laravel-datatables-oracle

After that, you need to add providers and alias in the following path.

config/app.php

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

Step 3:  Add Dummy Records

In this, we need to add some dummy records to show datatable. I will create a user list to show it in datatable. I will use tinker to add it quickly. 

php artisan tinker
//then
factory(App\User::class, 100)->create();
//
exit

Step 4:  Create Route

In this step, we have to set up our route. I won't use any controller to create and show our users. I will simply return the user from the route for demo purposes. So follow the below guide to create laravel datatable.

routes/web.php

//Datatable Route
Route::get('users', function(){
  return view('test');
});

Route::get('userslist', function(){
  return datatables()->of(\DB::table('users')->select('*'))
      ->make(true);
})->name('userslist');

Step 5: Create Blade To View Datatable

Now in this final step, we need to create a blade to view datatable. So create test.blade.php and add the following code it.

resources/views/test.blade.php

Read also : Dynamic Pie Charts Example Using Google Charts API in Laravel 7

Now run php artisan serve command and visit this below path then you will see the below datatable.

And see the preview of this laravel yajra datatable tutorial's output.

Read also: Filter Data Between Two Dates in Yajra Datatables in Laravel

Hope it can help you.