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
return Datatables::collection(User::all())->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);- PHP 5.5.9 or later
- Laravel 5.0 or later
- DataTables jQuery Plugin Version 1.10.xx
- You will find user friendly and updated documentation in the wiki here: Laravel Datatables Wiki
- You will find the API Documentation here: Laravel Datatables API
- Demo Application is available for artisan's reference.
composer require yajra/laravel-datatables-oracle:~6.0
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!
- Change all occurrences of
yajra\DatatablestoYajra\Datatables. (Use Sublime's find and replace all for faster update). - Remove
Datatablesfacade registration. - Temporarily comment out
Yajra\Datatables\DatatablesServiceProvider. - Update package version on your composer.json and use
yajra/laravel-datatables-oracle: ~6.0 - Uncomment the provider
Yajra\Datatables\DatatablesServiceProvider.
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.
