kcy/dynamic-datatables

A little work to create dynamic tables from different projects

dev-master 2020-07-27 07:55 UTC

MIT

• Kubilay Cagri Yildirim

README

Installing

This package can be installed with composer:

composer require kcy/dynamic-datatables

app\config.php add line ---> Kcy\DynamicDatatables\DatatablesKcyServiceProvider::class,

Requirements

• PHP 5.5+ or PHP 7+
• Composer

Usage

$table_cols = ["col_name1","col_name2"];
$sql = "select * from table_name";
$servername = "localhost";
$dbname = "db_name";
$dsn = "mysql:host=" . $servername . ";dbname=" . $dbname;
$user = 'user_name';
$password = 'user_pass';

$pdo = new ConnectionDB($dsn, $user, $password);
$result = $pdo->sqlExec($sql);
$dt_generator = new DatatableGenerator();
return $dt_generator->simpleTableGenerate($table_cols, $result);