This package can be installed with composer:
composer require kcy/dynamic-datatables
app\config.php add line ---> Kcy\DynamicDatatables\DatatablesKcyServiceProvider::class,
- PHP 5.5+ or PHP 7+
- Composer
$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);