DEV Community

Techsolutionstuff
Techsolutionstuff

Posted on • Originally published at techsolutionstuff.com

Install Yajra Datatables Laravel 11 Example

Hello developers, in this guide, we'll see how to install Yajra datatables laravel 11 example. Here, we'll use yajra/laravel-datatables composer package to use data tables in laravel 11.

In this tutorial, I'll walk you through the straightforward process of installing Yajra Datatables in your Laravel 11 application.

Yajra datatable provides different kinds of functionalities searching, sorting, pagination, ordering, etc, Also you can search on the server side and client side.

Laravel 11 Yajra Datatable Example

Step 1: Install Laravel 11

First, we'll install the laravel 11 application using the following command.

composer create-project laravel/laravel laravel-11-example
Enter fullscreen mode Exit fullscreen mode

Step 2: Install Yajra Datatables

Then, we'll install yajra/datatable composer package using the following command.

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

Step 3: Add Dummy Users

Now, we'll create some dummy records using the tinker. So, run the following command.

php artisan tinker

User::factory()->count(50)->create()
Enter fullscreen mode Exit fullscreen mode

Step 4: Create Controller

In this step, we'll create a UserController.php file. In this file we'll define the function and add the datatable.

app/Http/Controllers/UserController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\User;
use DataTables;

class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     * Yajra Datatable Laravel 11 - techsolutionstuff
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {

            $data = User::query();

            return Datatables::of($data)
                    ->addIndexColumn()
                    ->addColumn('action', function($row){

                            $btn = '<a href="javascript:void(0)" data-id="'.$row->id.'" class="edit btn btn-primary btn-sm">View</a>';
                            $btn .= '<a href="javascript:void(0)" data-id="'.$row->id.'" class="delete btn btn-danger btn-sm">Delete</a>';

                            return $btn;
                    })
                    ->rawColumns(['action'])
                    ->make(true);
        }

        return view('users');
    }
}
Enter fullscreen mode Exit fullscreen mode

Step 5: Create Route

Now, define the routes into the web.php file. So, add the following code snippets.

routes/web.php

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;

Route::get('users', [UserController::class, 'index'])->name('users.index');

Step 6: Create Blade File
Then, we'll create a users.blade.php file to display yajra datatable.

resources/views/users.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Install Yajra Datatables Laravel 11 Example - Techsolutionstuff</title>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.0.1/css/bootstrap.min.css" rel="stylesheet">
    <link href="https://cdn.datatables.net/1.11.4/css/dataTables.bootstrap5.min.css" rel="stylesheet">
    <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="https://cdn.datatables.net/1.11.4/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.11.4/js/dataTables.bootstrap5.min.js"></script>
</head>
<body>

<div class="container">
    <div class="card mt-5">
        <h3 class="card-header p-3">Install Yajra Datatables Laravel 11 Example - Techsolutionstuff</h3>
        <div class="card-body">
            <table class="table table-bordered data-table">
                <thead>
                    <tr>
                        <th>No</th>
                        <th>Name</th>
                        <th>Email</th>
                        <th width="100px">Action</th>
                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>
    </div>
</div>

</body>

<script type="text/javascript">
  $(function () {

    var table = $('.data-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('users.index') }}",
        columns: [
            {data: 'id', name: 'id'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'action', name: 'action', orderable: false, searchable: false},
        ]
    });

  });
</script>
</html>
Enter fullscreen mode Exit fullscreen mode

Step 7: Run the Laravel App

Now, run the laravel 11 application using the following command.

php artisan serve
Enter fullscreen mode Exit fullscreen mode

Top comments (0)