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

Hey, good work.
Thanks for sharing and luck.

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.

   

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.

[quote pid="386126" dateline="1618731056"]
awesome bro,...

I want to ask, why if use 'orderBy' , the sorting error

thanks
[/quote]

Thanks,

question: Do you have a library that uses server-side for searchPanes or searchBuilder, these are the examples:
https://datatables.net/extensions/search...imple.html
https://datatables.net/extensions/search...imple.html

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

good

Codeigniter First, Codeigniter Then You!!

yekrinaDigitals

Great library. I'm using it now.
Thanks

Documentation 404 Error Page Not Found!

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

This may be the correct link to the documentation:
https://codeigniter4-datatables.hermawan.dev/