yajra / laravel-datatables by yajra

jQuery DataTables API for Laravel 4|5
2,977,806
2,605
119
Package Data
Maintainer Username: yajra
Maintainer Contact: aqangeles@gmail.com (Arjay Angeles)
Package Create Date: 2013-11-27
Package Last Update: 2018-11-27
Home Page: https://yajrabox.com/docs/laravel-datatables
Language: PHP
License: MIT
Last Refreshed: 2018-12-11 12:43:30
Package Statistics
Total Downloads: 2,977,806
Monthly Downloads: 141,366
Daily Downloads: 5,847
Total Stars: 2,605
Total Watchers: 119
Total Forks: 516
Total Open Issues: 376

jQuery DataTables API for Laravel 4|5

Join the chat at https://gitter.im/yajra/laravel-datatables Donate Donate

Laravel 4.2|5.x Latest Stable Version Latest Unstable Version Build Status Scrutinizer Code Quality Total Downloads License

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.

return datatables()->of(User::query())->toJson();
return datatables()->of(DB::table('users'))->toJson();
return datatables()->of(User::all())->toJson();

return datatables()->eloquent(User::query())->toJson();
return datatables()->query(DB::table('users'))->toJson();
return datatables()->collection(User::all())->toJson();

return datatables(User::query())->toJson();
return datatables(DB::table('users'))->toJson();
return datatables(User::all())->toJson();

Requirements

Documentations

Laravel Version Compatibility

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

DataTables 8.x Upgrade Guide

There are breaking changes since DataTables v8.x. If you are upgrading from v7.x to v8.x, please see upgrade guide.

Quick Installation

$ composer require yajra/laravel-datatables-oracle:"~8.0"

Service Provider & Facade (Optional on Laravel 5.5)

Register 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 make sure that APP_DEBUG is set to false when your app is on production.

PHP ARTISAN SERVE BUG

Please avoid using php artisan serve when developing with 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

License

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

Buy me a coffee

paypal Become a Patron