การสร้างตารางแสดงข้อมูล
Code
ผลลัพธ์
Code
<?php
require_once('/var/www/html/framework/public/generate-table.php');
$table=new Table();
$sql="SELECT id,name, `tambon`, `amphoe`, `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['last']['fix']="<nobr><a class='btn btn-info btn-sm btn_load_screen' href='?act=edit&id={id}'>แก้ไข</a>
<a class='btn btn-danger btn-sm btn_load_screen' href='?act=delete&id={id}'>ลบ</a>
<a class='btn btn-info btn-sm btn_load_screen' href='?act=custom&id={id}'>อื่นๆ</a>
<a class='btn btn-info btn-sm btn_load_screen' href='?act=custom&id={id}'><i class='fa fa-edit' title='แก้ไข'></i></a></nobr>";
$table->addField($field);
$f=['id2' => ['name'=>'id2','label'=>'xxxxx','fix'=>"<nobr><a class='btn btn-info btn-sm btn_load_screen' href='?act=edit&id={id}'>แก้ไข</a>
<a class='btn btn-danger btn-sm btn_load_screen' href='?act=delete&id={id}'>ลบ</a>
<a class='btn btn-info btn-sm btn_load_screen' href='?act=custom&id={id}'>อื่นๆ</a>
<a class='btn btn-info btn-sm btn_load_screen' href='?act=custom&id={id}'><i class='fa fa-edit' title='แก้ไข'></i></a></nobr>"]];
$table->addField($f);
$data=$db->getDataFromSql($sql);
$rows=$db->getRowsFromSql($sql_cnt);
$table->data=$data;
$table->rows=$rows;
echo $table->create();