<?php
require_once('public/generate-table.php');

$table=new Table();
$sql="SELECT id,name, `tambon`, `amphoe`,'' insert_col, `changwat` FROM `school` where 1 __w__";
$sql_cnt="SELECT count(*) cnt FROM `school` where 1 __w__";
$field=$db->getFieldFromSql($sql);

unset($field['id']);//ซ่อน Column id
$field['insert_col']['label']='Column เพิ่มเติม';

$table->addField($field);

$data=$db->getDataFromSql($sql);
$rows=$db->getRowsFromSql($sql_cnt);
foreach($data as $i => $row){
    $data[$i]['insert_col']='ข้อมูลเพิ่มเติม';
}

$table->data=$data;
$table->rows=$rows;

echo $table->create();