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()));
}
}