jQuery DataTables API for Laravel 4|5|6|7|8|9|10

#jQuery DataTables API for Laravel

The yajra/laravel-datatables-oracle package provides seamless integration of the jQuery DataTables plugin with Laravel. This package allows you to manage server-side data for DataTables using Laravel's Eloquent ORM, Fluent Query Builder, or Collections, enhancing your application's data manipulation capabilities.

#Key Features

• AJAX Data Handling: Efficiently manage DataTable content server-side to optimize performance and control.
• Support for Multiple Laravel Versions: Compatible with Laravel versions from 4.2 up to 10.x.
• Eloquent, Query Builder, and Collection Support: Flexible data handling options to suit different needs.
• Easy Debugging: Includes detailed query and input data when APP_DEBUG is set to true, aiding in development and troubleshooting.

#Installation and Setup

Install the package via composer:

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

#Optional Configuration

For Laravel versions below 5.5, manually register the provider and facade in config/app.php:

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

Publish the configuration file with:

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

Note: Avoid using php artisan serve due to known issues. Prefer using solutions like Laravel Homestead or Valet for local development.

#Usage

Retrieve and return DataTables-ready JSON:

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

#Documentation and Support

• Quick Starter Guide
• Full Documentation
• Additional support and discussions can be found on Gitter.

#Contributing

Community contributions are welcome. Check the GitHub repository for contribution guidelines.

This package simplifies the integration of server-side DataTables in Laravel, providing powerful AJAX data management for responsive web applications.