This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection.
use Yajra\Datatables\Facades\Datatables;
// Using Eloquent
return Datatables::eloquent(User::query())->make(true);
// Using Query Builder
return Datatables::queryBuilder(DB::table('users'))->make(true);
// Using Collection or Array
return Datatables::collection(User::all())->make(true);
return Datatables::collection([
['id' => 1, 'name' => 'Foo'],
['id' => 2, 'name' => 'Bar'],
])->make(true);
// Using the Engine Factory
return Datatables::of(User::query())->make(true);
return Datatables::of(DB::table('users'))->make(true);
return Datatables::of(User::all())->make(true);
return Datatables::of(DB::select('select * from users'))->make(true);- Laravel Datatables Documentation
- Laravel Datatables API
- Laravel 5.0 - 5.3 Demo Application.
- Laravel 5.4 Demo Application.
| 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 |
There are breaking changes since Laravel 5.4 and Datatables v7.0. If you are upgrading from v6.x to v7.x, please see upgrade guide.
composer require yajra/laravel-datatables-oracle:^7.2
Yajra\Datatables\DatatablesServiceProvider::class
Datatables facade is automatically registered as an alias for Yajra\Datatables\Facades\Datatables class.
$ php artisan vendor:publish --tag=datatables
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 make sure that APP_DEBUG is set to false when your app is on production.
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.
