การสร้างตารางแสดงข้อมูล
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] => 1190400044
[name] => อัสกีรีน (บ้านคลองทุเรียน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 1190400045
[name] => ดารุตตักวา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 1190400046
[name] => บ้านปลักผอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 1190400047
[name] => ดารุโอรูป
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 1190400048
[name] => นูรุลเอี๊ยะซาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 1190400049
[name] => บ้านหมอคง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 1190400050
[name] => ทุ่งแหล (ดารุลอิบาดะห์)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 1190400051
[name] => ดารุลฮิจเราะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 1190400052
[name] => ประกอบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 1190400053
[name] => พรุหวา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 1190400054
[name] => นูรุลอีควะห์ (บ้านหนำนา)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 1190400055
[name] => บ้านโหม่ย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 1190400056
[name] => นูรุลฮิดายะห์ (บ้านสบ๊อง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 1190400057
[name] => บ้านประกอบออก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 1190400058
[name] => บ้านใหม่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 1190400059
[name] => บ้านลำไพล (ดารุลอามาน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 1190400060
[name] => บาโร๊ะสีตี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1190400061
[name] => บ้านทีอ้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1190400062
[name] => ดารุนมุสตากีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1190400063
[name] => นูรลตียะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1190400064
[name] => นูรุลอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1190400065
[name] => นูรุลมุตตากีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1190400066
[name] => กอมารุลญันน๊ะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1190400067
[name] => สถานีเทพา ดารุลสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1190400069
[name] => เกาะครก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1190400070
[name] => บ้านจาเราะบีสู
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1190400071
[name] => นูรุลอิฮซาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1190400072
[name] => บ้านกระอาน (ก่อเร๊าะอัน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1190400073
[name] => ดารุนอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1190400074
[name] => บ้านป่าแก่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1190400075
[name] => บิรุจเราะห์มะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1190400076
[name] => ทุ่งโดน (นุรุลยากีน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 1190400077
[name] => ดารุดดีนียะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 1190400078
[name] => บ้านท่าม่วง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 1190400079
[name] => บ้านคลองขุด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1190400080
[name] => โคกสัก (นูยูมุลฮูดาย์)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1190400081
[name] => พระพุทธ (ดารุลญันนะฮ์)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1190400082
[name] => ฟูหลานหลนนาอีม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1190400083
[name] => มูฮัมมาดียะฮ์ (บ้านป่าไม้ไผ่)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1190400085
[name] => ยามีดลนาอีม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1190400086
[name] => นูรุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1190400087
[name] => นุรนฮูดาอิบาด๊ะอัลเลาะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1190400088
[name] => ปู่เหลาลู่นัง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1190400089
[name] => อิสมาอิสลียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1190400090
[name] => หนองสาย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1190400091
[name] => มุตมาเอ็นน๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1190400092
[name] => นูรุนอิสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1190400093
[name] => ป่าโอน (นี้หม๋ง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1190400094
[name] => มูฮำมาดียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1190400095
[name] => ตักวาอัลเลาะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1190400096
[name] => ตาแปด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1190400097
[name] => บ้านคลองควาย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1190400098
[name] => นูรุลอีมาน(บ้านพรุบัว)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1190400099
[name] => น่าจวก
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1190400100
[name] => สะบ้าย้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1190400101
[name] => นะห์ลอตุลอิสลามียะฮ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1190400102
[name] => ดารุลอามาน (ควนแร่)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1190400103
[name] => นูรุลตักวา (บ้านควนรามู)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1190400104
[name] => มีพตาฮูดดีนยาเร๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1190400105
[name] => บ้านน้ำค้าง (โมง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1190400106
[name] => ซีอารุลอิสลาม (บ้านควนหรันเหนือ)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1190400107
[name] => บุกอาตุนนูร์ (บ้านโคกหญ้าคา)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1190400108
[name] => บ้านรามัย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1190400109
[name] => บ้านแอและ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1190400110
[name] => นูรุลฮูดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1190400111
[name] => บ้านห้วยเต่า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1190400112
[name] => นูรุลอิสลามมียะร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1190400113
[name] => สาไหน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1190400114
[name] => มูอาบาดาตีมะมุด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1190400115
[name] => เกาะแดง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1190400116
[name] => บ้านเมาะลาแต
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1190400117
[name] => ดารุสสลาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1190400118
[name] => ดารุสสลามโคกสิเหรง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1190400119
[name] => นูรุลอิฮสาน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1190400120
[name] => นูรุดดีน (บ้านล่องควน)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 1190400121
[name] => กียามุดดีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1190400122
[name] => นูรุลฮีดายะห์ (บาโงฆูติง)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1190400123
[name] => บ้านวังโอะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1190400124
[name] => โม๊ะหนี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1190400125
[name] => ปายาสะหมุด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1190400126
[name] => มูเนาวรตูลฮูดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1190400127
[name] => ฟูตูฮูลอารีฟีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1190400128
[name] => บ้านช่างนุ้ย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1190400129
[name] => ยาบัลบารอการ์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1190400130
[name] => เปียน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1190400131
[name] => ซาฟีนาตุลดีนียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1190400132
[name] => บ้านปายอจง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1190400133
[name] => สามัคคีศาสน์วิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1190400134
[name] => บ้านเพ็งญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1190400135
[name] => ดารุนนาอิม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1190400136
[name] => ยามาอาตุลคอยรียะห์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1190400137
[name] => บ้านบาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1190400138
[name] => บ้านสะกอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1090550389
[name] => โรงเรียนบ้านโคกแห้ว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1090550395
[name] => โรงเรียนวัดทุ่งโตนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1090550421
[name] => โรงเรียนบ้านเกาะน้ำรอบ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1090550423
[name] => โรงเรียนบ้านแม่ทอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1090550425
[name] => โรงเรียนวัดท่าเมรุ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1090550428
[name] => โรงเรียนวัดบางหยี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1090550463
[name] => โรงเรียนบ้านแหลมจาก (รักเมืองไทย ๒๗)
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)