How to Use Yajra Datatables in Laravel 8

In this tutorial you will learn about the How to Use Yajra Datatables in Laravel 8 and its application with practical example.

In this How to Use Yajra Datatables in Laravel 8 tutorial, I’ll show you how to install and use yajra DataTables in your laravel 8 application with example. In this tutorial you will learn to install and use yajra DataTables in your laravel 8 application. In this example, we will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature. Laravel Yajra datatables package comes with many built-in features for searching and sorting functionality.

Table Of Contents−

How to Use Yajra Datatables in Laravel 8

In this step by step tutorial I’ll guide you through the process to install and use yajra DataTables in your laravel application. In this tutorial I will demonstrate you with example installation and use of DataTables in laravel. Please follow the instruction given below:

Install Laravel App

Install Yajra Datatables
Set Up Model and Migrations
Insert Dummy Data

Create Controller
Define Route
Create View

Install Laravel App

First of all we need to create a fresh laravel project, download and install Laravel 8 using the below command

composer create-project laravel/laravel laravel-yajra-datatables --prefer-dist

1	composer create-project laravel/laravel laravel-yajra-datatables --prefer-dist

Switch into the project project directory using following command

cd laravel-yajra-datatables

1	cd laravel-yajra-datatables

Install Yajra Datatable Package

In this step, we will install Yajra Datatables Package via the composer dependency manager. Use the following command to install Yajra Datatables Package.

composer require yajra/laravel-datatables-oracle

1	composer require yajra/laravel-datatables-oracle

After Installing Yajra Datatables package, we need to add service provider and alias in config/app.php file as following.

config/app.php

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

.....

'providers' => [

....

Yajra\DataTables\DataTablesServiceProvider::class,

]

'aliases' => [

....

'DataTables' => Yajra\DataTables\Facades\DataTables::class,

]

.....

Run vendor publish command further this step is optional:

php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"

1	php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"

Set Up Model and Migrations

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Student -m

1	php artisan make:model Student -m

Open database/migrations/timestamp_create_students_table.php file and add the given below code.

public function up()
{
    Schema::create('students', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('email')->unique();
        $table->string('username');
        $table->string('phone');
        $table->string('dob');
        $table->timestamps();
    });
}

public function up()

{

Schema::create('students', function (Blueprint $table) {

$table->id();

$table->string('name');

$table->string('email')->unique();

$table->string('username');

$table->string('phone');

$table->string('dob');

$table->timestamps();

});

}

Next, go to app/Models/Student.php file and add the $fillable property in the Student model as following.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Student extends Model
{
    use HasFactory;
    protected $fillable = [
        'name',
        'email',
        'username',
        'phone',
        'dob',
    ];    
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Student extends Model

{

use HasFactory;

protected $fillable = [

'name',

'email',

'username',

'phone',

'dob',

];

}

Now, run the migration to create database table using following artisan command:

AngularJS

CodeIgniter

Laravel

Node Js

Wordpress

More Blog

Learn

ABOUT PAGES

How to Use Yajra Datatables in Laravel 8