codeigniter.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
// Codeigniter 3 usage :
//   Set config/config.app:
//   $config['composer_autoload'] = 'vendor/autoload.php';
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\CodeigniterAdapter;
class Welcome extends CI_Controller {
    public function index()
    {
        $this->load->view('welcome_message');
    }
    public function ajax()
    {
        $datatables = new Datatables(new CodeigniterAdapter);
        $datatables->query('Select film_id, title, description from film');
        echo $datatables->generate();
    }
}

codeigniter4.php

<?php

namespace App\Controllers;

use Config\Database;
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\Codeigniter4Adapter;

class Home extends BaseController
{
    public function index()
    {
        return view('welcome_message');
    }

    public function ajax()
    {
        // CI 4 builder class
        $db = Database::connect();

        $builder = $db->table('Track');
        $builder->select('TrackId, Name, UnitPrice');

        // Datatables Php Library
        $datatables = new Datatables(new Codeigniter4Adapter);

        // using CI4 Builder
        $datatables->query($builder);

        // alternatively plain sql
        // $datatables->query('Select TrackId, Name, UnitPrice from Track');

        return $this->response->setJSON($datatables->generate()->toJson());
        // or
        // echo $datatables->generate();
    }
}

laravel.php

<?php
// example route file
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\LaravelAdapter;

Route::get('/', function () {
    return view('welcome');
});

Route::get('ajax', function () {
    $datatables = new Datatables(new LaravelAdapter);
    $datatables->query('Select film_id, title, description from film');

    return $datatables->generate();
});

phalcon.php

<?php
// Define route
// ...
$router->add(
    "/", [
        "controller" => "home",
        "action" => "index"
    ]
);
$router->add(
    "/ajax", [
        "controller" => "film",
        "action" => "ajax"
    ]
);
// Define film controller
// ...
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\PhalconAdapter;
Class FilmController extends Controller {
    // ...
    public function AjaxAction() {
        $datatables = new Datatables(new PhalconAdapter($this->di, 'db'));
        $query = $this->modelsManager->createBuilder()
            ->columns('film_id, title, description')
            ->from('App\Models\Film')
            ->getQuery()
            ->getSql();
    
        $datatables->query($query['sql']);
        return $datatables->generate();
    }
    
}

prestashop.php

<?php
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\PSAdapter;
/**
 * Example for Prestashop FrontController
 */
class ModuleNameControllerNameModuleFrontController extends ModuleFrontController
{
    public function displayAjaxDatatableResults()
    {
        $dt = new Datatables(new PSAdapter([]));
        $dt->query('SELECT * FROM ' . _DB_PREFIX_ . '_table');
        return $dt->generate();
    }
}