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
First, we'll install the laravel 11 application using the following command.
composer create-project laravel/laravel laravel-11-example
Then, we'll install yajra/datatable composer package using the following command.
composer require yajra/laravel-datatables
Now, we'll create some dummy records using the tinker. So, run the following command.
php artisan tinker
User::factory()->count(50)->create()
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');
}
}
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');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>
Now, run the laravel 11 application using the following command.
php artisan serve
You might also like:
- Read Also: How to Add Row in Datatable on Click of Button
- Read Also: How to Create Custom Helper Function in Laravel 11
- Read Also: How to Display Relationship Data into Yajra Datatables?
- Read Also: Refresh Datatable Without Reloading Page In Laravel 9
