CodeIgniter 3
Use the framework's database driver
The
CodeigniterAdapter wraps CI3's $this->db so the library can talk to your active connection.<?php
// application/controllers/Tracks.php
defined('BASEPATH') OR exit('No direct script access allowed');
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\CodeigniterAdapter;
class Tracks extends CI_Controller
{
public function ajax()
{
$this->load->database();
$dt = new Datatables(new CodeigniterAdapter($this->db));
$dt->query('Select TrackId, Name, UnitPrice from Track');
echo $dt->generate();
}
}