ugo/datatable

Server side datatable calls

v1.0 2021-05-03 18:29 UTC

Requires

• ugo/simpleorm: ^1.0

MIT

• Ugochukwu

README

Renders Jquery datatable in an efficient way by using server side calls for all paging, searching, ordering actions that DataTables performs on the large data set.

Installation

Installation is super easy with composer

$ composer require ugo/datatable

Usage

<?php
    require_once('vendor/autoload.php');
    $mysqli_connection = [YOUR MYSQLI CONNECTION OBJECT];
    $table             = new Datatable($mysqli_connection);
    $data              = $_REQUEST;
    $table_name        = "users";
    $filter            = " AND email = '[e-mail]'";
    $pk                = "email";
    $column            = array(
                            array( 'db' => 'username', 'dt' => 0 ),
                            array( 'db' => 'first_name', 'dt' => 1 ),
                            array( 'db' => 'last_name', 'dt' => 2 )
                            array( 'db' => 'username', 'dt' => 3,'formatter'=>function($d,$row){
                                $name = $row['first_name'];
                                return echo "<button>Edit ".$name."</button>";
                            } )
                            );
    $jquery_table = $table->generateTable($data,$table_name,$columner,$filter,$pk);
    var_dump($jquery_table);
?>