Integrate DataTable to CodeIgniter 4.
Download package using composer.
composer require nongbit/codeigniter-datatable
Open your model.
...
use Nongbit\DataTable\Traits\DataTable;
class Foo extends Model
{
use DataTable;
}
Now you can write code like this:
$builder->join('comments', 'comments.id = blogs.id', 'left')->datatables();
This will return an array like this:
Array
(
[draw] => 1
[recordsTotal] => 1000
[recordsFiltered] => 200
[data] => Array()
)