การสร้างตารางแสดงข้อมูล
Code
ผลลัพธ์
Code
<?php
require_once('/var/www/html/framework/public/generate-table.php');
$table=new Table();
$sql="select s.id,s.name,s.kind,s.area,s.tambon,s.amphoe
from school s where 1 __w__ group by s.id order by s.name2";
$sql_cnt="SELECT count(*) cnt FROM `school` s where 1 __w__";
$field=$db->getFieldFromSql($sql);
$table->addField($field);
$f=['id2' => ['name'=>'id2','label'=>'xxxxx','fix'=>"<input name='id2[{id}]' value='{name}'>"]];
$table->addField($f);
$data=$db->getDataFromSql($sql);
echo '<pre>';print_r($data);
$rows=$db->getRowsFromSql($sql_cnt);
$table->data=$data;
$table->rows=$rows;
echo $table->create();Array
(
[0] => Array
(
[id] => 1290011000
[name] => โรงเรียนผู้ใหญ่บริหารธุรกิจวิทยาสงลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 1290020001
[name] => สกร.ตำบลจะทิ้งพระ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 1290020002
[name] => สกร.ตำบลกระดังงา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 1290020003
[name] => สกร.ตำบลสนามชัย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 1290020004
[name] => สกร.ตำบลดีหลวง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 1290020005
[name] => สกร.ตำบลชุมพล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 1290020006
[name] => สกร.ตำบลคลองรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 1290020007
[name] => สกร.ตำบลคูขุด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 1290020008
[name] => สกร.ตำบลท่าหิน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 1290020009
[name] => สกร.ตำบลวัดจันทร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 1290020010
[name] => สกร.ตำบลบ่อแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 1290020011
[name] => สกร.ตำบลบ่อดาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 1290030001
[name] => สกร.ตำบลบ้านนา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 1290030002
[name] => สกร.ตำบลป่าชิง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 1290030003
[name] => สกร.ตำบลสะพานไม้แก่น
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 1290030004
[name] => สกร.ตำบลสะกอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 1290030005
[name] => สกร.ตำบลนาหว้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1290030006
[name] => สกร.ตำบลนาทับ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1290030007
[name] => สกร.ตำบลน้ำขาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1290030008
[name] => สกร.ตำบลขุนตัดหวาย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1290030009
[name] => สกร.ตำบลท่าหมอไทร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1290030010
[name] => สกร.ตำบลจะโหนง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1290030011
[name] => สกร.ตำบลคู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1290030012
[name] => สกร.ตำบลแค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1290030013
[name] => สกร.ตำบลคลองเปียะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1290030014
[name] => สกร.ตำบลตลิ่งชัน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1290040001
[name] => สกร.ตำบลนาทวี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1290040002
[name] => สกร.ตำบลฉาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1290040003
[name] => สกร.ตำบลนาหมอศรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1290040004
[name] => สกร.ตำบลคลองทราย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1290040005
[name] => สกร.ตำบลปลักหนู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1290040006
[name] => สกร.ตำบลท่าประดู่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 1290040007
[name] => สกร.ตำบลสะท้อน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 1290040008
[name] => สกร.ตำบลทับช้าง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 1290040009
[name] => สกร.ตำบลประกอบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1290040010
[name] => สกร.ตำบลคลองกวาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1290050001
[name] => สกร.ตำบลเทพา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1290050002
[name] => สกร.ตำบลปากบาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1290050003
[name] => สกร.ตำบลเกาะสะบ้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1290050004
[name] => สกร.ตำบลลำไพล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1290050005
[name] => สกร.ตำบลท่าม่วง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1290050006
[name] => สกร.ตำบลวังใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1290050007
[name] => สกร.ตำบลสะกอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1290060001
[name] => สกร.ตำบลสะบ้าย้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1290060002
[name] => สกร.ตำบลทุ่งพอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1290060003
[name] => สกร.ตำบลเปียน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1290060004
[name] => สกร.ตำบลบ้านโหนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1290060005
[name] => สกร.ตำบลจะแหน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1290060006
[name] => สกร.ตำบลคูหา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1290060007
[name] => สกร.ตำบลเขาแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1290060008
[name] => สกร.ตำบลบาโหย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1290060009
[name] => สกร.ตำบลธารคีรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1290070001
[name] => สกร.ตำบลระโนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1290070002
[name] => สกร.ตำบลคลองแดน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1290070003
[name] => สกร.ตำบลตะเครียะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1290070004
[name] => สกร.ตำบลท่าบอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1290070005
[name] => สกร.ตำบลบ้านใหม่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1290070006
[name] => สกร.ตำบลบ่อตรุ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1290070007
[name] => สกร.ตำบลปากแตระ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1290070008
[name] => สกร.ตำบลพังยาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1290070009
[name] => สกร.ตำบลระวะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1290070010
[name] => สกร.ตำบลวัดสน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1290070011
[name] => สกร.ตำบลบ้านขาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1290070012
[name] => สกร.ตำบลแดนสงวน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1290080001
[name] => สกร.ตำบลเกาะใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1290080002
[name] => สกร.ตำบลโรง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1290080003
[name] => สกร.ตำบลเชิงแส
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1290080004
[name] => สกร.ตำบลกระแสสินธุ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1290090001
[name] => สกร.ตำบลกำแพงเพชร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1290090002
[name] => สกร.ตำบลท่าชะมวง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1290090003
[name] => สกร.ตำบลคูหาใต้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1290090004
[name] => สกร.ตำบลควนรู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1290090009
[name] => สกร.ตำบลเขาพระ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1290100001
[name] => สกร.อำเภอสะเดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1290100002
[name] => สกร.ตำบลปริก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 1290100003
[name] => สกร.ตำบลพังลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1290100004
[name] => สกร.ตำบลสำนักแต้ว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1290100005
[name] => สกร.ตำบลทุ่งหมอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1290100006
[name] => สกร.ตำบลท่าโพธิ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1290100007
[name] => สกร.ตำบลปาดังเบซาร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1290100008
[name] => สกร.ตำบลสำนักขาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1290100009
[name] => สกร.ตำบลเขามีเกียรติ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1290110001
[name] => สกร.ตำบลหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1290110002
[name] => สกร.ตำบลควนลัง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1290110003
[name] => สกร.ตำบลคูเต่า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1290110004
[name] => สกร.ตำบลคอหงส์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1290110005
[name] => สกร.ตำบลคลองแห
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1290110007
[name] => สกร.ตำบลคลองอู่ตะเภา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1290110008
[name] => สกร.ตำบลฉลุง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1290110011
[name] => สกร.ตำบลทุ่งใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1290110012
[name] => สกร.ตำบลทุ่งตำเสา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1290110013
[name] => สกร.ตำบลท่าข้าม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1290110014
[name] => สกร.ตำบลน้ำน้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1290110016
[name] => สกร.ตำบลบ้านพรุ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1290110018
[name] => สกร.ตำบลพะตง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1290111000
[name] => โรงเรียนผู้ใหญ่วัดโคกสมานคุณ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1290120001
[name] => สกร.ตำบลนาหม่อม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1290120002
[name] => สกร.ตำบลพิจิตร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1290120003
[name] => สกร.ตำบลทุ่งขมิ้น
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1290120004
[name] => สกร.ตำบลคลองหรัง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)