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