Datatables

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.