jQuery DataTables API for Laravel
Laravel package for handling server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection.
use Yajra\DataTables\Facades\DataTables;
return DataTables::eloquent(User::query())->toJson();
return DataTables::query(DB::table('users'))->toJson();
return DataTables::collection(User::all())->toJson();
return DataTables::make(User::query())->toJson();
return DataTables::make(DB::table('users'))->toJson();
return DataTables::make(User::all())->toJson();
A big thank you to DataTables for supporting this project with a free DataTables Editor license. |
A big thank you to JetBrains for supporting this project with free open-source licenses of their IDEs. |
A big thank you to Blackfire.io for supporting this project with a free open-source license. |
Laravel | Package |
---|---|
4.2.x | 3.x |
5.0.x | 6.x |
5.1.x | 6.x |
5.2.x | 6.x |
5.3.x | 6.x |
5.4.x | 7.x, 8.x |
5.5.x | 8.x |
5.6.x | 8.x |
5.7.x | 8.x |
5.8.x | 9.x |
6.x | 9.x |
7.x | 9.x |
8.x | 9.x |
9.x | 10.x |
10.x | 10.x |
11.x | 11.x |
composer require yajra/laravel-datatables:"^11"
composer require yajra/laravel-datatables-oracle:"^11"
Register the provider and facade on your config/app.php
file.
'providers' => [
...,
Yajra\DataTables\DataTablesServiceProvider::class,
]
'aliases' => [
...,
'DataTables' => Yajra\DataTables\Facades\DataTables::class,
]
php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"
And that’s it! Start building out some awesome DataTables!
To enable debugging mode, just set APP_DEBUG=true
and the package will include the queries and inputs used when processing the table.
[!IMPORTANT]
Please ensure that theAPP_DEBUG
config is set to false when your app is in production.
Please avoid using php artisan serve
when developing the package.
There are known bugs when using this where Laravel randomly returns a redirect and 401 (Unauthorized) if the route requires authentication and a 404 NotFoundHttpException on valid routes.
It is advised to use Homestead or Valet when working with the package.
Please see CONTRIBUTING for details.
If you discover any security-related issues, please email [email protected] instead of using the issue tracker.
The MIT License (MIT). Please see License File for more information.