TheLazy.Dev
Portfolio GitHub

Blog

php |laravel |tutorial |webdev

Server-Side Rendering of DataTables in Laravel

sharman

Arman Hasan

Posted on October 26, 2021

Server-Side Rendering of DataTables in Laravel

Hello artisans how's everything going as a Laravel developer? Hopefully great. Working in Laravel locally or in production we need to work with datatables in many manners. Now We will see the yajra datatable with proper oriented steps to handle small and huge data records. Usually most of the developers render data on the client-side using jQuery Datatables. But when the volume of data is big, server-side rendering can boost performance. In this article, I'll discuss the process of rendering datatables on server-side using one of the most popular packages out there.

Table Of Contents

  1. Prerequisite
  2. Installation & Configuration
  3. Model and Migrations
  4. Database Connection
  5. Dummy Data With Faker
  6. Controller & Routes
  7. Setup Blade File
  8. Conclusion

Prerequisite

Basically the prerequisite will already filled up with Laravel installation because you have to have composer and installed Laravel project to use yajra as well
To install Laravel demo application latest version use the below command



composer create-project laravel/laravel demoapp
Enter fullscreen mode Exit fullscreen mode

Installation & Configuration

In the Laravel project folder demoapp and open command prompt to execute this command to get the latest updated version of yajra package



composer require yajra/laravel-datatables
Enter fullscreen mode Exit fullscreen mode

Now need to published the vendod files



php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"
Enter fullscreen mode Exit fullscreen mode

Now in your 'demoapp/composer.json' file you can see this yajra added to your application.



 "require": {
        ...,
        "yajra/laravel-datatables-oracle": "^9.18"
    },
Enter fullscreen mode Exit fullscreen mode

Then you have to add those providers and aliases array's in root/config/app.php file 



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

'aliases' => [ 
    ...,
    'DataTables' =>Yajra\DataTables\Facades\DataTables::class,
    ],
Enter fullscreen mode Exit fullscreen mode

after adding the line in provider list
then need to run this command to update and published the vendor files 



php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"
Enter fullscreen mode Exit fullscreen mode

Now good to go and serve the application, with artisan command



php artisan serve


``` now type this url in the browser to see the welcome page of laravel  `http://127.0.0.1:8000/` 

![Laravel welcome page](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hnl19slj28sfobqwwmvu.png)


<h3>
  <a name="ModelandMigrations" href="#ModelandMigrations" class="anchor"></a>
  Model and Migrations
</h3>

To set up the database we need to create a model and migration table for the schema. run this command to create a model and migration at the same time. 

```php


php artisan make:model Customer -m
Enter fullscreen mode Exit fullscreen mode

We are creating a customer schema table for our demoapp and the -m is responsible for creating the migration table.
Open up the database/migrations/2021_10_05_100745_create_customers_table file and create the customer table schema.



<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateCustomersTable extends Migration
{
    public function up()
    {
        Schema::create('customers', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('phone')->unique();
            $table->string('email')->unique();
            $table->string('address');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('customers');
    }
}
Enter fullscreen mode Exit fullscreen mode

Open up the app/Models/Customer.php to add the $fillable array in the Customer Model. 



<?php

namespace App\Models;

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

class Customer extends Model
{
    use HasFactory;

    protected $fillable = [
        'name',
        'phone',
        'email',
        'address',
    ];  
}
Enter fullscreen mode Exit fullscreen mode

Database Connection

Create a database to connect with the laravel application. I'm using MySQl database for my demoapp now got to the demoapp/.env file and the database name and connection setup



DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=demoapp
DB_USERNAME=root
DB_PASSWORD=
Enter fullscreen mode Exit fullscreen mode

Dummy Data With Faker

we need to create some dummy data to test the yajra-datatables. using faker and DatabaseSeeder.
need to this 



php artisan make:factory CustomerFactory --model=Customer
Enter fullscreen mode Exit fullscreen mode

command to create CustomerFactory go to the database/factories/CustomerFactory.php and add those code



<?php

namespace Database\Factories;

use App\Models\Customer;
use Illuminate\Database\Eloquent\Factories\Factory;

class CustomerFactory extends Factory
{
    protected $model = Customer::class;

    public function definition()
    {
        return [
            "name" => $this->faker->name(),
            "phone" => $this->faker->phoneNumber,
            "email" => $this->faker->safeEmail,
            "address" => $this->faker->address
        ];
    }
}
Enter fullscreen mode Exit fullscreen mode

in the database/seeds/DatabaseSeeder.php file add this line



<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    public function run()
    {
        \App\Models\Customer::factory(1000)->create();
    }
}
Enter fullscreen mode Exit fullscreen mode

now run this command to seed data into the database



php artisan migrate --seed
Enter fullscreen mode Exit fullscreen mode

now we got 1000 customer data in the database

database

Controller & Routes

Need to create a CustomerController for the functions for fetch data and display in the Yajra database.



php artisan make:controller CustomerController
Enter fullscreen mode Exit fullscreen mode

In the app/Http/Controllers/CustomerController.php need to write the method for fetching the data dynamically into the yajra datatables



<?php

namespace App\Http\Controllers;

use DB;
use DataTables;
use App\Models\Customer;
use Illuminate\Http\Request;


class CustomerController extends Controller
{
    public function customer(Request $request)
    {
        if ($request->ajax()) {
            $data = DB::table('customers')->latest()->get();
            return Datatables::of($data)
                ->addIndexColumn()
                ->addColumn('action', function($row){
                    $actions = 
                    '<a href="#" class="btn btn-sm btn-primary">Edit</a>
                    <a href="#" class="btn btn-sm btn-danger">Delete</a>';
                    return $actions;
                })
                ->rawColumns(['action'])
                ->make(true);
        }
    }
}
Enter fullscreen mode Exit fullscreen mode

Now let's create a route for handling the request responses



<?php

use Illuminate\Support\Facades\Route;
use App\Http\Controllers\CustomerController;

Route::get('/', function () {
    return view('welcome');
});

Route::get('/customer', [CustomerController::class, 'customer']);
Enter fullscreen mode Exit fullscreen mode

Setup Blade Files

Go to resources/views/welcome.blade.php file and set the blade file to show datatable.



<!DOCTYPE html>
<html>
<head>
    <title>Laravel Yajra Datatable</title>
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet"">
    <link href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/1.10.21/css/dataTables.bootstrap4.min.css" rel="stylesheet">
</head>

<body>

<div class="container">
    <div class="row" style="margin: 1rem;">
        <h2 class="text-center ">Laravel Yajra Datatable</h2>
        <div class="card" style="padding-top:40px; border-radius: 5px;">
            <table class="table table-striped yajra-datatable" style="padding-top:10px;">
                <thead class="">
                    <tr>
                        <th>No</th>
                        <th>Name</th>
                        <th>Phone</th>
                        <th>Email</th>
                        <th>Address</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>
    </div>
</div>

</body>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>

<script type="text/javascript">
  $(function () {
    var table = $('.yajra-datatable').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ url('customer') }}",
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'phone', name: 'phone'},
            {data: 'address', name: 'address'},
            {
                data: 'action', 
                name: 'action', 
                orderable: true, 
                searchable: true
            },
        ]
    });
  });
</script>
</html>
Enter fullscreen mode Exit fullscreen mode

Here's all the data loaded in server-side
welcome page with data

Conclusion

Yajra DataTables server-side processing system is much easier to use and render huge datas within a few minutes. Highly recommended to use yajra datatables.

💖 💪 🙅 🚩
sharman
Arman Hasan

Posted on October 26, 2021

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

Guide to Integrating Google Places Autocomplete in Laravel
php Guide to Integrating Google Places Autocomplete in Laravel

September 13, 2024

Laravel 9 Create Custom Helper Functions Tutorial
php Laravel 9 Create Custom Helper Functions Tutorial

May 28, 2022

Server-Side Rendering of DataTables in Laravel
php Server-Side Rendering of DataTables in Laravel

October 26, 2021

PHP _call 🧙‍♂️(Lesson 3: PHP Magic Methods)
php PHP _call 🧙‍♂️(Lesson 3: PHP Magic Methods)

August 7, 2021

Laravel Jetstream Subscription Billing With Stripe Checkout and Customer Portal
php Laravel Jetstream Subscription Billing With Stripe Checkout and Customer Portal

December 1, 2020