March 30, 2020

laravel datatables Server-side Processing

JavaScript, jQuery, Laravel, php, Programming, Technology 0 Comments

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

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.

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,
]
.....

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 :

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.

Related FAQ

Here are some more FAQ related to this Article: