การสร้างตารางแสดงข้อมูล
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] => 1290130001
[name] => สกร.ตำบลรัตภูมิ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 1290130002
[name] => สกร.ตำบลควนโส
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 1290130003
[name] => สกร.ตำบลห้วยลึก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 1290130004
[name] => สกร.ตำบลบางเหรียง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 1290140001
[name] => สกร.ตำบลบางกล่ำ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 1290140002
[name] => สกร.ตำบลท่าช้าง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 1290140003
[name] => สกร.ตำบลแม่ทอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 1290140004
[name] => สกร.ตำบลบ้านหาร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 1290150001
[name] => สกร.ตำบลชิงโค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 1290150002
[name] => สกร.ตำบลสทิงหม้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 1290150003
[name] => สกร.ตำบลทำนบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 1290150004
[name] => สกร.ตำบลรำแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 1290150005
[name] => สกร.ตำบลวัดขนุน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 1290150006
[name] => สกร.ตำบลชะแล้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 1290150007
[name] => สกร.ตำบลปากรอ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 1290150008
[name] => สกร.ตำบลป่าขาด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 1290150009
[name] => สกร.ตำบลหัวเขา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1290150010
[name] => สกร.ตำบลบางเขียด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1290150011
[name] => สกร.ตำบลม่วงงาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1290160001
[name] => สกร.ตำบลคลองหอยโข่ง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1290160002
[name] => สกร.ตำบลทุ่งลาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1290160003
[name] => สกร.ตำบลโคกม่วง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1290160004
[name] => สกร.ตำบลคลองหลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1390100011
[name] => วิทยาลัยเทคโนโลยีวชิราโปลีสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1390100014
[name] => โรงเรียนเทคโนโลยีพณิชยการสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1390100034
[name] => โรงเรียนบุสตานุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1390100081
[name] => วิทยาลัยเทคโนโลยีส่องแสงพณิชยการ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1390100116
[name] => วิทยาลัยเทคโนโลยีหาดใหญ่บริหารธุรกิจสากล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1390100151
[name] => วิทยาลัยอาชีวศึกษาออมสินสมโภช ๙๙ ปี วิทยานุสรณ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1490101210
[name] => สถาบันบัณฑิตพัฒนบริหารศาสตร์ วิทยาเขตหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1490119701
[name] => มหาวิทยาลัยเทคโนโลยีราชมงคลศรีวิชัย วิทยาเขตสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1490120319
[name] => วิทยาลัยชุมชนสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 199
[name] => ศธจ.สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 0000000000
[name] => โรงเรียนทดสอบ.
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 00900001
[name] => สพม.สงขลา สตูล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1090550024
[name] => โรงเรียนบ้านทุ่งจัง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1090550033
[name] => โรงเรียนบ้านคลองเปล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1090550073
[name] => โรงเรียนบ้านมหาการ - เฉียงพง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1090550097
[name] => โรงเรียนวัดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1090550108
[name] => โรงเรียนวัดบางหรอด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1090550132
[name] => โรงเรียนบ้านพังเภา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1090550150
[name] => โรงเรียนบ้านไสท้อน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1090550154
[name] => โรงเรียนบ้านกองอิฐ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1090550162
[name] => โรงเรียนบ้านทุ่งมะขาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1090550260
[name] => โรงเรียนบ้านควนไม้ไผ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1090550295
[name] => โรงเรียนอายุรกิจโกศล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1190100133
[name] => โรงเรียนบัวหลวง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1190100138
[name] => โรงเรียนชุมชนศึกษาอัล-ฟุรกอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1190100149
[name] => โรงเรียนเตรียมบัณฑิตพิชชาลัย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1190100151
[name] => วิทยาลัยอาชีวศึกษาออมสินสมโภช ๙๙ ปี วิทยานุสรณ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1190100160
[name] => โรงเรียนพัฒนปัญญา มัสยิดควนสันติ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1190100166
[name] => โรงเรียนซูลัมดารูลอามาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1190100309
[name] => โรงเรียนแสงใหม่วิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1190100310
[name] => โรงเรียนมูหัมมาดีย๊ะต์วิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1190100312
[name] => โรงเรียนอนุบาลเด็กน่ารัก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1190100324
[name] => อิรชาดุลอิสลามีย๊ะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1190100327
[name] => มัธยมหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1190100328
[name] => ส่องแสงอนุสรณ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1190200005
[name] => เลิศปัญญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1190200007
[name] => เลิศคณิต 2
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1190200010
[name] => สอนภาษาอีซี่เวย์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1190200013
[name] => หาดใหญ่วิชาการบริบาล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1190200015
[name] => กวดวิชาขวัญเกื้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1190200020
[name] => กวดวิชาสหวิทยาสัมฤทธิ์ผล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1190200021
[name] => ศิลปศาสตร์การป้องกันตัวไทยหัตถยุทธ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1190200026
[name] => ภาษาคิด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1190200028
[name] => สอนภาษาต่างประเทศสวัสดี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1190200029
[name] => สหศึกษาวิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1190200033
[name] => ธิติพัฒน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1190200034
[name] => กวดวิชาอาจารย์ปิง หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1190200037
[name] => พัฒนาภาษาอังกฤษสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1190200038
[name] => กวดวิชาเอสซีซีอี หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1190200039
[name] => กวดวิชาดำรงวัจน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1190200041
[name] => ศิลโปไทย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1190200046
[name] => กวดวิชาปัญญาพิวรรธ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 1190200048
[name] => เด็กดี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1190200051
[name] => พูลสวัสดิ์ยานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1190200055
[name] => สอนภาษาธิชา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1190200056
[name] => ดนตรียามาฮ่าป๊อบปูล่ามิวสิค หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1190200058
[name] => ปัญญารัตน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1190200060
[name] => ส่งเสริมสุขภาพแผนไทย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1190200064
[name] => คอมพิวเตอร์และการออกแบบมัลติมีเดีย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1190200068
[name] => สอนภาษาวิชั่นส์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1190200069
[name] => โรงเรียนนานาชาติสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1190200070
[name] => กวดวิชาดีเลิศ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1190200072
[name] => กวดวิชาและวิชาชีพประตูพิเศษ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1190200073
[name] => แปซิฟิคโลกดนตรีและศิลปะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1190200075
[name] => ต้นแบบเด็กศิลป์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1190200078
[name] => กวดวิชาอาจารย์นวรัตน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1190200082
[name] => กวดวิชาเก่งกล้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1190200083
[name] => กวดวิชาดังใจ หาดใหญ่ 2
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1190200084
[name] => กวดวิชาภาษาจีนอีซี่ ไชนีส
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1190200087
[name] => พัฒนาทักษะสงแก้ว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1190200088
[name] => ดนตรีเคพีเอ็น หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1190200090
[name] => กวดวิชาบ้านครูจอย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1190200093
[name] => กวดวิชาบ้านครูออ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1190200094
[name] => สอนภาษาอิงลิชคอนเนอร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1190200095
[name] => กวดวิชา อรรณพ กิตติภูมิ หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1190200097
[name] => ภาษาจินตวิช
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1190200098
[name] => กวดวิชากรนภัส
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)