Laravel Datatables Server-side Processing

Today, We want to share with you laravel datatables.In this post we will show you Laravel 6 Crud Application using Yajra Datatable and Ajax, hear for How to Implement Yajra DataTable in Laravel 7 we will give you demo and example for implement.In this post, we will learn about How to Install Yajra DataTable With Laravel 6 Application with an example.

laravel datatables

Contents

There are the Following The simple About How To Install Yajra DataTable In Laravel App Full Information With Example and source code.

As I will cover this Post with live Working example to develop DataTable – Server-side Processing in Laravel 5|6|7, so the Datatable Tutorial for Laravel 6 is used for this example is following below.

Also Read This 👉 PHP Generate PDF from MySQL Database using FPDF

Phase 1: Install Laravel

application setup

composer create-project --prefer-dist laravel/laravel corona19

Phase 2 : Install Yajra Datatable Package

install yajra datatable composer package for datatable

composer require yajra/laravel-datatables-oracle

config/app.php

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

Free Live Chat for Any Issue

Phase 3: Make a Dummy Records

dummy members using tinker factory

php artisan tinker

factory(App\Member::class, 200)->create();

Phase 4: Make a Route

routes/web.php

Route::get('members', ['uses'=>'[email protected]', 'as'=>'members.index']);

Phase 5: Make a Controller

app/Http/Controllers/MemberController.php

<?php
     
namespace App\Http\Controllers;
     
use App\Member;
use Illuminate\Http\Request;
use DataTables;
     
class MemberController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $data = Member::latest()->get();
            return Datatables::of($data)
                    ->addIndexColumn()
                    ->addColumn('action', function($row){
   
                           $btn = '<a href="javascript:void(0)" class="edit btn btn-primary btn-sm">View</a>';
     
                            return $btn;
                    })
                    ->rawColumns(['action'])
                    ->make(true);
        }
      
        return view('members');
    }
}

Phase 6: Make a View

resources/views/members.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 5/6/7 Datatable Tutorial - pakainfo.com</title>
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
    <link href="//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
    <link href="//cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet">
    <script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
    <script src="//cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>
    <script src="//cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
    <script src="//stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
    <script src="//cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
</head>
<body>
    
<div class="container">
    <h1>Laravel 5,6,7 Datatable Tutorial <br/> pakainfo.com</h1>
    <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>
   
</body>
   
<script type="text/javascript">
  $(function () {
    
    var table = $('.data-table').DataTable({
        processing: true,
        serverSide: true,
        ajax: "{{ route('members.index') }}",
        columns: [
            {data: 'DT_RowIndex', name: 'DT_RowIndex'},
            {data: 'name', name: 'name'},
            {data: 'email', name: 'email'},
            {data: 'action', name: 'action', orderable: false, searchable: false},
        ]
    });
    
  });
</script>
</html>

Web Programming Tutorials Example with Demo

Read :

Also Read This 👉 How to use Datatables in Laravel 5.8

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about yajrabox docs laravel datatable (Simple DataTable – Server-side Processing in PHP Laravel 5|6|7 Step by step).
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Pakainfo

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I’m a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Also Read This 👉 Implement Yajra Datatables in Laravel 7 Application