hermawan/codeigniter4-datatables

Serverside Datatables library for CodeIgniter4

v0.7.2 2024-04-27 07:44 UTC

Requires

• php: >=7.3
• codeigniter4/framework: ^4
• greenlion/php-sql-parser: >=4.5

MIT

• Hermawan Ramadhan

README

Server-side Datatables library for CodeIgniter4 PHP framework CodeIgniter4-DataTables is CodeIgniter4 Library to handle server-side processing of DataTables jQuery Plugin via AJAX option by using Query Builder CodeIgniter 4

Documentation

For more complete example and demo please visit Documentation here

Requirements

• Codeigniter 4.x
• jQuery DataTables v1.10.x

Installing

Using composer

Use composer to install CodeIgniter4-DataTables into your project :

composer require hermawan/codeigniter4-datatables

Simple Initializing

Using CodeIgniter Query Builder

This is simple basic code just write DataTable::of($builder) call method toJson() for output

$builder is CodeIgniter build-in Query Builder object.

Controller :

use \Hermawan\DataTables\DataTable;

public function ajaxDatatable()
{
    $db = db_connect();
    $builder = $db->table('customers')->select('customerNumber, customerName, phone, city, country, postalCode');

    return DataTable::of($builder)->toJson();
}

Using CodeIgniter Model

You can initialize using Model instead Query Builder This is simple example basic code

Controller :

use \Hermawan\DataTables\DataTable;
use \App\Models\CustomerModel;

public function ajaxDatatable()
{
    $customerModel = new CustomerModel();
    $customerModel->select('customerNumber, customerName, phone, city, country, postalCode');

    return DataTable::of($customerModel)->toJson();
}

Javascript :

$(document).ready(function() {
    $('#table').DataTable({
        processing: true,
        serverSide: true,
        ajax: '<?php echo site_url('customers/ajaxDatatable'); ?>'
    });
});

For more complete example and demo please visit Documentation here