rougin / datatables
Handles server-side of DataTables in PHP.
Requires
- php: >=5.3.0
Requires (Dev)
- phpunit/phpunit: ~4.2|~5.7|~6.0|~7.0|~8.0|~9.0
- robmorgan/phinx: ~0.1
- sanmai/phpunit-legacy-adapter: ~6.1|~8.0
This package is auto-updated.
Last update: 2024-11-17 15:30:37 UTC
README
Datatables
is a simple PHP package that handles the server-side of DataTables. Its server-side response can be used by DataTables
from the HTML which requires little to no configuration.
Installation
Install the Datatables
package via Composer:
$ composer require rougin/datatables
Basic usage
Prior in configuring Datatables
, kindly ensure that the serverSide
property is set to true
in the Javascript part:
// index.js let options = { processing: true } options.ajax = 'http://localhost:8000' options.serverSide = true new DataTable('#example', options)
<!-- index.html --> <!-- ... --> <table id="example"></table>
Note
For more information in the above example, kindly see the official guide on how to implement server-side rendering of data to DataTables
.
From the PHP part, use the Table
class to define the specified table:
// index.php use Rougin\Datatables\Request; use Rougin\Datatables\Table; // ... // The $_GET variable should be returned --- // and parsed as array<string, mixed> ------ $request = new Request($_GET); // ----------------------------------------- // Parse columns based on the Request --------- $table = Table::fromRequest($request, 'users'); // --------------------------------------------
By default, getting columns from the payload of the Javascript part of DataTables
does not provide its name (e.g., forename
, surname
, etc.). As the column name is required for getting its data from a source, there is a need to map its column to the database table:
// index.php // ... // The first column will be named as "forename" --- $table->mapColumn(0, 'forename'); // ------------------------------------------------ $table->mapColumn(1, 'surname'); $table->mapColumn(2, 'position'); $table->mapColumn(3, 'office'); $table->mapColumn(4, 'date_start'); $table->mapColumn(5, 'salary'); // ...
Once the table has been properly configured, initialize a source (e.g., PdoSource
) that will be used for getting the data of the specified table:
// index.php use Rougin\Datatables\Source\PdoSource; // ... // Create a PDO instance... -------------- $dsn = 'mysql:host=localhost;dbname=demo'; $pdo = new PDO($dsn, 'root', /** ... */); // --------------------------------------- // ...then pass it to the PdoSource --- $source = new PdoSource($pdo); // ------------------------------------ // ...
Then use the Query
class to generate the requested data:
// index.php use Rougin\Datatables\Query; // ... /** @var \Rougin\Datatables\Source\SourceInterface */ $source = /** ... */; $query = new Query($request, $source); /** @var \Rougin\Datatables\Result */ $result = $query->getResult($table);
The getResult
from the Query
class returns a Result
class in which returns the response as an array or as JSON format:
// index.php // ... /** @var \Rougin\Datatables\Result */ $result = $query->getResult($table); echo $result->toJson();
$ php index.php
{ "draw": 1, "recordsFiltered": 57, "recordsTotal": 57, "data": [ [ "Airi", "Satou", "Accountant", "Tokyo", "2008-11-28", "162700.0" ], [ "Angelica", "Ramos", "Chief Executive Officer (CEO)", "London", "2009-10-09", "1200000.0" ], // ... ] }
Creating custom sources
To create a custom source, kindly use the SourceInterface
for its implementation:
namespace Rougin\Datatables\Source; use Rougin\Datatables\Request; use Rougin\Datatables\Table; interface SourceInterface { /** * Returns the total items after filter. If no filters * are defined, the value should be same with getTotal. * * @return integer */ public function getFiltered(); /** * Returns the items from the source. * * @return string[][] */ public function getItems(); /** * Returns the total items from the source. * * @return integer */ public function getTotal(); /** * Sets the payload to be used in the source. * * @param \Rougin\Datatables\Request $request * * @return self */ public function setRequest(Request $request); /** * Sets the table to be used in the source. * * @param \Rougin\Datatables\Table $table * * @return self */ public function setTable(Table $table); }
Changelog
Please see CHANGELOG for more information what has changed recently.
Testing
If there is a need to check the source code of Datatables
for development purposes (e.g., creating fixes, new features, etc.), kindly clone this repository first to a local machine:
$ https://github.com/rougin/authsum.git "Sample"
After cloning, use Composer
to install its required packages:
$ cd Sample
$ composer update
Once the packages were installed, kindly check the following below on how to maintain the code quality and styling guide when interacting the source code of Datatables
:
Unit tests
Datatables
also contains unit tests that were written in PHPUnit:
$ composer test
When creating fixes or implementing new features, it is recommended to run the above command to always check if the updated code introduces errors during development.
Code quality
To retain the code quality of Datatables
, a static code analysis code tool named PHPStan is being used during development. To start, kindly install the specified package in global environment of Composer
:
$ composer global require phpstan/phpstan
Once installed, PHPStan
can now be run using the phpstan
command:
$ cd Sample
$ phpstan
Coding style
Asides from code quality, Datatables
also uses a tool named PHP Coding Standards Fixer for maintaining an opinionated style guide. The said tool needs also to be installed in the global environment of Composer
:
$ composer global require friendsofphp/php-cs-fixer
After being installed, use the php-cs-fixer
command in the same Datatables
directory:
$ cd Sample
$ php-cs-fixer fix --config=phpstyle.php
The specified phpstyle.php
currently follows the PSR-12 as the baseline of the coding style and uses Allman as its indentation style.
Note
Installing PHPStan
and PHP Coding Standards Fixer
requires a version of PHP that is 7.4
and above.
License
The MIT License (MIT). Please see LICENSE for more information.