การสร้างตารางแสดงข้อมูล
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] => 9961900101
[name] => สำนักงานพระพุทธศาสนาจังหวัดสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 9931900101
[name] => โรงเรียนอบจ.สงขลาพิทยานุสรณ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 9920901101
[name] => มมร.ศูนย์การศึกษาสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 9920900601
[name] => โรงเรียนตำรวจตระเวนชายแดนมหาราช ๑
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 9920900501
[name] => โรงเรียนเทพพิทยาภานุมาศ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 9912900102
[name] => ทัณฑสถานหญิงสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 9912900101
[name] => ทัณฑสถานบำบัดพิเศษสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 9911900401
[name] => เรือนจำอำเภอนาทวี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 9911900103
[name] => เรือนจำจังหวัดสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 9911900102
[name] => เรือนจำกลางสงชลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 9911900101
[name] => เรือนจำกลางสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 90030000
[name] => สพป.สงขลา เขต 3
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 90020000
[name] => สพป.สงขลา เขต 2
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 90010000
[name] => สพป.สงขลา เขต 1
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 5090010001
[name] => วิทยาลัยพยาบาลบรมราชชนนี สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 7290064316
[name] => โรงเรียนพลเอกนวล-คุณหญิงบานชื่น จันทร์ตรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 7090111401
[name] => โรงเรียนมหาปัญญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1290100005
[name] => สกร.ตำบลทุ่งหมอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1290030010
[name] => สกร.ตำบลจะโหนง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1290030011
[name] => สกร.ตำบลคู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1290030012
[name] => สกร.ตำบลแค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1290030013
[name] => สกร.ตำบลคลองเปียะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1290030014
[name] => สกร.ตำบลตลิ่งชัน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1290040001
[name] => สกร.ตำบลนาทวี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1290040002
[name] => สกร.ตำบลฉาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1290040003
[name] => สกร.ตำบลนาหมอศรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1290040004
[name] => สกร.ตำบลคลองทราย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1290040005
[name] => สกร.ตำบลปลักหนู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1290040006
[name] => สกร.ตำบลท่าประดู่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1290040007
[name] => สกร.ตำบลสะท้อน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1290040008
[name] => สกร.ตำบลทับช้าง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1290040009
[name] => สกร.ตำบลประกอบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 1290040010
[name] => สกร.ตำบลคลองกวาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 1290050001
[name] => สกร.ตำบลเทพา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 1290050002
[name] => สกร.ตำบลปากบาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1290050003
[name] => สกร.ตำบลเกาะสะบ้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1290050004
[name] => สกร.ตำบลลำไพล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1290050005
[name] => สกร.ตำบลท่าม่วง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1290050006
[name] => สกร.ตำบลวังใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1290050007
[name] => สกร.ตำบลสะกอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1290060001
[name] => สกร.ตำบลสะบ้าย้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1290060002
[name] => สกร.ตำบลทุ่งพอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1290060003
[name] => สกร.ตำบลเปียน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1290060004
[name] => สกร.ตำบลบ้านโหนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1290060005
[name] => สกร.ตำบลจะแหน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1290060006
[name] => สกร.ตำบลคูหา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1290060007
[name] => สกร.ตำบลเขาแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1290060008
[name] => สกร.ตำบลบาโหย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1290060009
[name] => สกร.ตำบลธารคีรี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1290070001
[name] => สกร.ตำบลระโนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1290070002
[name] => สกร.ตำบลคลองแดน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1290070003
[name] => สกร.ตำบลตะเครียะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1290070004
[name] => สกร.ตำบลท่าบอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1290070005
[name] => สกร.ตำบลบ้านใหม่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1290070006
[name] => สกร.ตำบลบ่อตรุ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1290070007
[name] => สกร.ตำบลปากแตระ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1290070008
[name] => สกร.ตำบลพังยาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1290070009
[name] => สกร.ตำบลระวะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1290070010
[name] => สกร.ตำบลวัดสน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1290070011
[name] => สกร.ตำบลบ้านขาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1290070012
[name] => สกร.ตำบลแดนสงวน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1290080001
[name] => สกร.ตำบลเกาะใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1290080002
[name] => สกร.ตำบลโรง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1290080003
[name] => สกร.ตำบลเชิงแส
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1290080004
[name] => สกร.ตำบลกระแสสินธุ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1290090001
[name] => สกร.ตำบลกำแพงเพชร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1290090002
[name] => สกร.ตำบลท่าชะมวง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1290090003
[name] => สกร.ตำบลคูหาใต้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1290090004
[name] => สกร.ตำบลควนรู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1290090009
[name] => สกร.ตำบลเขาพระ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1290100001
[name] => สกร.อำเภอสะเดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1290100002
[name] => สกร.ตำบลปริก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1290100003
[name] => สกร.ตำบลพังลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1290100004
[name] => สกร.ตำบลสำนักแต้ว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1290140002
[name] => สกร.ตำบลท่าช้าง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 199
[name] => ศธจ.สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1490120319
[name] => วิทยาลัยชุมชนสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1490119701
[name] => มหาวิทยาลัยเทคโนโลยีราชมงคลศรีวิชัย วิทยาเขตสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1490101210
[name] => สถาบันบัณฑิตพัฒนบริหารศาสตร์ วิทยาเขตหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1390100151
[name] => วิทยาลัยอาชีวศึกษาออมสินสมโภช ๙๙ ปี วิทยานุสรณ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1390100116
[name] => วิทยาลัยเทคโนโลยีหาดใหญ่บริหารธุรกิจสากล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1390100081
[name] => วิทยาลัยเทคโนโลยีส่องแสงพณิชยการ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1390100034
[name] => โรงเรียนบุสตานุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1390100014
[name] => โรงเรียนเทคโนโลยีพณิชยการสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1390100011
[name] => วิทยาลัยเทคโนโลยีวชิราโปลีสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1290160004
[name] => สกร.ตำบลคลองหลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1290160003
[name] => สกร.ตำบลโคกม่วง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1290160002
[name] => สกร.ตำบลทุ่งลาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1290160001
[name] => สกร.ตำบลคลองหอยโข่ง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1290150011
[name] => สกร.ตำบลม่วงงาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1290150010
[name] => สกร.ตำบลบางเขียด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1290150009
[name] => สกร.ตำบลหัวเขา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1290150008
[name] => สกร.ตำบลป่าขาด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1290150007
[name] => สกร.ตำบลปากรอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1290150006
[name] => สกร.ตำบลชะแล้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1290150005
[name] => สกร.ตำบลวัดขนุน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1290150004
[name] => สกร.ตำบลรำแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1290150003
[name] => สกร.ตำบลทำนบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1290150002
[name] => สกร.ตำบลสทิงหม้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1290150001
[name] => สกร.ตำบลชิงโค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)