This Laravel 7 datatables tutorial respectively teach us the essential methods to create and show the yajra datatables laravel 7 examples.

We will try to destroy the vagueness you might get surrounded while creating laravel 7 datatables example. Simultaneously, we will have a look on laravel 7 datatables AJAX example along with Bootstrap datatable in laravel 7.

Laravel 7 Datatables Example

Imagine about the situation when you see thousands of records, and you have to scan through every record to get the required information. Seems difficult isn’t? Well, I reckon Datatables makes our work less miserable and offers quick search, pagination, ordering, sorting functionalities to manage the data dynamically in the table.

DataTables is a plug-in powered by jQuery often known as Javascript library. It is a notably flexible tool, developed upon the foundations of progressive and dynamic enhancement, that incorporates all of these subtle and advanced features to any static HTML table.

Some of the top-notch features:

• Pagination
• Instant search
• Multi-column ordering
• Use almost any data source
• Easily theme-able
• Wide variety of extensions
• Mobile friendly
• Fully internationalisable

Although we are only going to use a handful of functionalities like search, sort and pagination, we will try to blend these features with visually appealing HTML table sturdy from the UI/UX perspective.

Table of Contents

1. Install Laravel App
2. Install Yajra Datatables
3. Set Up Model and Migrations
4. Insert Dummy Data
5. Define Route
6. Create Controller
7. Create View
8. Conclusion

Install Laravel App

In general, our first step primarily focuses on installing a new laravel application. Run the below-mentioned artisan command to install the sacred canon.

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

BashCopy

Run command to get inside the project directory.

cd laravel-yajra-datatables 

BashCopy

Install Yajra Datatable Package

I wonder if you haven’t heard about Yajra Datatables library, it is a jQuery DataTables API for Laravel 4|5|6|7. This plugin handles server-side works of DataTables jQuery plugin through AJAX option by considering the Eloquent ORM, Fluent Query Builder or Collection.

Theoretically, the following command helps you installing the Yajra DataTable plugin in Laravel.

composer require yajra/laravel-datatables-oracle

BashCopy

As soon as we complete the installation, then we add the foundational service of the package such as datatable service provider in providers and alias inside the config/app.php file.

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

PHPCopy

Set Up Model and Migrations

Run command to create a model, and it holds the schema of the database table.

php artisan make:model Student -m

BashCopy

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();
    });
}

PHPCopy

Open app/Student.php and define the schema in the $fillable array.

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

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

PHPCopy

Run migration using the following command.

php artisan migrate

#laravel