server-side DataTables Library for CodeIgniter4

Hello everyone.. 

I’ve created a library to implement the server-side DataTables for codeIgniter4. 

here the link

github: 
https://github.com/hermawanramadhan/Code...ataTables/

documentation & example
https://hermawan.dev/codeigniter4-datatables/welcome

installation with composer (recommended)
installing with composer is recommended because can automatic install dependency.

Code:

composer require hermawan/codeigniter4-datatables

installation manual

just download here https://github.com/hermawanramadhan/Code...s/releases
add download dependency
- this library require php-sql-parser. download here https://github.com/greenlion/PHP-SQL-Parser

rename downloaded library to
- php-sql-parser
- codeigniter4-datatables
then placed it let say to app/ThirdParty

and then add namespace to $psr4

PHP Code:

$psr4 = [
        APP_NAMESPACE => APPPATH, // For custom app namespace
        'Config'      => APPPATH . 'Config',
        'PHPSQLParser'      => APPPATH . 'ThirdParty/php-sql-parser/src/PHPSQLParser', //  <-- namespace for php-sql-parser 
        'Hermawan\DataTables'   => APPPATH .'ThirdParty/codeigniter4-datatables/src', // <-- namespace for this library
    ]; 


Example Controller code

code is short and so easy. just use build-in CodeIgniter4 Query Builder

PHP Code:

<?php namespace App\Controllers;

use \CodeIgniter\Controller;
use \Hermawan\DataTables\DataTable;

class Customers extends Controller
{
    public function index()
    {
        return view('customers_view');
    }

    public function ajaxDataTables()
    {
        $db = db_connect();
        $builder = $db->table('customers')->select('firstName, lastName, phone, address, city, country');
        
        return DataTable::of($builder)->toJson();
    }
}

?>

yeah. so many datatable library available on github but I think this will be easiest. because we use powerful build-in CodeIgniter4 query builder.

Thanks
Regards.
Hermawan
https://hermawan.dev