Requirements
CodeIgniter 4.x
jQuery DataTables v1.10.x
Installing using composer
composer require hermawan/codeigniter4-datatables
Simple Initializing
use \Hermawan\DataTables\DataTable;
public function basic()
{
$db = db_connect();
$builder = $db->table('customers')->select('customerNumber, customerName, phone, city, country, postalCode');
return DataTable::of($builder)->toJson();
}
$(document).ready(function() {
$('#table').DataTable({
processing: true,
serverSide: true,
ajax: '/ajax-datatable/basic'
});
});