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.

 

url
http://localhost:8000/users

 

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

 

laravel-datatable-example

 

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

 

Hope it can help you.

 

#laravel