esclaudio/datatables

datatables 的简单服务器端处理

1.1.0 2022-01-22 19:51 UTC

This package is auto-updated.

Last update: 2024-09-23 01:29:29 UTC


README

Latest Version on Packagist GitHub Tests Action Status Total Downloads

安装

您可以通过 composer 安装此包

composer require esclaudio/datatables

使用方法

use Esclaudio\Datatables\Datatables;
use Esclaudio\Datatables\Options;
use Esclaudio\Datatables\Database\Connection;

$connection = new Connection(new \PDO(...));
$options = new Options($_GET);

header('Content-Type: application/json');
echo (new Datatables($connection, $options))
    ->from('posts')
    ->join('users', 'users.id', '=', 'posts.created_by')
    ->select([
        'posts.id as id',
        'posts.title as title',
        'users.name as creator',
    ])
    ->toJson(); // {"draw": 1, "recordsTotal": 1, "recordsFiltered": 1, "data": {...}}

测试

composer test

变更日志

请参阅 CHANGELOG 了解最近更改的详细信息。

许可协议

MIT 许可协议 (MIT)。请参阅 许可文件 了解更多信息。