CodeIgniter Forums
server-side DataTables Library for CodeIgniter4 - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: External Resources (https://forum.codeigniter.com/forum-7.html)
+--- Forum: Addins (https://forum.codeigniter.com/forum-13.html)
+--- Thread: server-side DataTables Library for CodeIgniter4 (/thread-78895.html)



server-side DataTables Library for CodeIgniter4 - hermawan.dev - 03-24-2021

Hello everyone.. 

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

here the link

github: 
https://github.com/hermawanramadhan/CodeIgniter4-DataTables/

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/CodeIgniter4-DataTables/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


RE: server-side DataTables Library for CodeIgniter4 - manager - 03-24-2021

Hey, good work.
Thanks for sharing and luck.


RE: server-side DataTables Library for CodeIgniter4 - llyimo1920 - 04-15-2021

It's a great library.
It's simple and elegant and i love it.

There are however an issue with documentation Edit/ Format Column. The sauce tab first arguments is specified as anonymous function instead of a column name.

[attachment=2013]


RE: server-side DataTables Library for CodeIgniter4 - hermawan.dev - 04-18-2021

(04-15-2021, 01:56 AM)llyimo1920 Wrote: It's a great library.
It's simple and elegant and i love it.

There are however an issue with documentation Edit/ Format Column. The sauce tab first arguments is specified as anonymous function instead of a column name.

Thanks. document already edited.