function __construct($table = null) { parent::__construct($table, 'array'); }
<?php // DataTables PHP library include "../../php/DataTables2 .php"; // Alias Editor classes so they are easy to use use DataTables\Editor, DataTables\Editor\Field, DataTables\Editor\Format, DataTables\Editor\Join, DataTables\Editor\Validate; /* * Example PHP implementation used for the join.html example */ $out = Editor::inst($db, 'users')->field(Field::inst('users.id'), Field::inst('users.customer'), Field::inst('users.so_date'), Field::inst('users.site'), Field::inst('sites.name'))->leftJoin('sites', 'sites.id', '=', 'users.site')->join(Join::inst('access', 'array')->join(array('id', 'user_id'), array('id', 'access_id'), 'user_access')->fields(Field::inst('id')->validator('Validate::required'), Field::inst('name'), Field::inst('qty'), Field::inst('price')))->process($_POST)->data(); // When there is no 'action' parameter we are getting data, and in this // case we want to send extra data back to the client, with the options // for the 'sites' and 'dept' select lists if (!isset($_POST['action'])) { // Get a list of sites for the `select` list $out['sites'] = $db->selectDistinct('sites', 'id as value, name as label')->fetchAll(); // Get department details $out['access'] = $db->select('access', 'id as value, name as label')->fetchAll(); } // Send it back to the client echo json_encode($out);
<?php // DataTables PHP library include "../../php/DataTables.php"; // Alias Editor classes so they are easy to use use DataTables\Editor, DataTables\Editor\Field, DataTables\Editor\Format, DataTables\Editor\Join, DataTables\Editor\Upload, DataTables\Editor\Validate; /* * Example PHP implementation used for the join.html example */ Editor::inst($db, 'users')->field(Field::inst('users.first_name'), Field::inst('users.last_name'), Field::inst('users.site')->options('sites', 'id', 'name'), Field::inst('sites.name'))->leftJoin('sites', 'sites.id', '=', 'users.site')->join(Join::inst('access', 'array')->join(array('id', 'user_id'), array('id', 'access_id'), 'user_access')->fields(Field::inst('id')->validator('Validate::required')->options('access', 'id', 'name'), Field::inst('name')))->process($_POST)->json();