• 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
server-side DataTables Library for CodeIgniter4

#1
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
Reply

#2
Hey, good work.
Thanks for sharing and luck.
Reply

#3
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.

   
Reply

#4
(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.
Reply


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.