Star

CodeIgniter 4

Use CI4's database service

The Codeigniter4Adapter wraps a CI4 connection so you can keep your existing config and migrations.
<?php
// app/Controllers/Tracks.php
namespace App\Controllers;

use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\Codeigniter4Adapter;

class Tracks extends BaseController
{
    public function ajax()
    {
        $db = \Config\Database::connect();

        $dt = new Datatables(new Codeigniter4Adapter($db));
        $dt->query('Select TrackId, Name, UnitPrice from Track');

        return $this->response->setJSON(json_decode($dt->generate()));
    }
}