#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();

#Sponsors

A big thank you to DataTables for supporting this project with a free DataTables Editor license.

A big thank you to Blackfire.io for supporting this project with a free open-source license.

#Requirements

• PHP >= 8.3
• Laravel Framework
• DataTables

#Documentations

• Github Docs
• Laravel DataTables Quick Starter
• Laravel DataTables Documentation

#Laravel Version Compatibility

#Quick Installation

#Option 1: Install all DataTables libraries

composer require yajra/laravel-datatables:"^13"

#Option 2: Install only this library

composer require yajra/laravel-datatables-oracle:"^13"

#Service Provider & Facade (Optional on Laravel 5.5+)

Register the provider and facade on your config/app.php file.

'providers' => [
    ...,
    Yajra\DataTables\DataTablesServiceProvider::class,
]

'aliases' => [
    ...,
    'DataTables' => Yajra\DataTables\Facades\DataTables::class,
]

#Configuration (Optional)

php artisan vendor:publish --provider="Yajra\DataTables\DataTablesServiceProvider"

And that's it! Start building out some awesome DataTables!

#Debugging Mode

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 the APP_DEBUG config is set to false when your app is in production.

#PHP ARTISAN SERVE BUG

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.

#Contributing

Please see CONTRIBUTING for details.

#Security

If you discover any security-related issues, please email aqangeles@gmail.com instead of using the issue tracker.

#Credits

• Arjay Angeles
• bllim/laravel4-datatables-package
• All Contributors

#License

The MIT License (MIT). Please see License File for more information.