การสร้างตารางแสดงข้อมูล
Code
ผลลัพธ์
Code
<?php
require_once('/var/www/html/framework/public/generate-table.php');
$table=new Table();
$sql="SELECT id,name, `tambon`, `amphoe`,'' insert_col, `changwat`,is_vulner FROM `school` where 1 __w__";
$sql_cnt="SELECT count(*) cnt FROM `school` where 1 __w__";
$field=$db->getFieldFromSql($sql);
$field['is_vulner']['type_search']='list';
$field['is_vulner']['list']=['0'=>'ไม่ใช่','1'=>'ใช่'];
$table->addField($field);
$data=$db->getDataFromSql($sql);
$rows=$db->getRowsFromSql($sql_cnt);
$table->data=$data;
$table->rows=$rows;
echo $table->create();