การสร้างตารางแสดงข้อมูล
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] => 1190300005
[name] => บาหังวิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 1190300006
[name] => ตัรบียะห์ตุดดีนียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 1190300007
[name] => นูรุดดีน(แสงธรรม)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 1190300008
[name] => ตัรบียาตุลอิสลามียะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 1190300010
[name] => ตะฮ์ฟีซุลกุรอาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 1190300011
[name] => ผาสุกอิสลาม (ควนมีด)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 1190300013
[name] => นิติศาสตร์อิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 1190300014
[name] => อัลมุขตารีญตุลอิสลามียะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 1190300015
[name] => อัลมะฮะดุลอิสลามียุ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 1190300016
[name] => ฮาฟีเซาะฮ์ ทรายขาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 1190300020
[name] => ตาจุดตอลีบีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 1190300021
[name] => อัรฉาดีย๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 1190300022
[name] => ดารุลอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 1190300023
[name] => ดาหรนอาหมัน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 1190300024
[name] => มุตตอลีบียะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 1190300025
[name] => ดารุลฟุรกอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 1190300026
[name] => ยาบาลุลฮูดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1190300027
[name] => อิสลาหุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1190300028
[name] => อีหยาอูลอูลูมิดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1190300029
[name] => อิสลาฮุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1190300030
[name] => อิสลามศาสนศาสตร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1190300031
[name] => อิสลามียะอัดดีนียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1190300032
[name] => ป่าเรียน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1190300033
[name] => ญามีอะตับซีรียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1190300034
[name] => ดารุสสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1190300035
[name] => เราฎอดุลอูลูม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1190300036
[name] => ท่องจำกุรอาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1190300037
[name] => นูรูลยาดีดโคกเมาหนองจูด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1190300038
[name] => มัซการ์ดอูลูมิคดีนิลอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1190300039
[name] => อัลบานาต
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1190300040
[name] => ญามิอาตุซซอลีหาต
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1190300041
[name] => คลองกลอยวิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 1190300042
[name] => มูฮัมมาดีย๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 1190300043
[name] => อะฮ์มาดียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 1190300044
[name] => แสงธรรม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1190300045
[name] => ตัรบียะตุนนาฉีอีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1190300046
[name] => อันวารุลอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1190300047
[name] => ดารุลเราะมัต
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1190300048
[name] => ดารุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1190300049
[name] => อัล-ฟุรกอนกีรออาตี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1190300050
[name] => มะฮัดตัรบียาตุลเอาลาด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1190300052
[name] => มะฮัดตัสกีเราะห์อัลอิสลามียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1190300053
[name] => นูรุลกุรอาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1190300055
[name] => ดารุลอูลุม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1190300057
[name] => ดะฮ์วาฎิดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1190300058
[name] => มัดหัดดารุสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1190300060
[name] => ดารุลกุรอ่าน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1190300061
[name] => ตะหฺฟิซซุลกุรอานเราะหฺมานียะฮฺ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1190300062
[name] => ดารุลกุรอาน อัลนิซอมียะห์ อัลอิสลามียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1190300063
[name] => มูฮัมมาดีหย๊ะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1190300064
[name] => ชูรอโคกยาง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1190300065
[name] => สันติสุข
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1190300066
[name] => ต้นมะขาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1190300068
[name] => พลีเหนือ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1190300069
[name] => ต้นท้อน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1190300070
[name] => มาฮัดยาบาลูอิห์ซานบ้านสุโสะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1190300071
[name] => มะฮัดตะห์ฟีซุลกุรอานนูรุลอิห์ซาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1190300072
[name] => นูรุลฟัจร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1190300073
[name] => ฟัจรูซซอดิก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1190300074
[name] => อัลอายูบี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1190300075
[name] => กู้วาตุลออิสลามี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1190300076
[name] => ดารุลอามาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1190300077
[name] => ตะห์ฟิซดารุซซอลีฮีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1190300078
[name] => ฮาฟีเซาะห์อัลกุรอ่านนูรุลสะอาดะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1190300079
[name] => นูรุดดีน (ซัมสุ)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1190300104
[name] => ท่ามะกรูด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1190300105
[name] => นัสรุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1190300106
[name] => เมี๊ยะยาริลอุลูม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1190300107
[name] => ตะฮฟิสกุรอาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1190300108
[name] => ดาอียะฮฺศิดดีเกาะฮฺ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1190300109
[name] => ตะห์ฟิสอัลกุรอานดารุลนิซะอ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1190300111
[name] => ตะฮ์ฟีซุลกุรอานมูฮายีรีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1190400001
[name] => บ้านคลองข่า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1190400002
[name] => ประสานสามัคคี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1190400003
[name] => ไก่อยู่หมุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 1190400004
[name] => บ้านปีก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1190400005
[name] => มะวาย์(คูแค)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1190400006
[name] => กาม่าลีหย๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1190400007
[name] => ตัรกียะฮ์ (บ้านทุ่งครก)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1190400008
[name] => คูประดู่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1190400009
[name] => เร๊าะหม๊ะ (บ้านพ้อแดง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1190400010
[name] => บ้านทุ่ง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1190400011
[name] => ปลักพ้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1190400015
[name] => ม้างอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1190400016
[name] => บ้านคลองทิง (นูรุลยากีน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1190400017
[name] => ทุ่งพระ (ท่าคลอง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1190400018
[name] => นูรุลฮูดา (บ้านสลุด)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1190400022
[name] => ละออสามัคคี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1190400023
[name] => ดารุสลาม (บ้านปากจด)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1190400024
[name] => บ้านทรายขาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1190400025
[name] => ท่าล้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1190400026
[name] => บ้านป่าระไม (ดารุลอัดฟาล)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1190400029
[name] => อิสลามธัญศึกษา (บ้านควนหัวช้าง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1190400031
[name] => บ้านบ่อโชน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1190400032
[name] => สอลาหุคดีน (บ้านปากบาง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1190400036
[name] => บ้านหัวดินใต้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1190400038
[name] => บ้านโอน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1190400041
[name] => มิฟตาฮุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1190400042
[name] => บ้านซอง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1190400043
[name] => ดารุสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)