การสร้างตารางแสดงข้อมูล
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] => 1190200099
[name] => กวดวิชาไอน์สไตน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[1] => Array
(
[id] => 1190200100
[name] => ดนตรีและศิลปะเมเจอร์สเกล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[2] => Array
(
[id] => 1190200101
[name] => ดนตรียามาฮ่า เซ็นทรัลเฟสติวัล หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[3] => Array
(
[id] => 1190200102
[name] => กวดวิชาดังใจ หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[4] => Array
(
[id] => 1190200103
[name] => เดอะวันอิงลิชสกูล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[5] => Array
(
[id] => 1190200105
[name] => นานาชาติบลูมส์เบอรี่-หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[6] => Array
(
[id] => 1190200143
[name] => เลิศคณิต
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[7] => Array
(
[id] => 1190200145
[name] => กวดวิชาบ้านความรู้
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[8] => Array
(
[id] => 1190200150
[name] => สงขลาพิมพ์ดีด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[9] => Array
(
[id] => 1190200152
[name] => สุรจิตรคอมพิวเตอร์สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[10] => Array
(
[id] => 1190200157
[name] => สมิหลายานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[11] => Array
(
[id] => 1190200161
[name] => เวชศาสตร์แผนไทยสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[12] => Array
(
[id] => 1190200166
[name] => สงขลาพัฒนาทักษะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[13] => Array
(
[id] => 1190200176
[name] => โรงเรียนธรรมวิทยามูลนิธิสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[14] => Array
(
[id] => 1190200182
[name] => โรงเรียนศาสน์พัฒนาวิทยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[15] => Array
(
[id] => 1190200183
[name] => นานาชาติเซาท์เทิร์น หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[16] => Array
(
[id] => 1190200185
[name] => ระโนดสอนขับรถยนต์และคอมพิวเตอร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[17] => Array
(
[id] => 1190200193
[name] => สะเดายานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[18] => Array
(
[id] => 1190200197
[name] => ทวีปัญญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[19] => Array
(
[id] => 1190200200
[name] => สมองเลิศหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[20] => Array
(
[id] => 1190200208
[name] => กวดวิชาวรวิทย์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[21] => Array
(
[id] => 1190200212
[name] => กวดวิชาวรรณสรณ์ หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[22] => Array
(
[id] => 1190200214
[name] => กวดวิชาภาษาอังกฤษเอ็นคอนเส็ปท์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[23] => Array
(
[id] => 1190200215
[name] => ดนตรีสยามกลการหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[24] => Array
(
[id] => 1190200216
[name] => ดนตรีหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[25] => Array
(
[id] => 1190200217
[name] => ศิลปะการฟ้อนรำ ลีลา-ศิลป์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[26] => Array
(
[id] => 1190200218
[name] => ดนตรีบุญลีย์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[27] => Array
(
[id] => 1190200228
[name] => หาดใหญ่ยานยนต์สหศึกษา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[28] => Array
(
[id] => 1190200230
[name] => เสริมสวยดาวสยาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[29] => Array
(
[id] => 1190200234
[name] => สอนขับรถยนต์สหยานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[30] => Array
(
[id] => 1190200235
[name] => ภาษาและคอมพิวเตอร์ อีซีซี หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[31] => Array
(
[id] => 1190200240
[name] => เต่าเพชรคอมพิวเตอร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[32] => Array
(
[id] => 1190200251
[name] => สอนขับรถยนต์คลองเรือนยานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[33] => Array
(
[id] => 1190200252
[name] => สอนขับรถยนต์สุกลการยานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[34] => Array
(
[id] => 1190200258
[name] => สยามยานยนต์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[35] => Array
(
[id] => 1190200262
[name] => สอนตัดเสื้ออารยา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[36] => Array
(
[id] => 1190200267
[name] => สอนภาษาต่างประเทศหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[37] => Array
(
[id] => 1190200275
[name] => เกียรติกุลยานยนต์สหศึกษา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[38] => Array
(
[id] => 1190200277
[name] => พัฒนาทักษะถาวรสุข
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[39] => Array
(
[id] => 1190200280
[name] => เสริมสวยคุณหญิง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[40] => Array
(
[id] => 1190200281
[name] => เสริมสวยอุราพร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[41] => Array
(
[id] => 1190200282
[name] => เสริมสวยพรทิพย์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[42] => Array
(
[id] => 1190200283
[name] => สอนภาษาซีไบรท์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[43] => Array
(
[id] => 1190200285
[name] => พัฒนศาสตร์ภาษาจีนหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[44] => Array
(
[id] => 1190200292
[name] => กวดวิชาระโนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[45] => Array
(
[id] => 1190200293
[name] => สอนภาษาอังกฤษมีฟ้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[46] => Array
(
[id] => 1190200297
[name] => คุณภาพภาษาจีนหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[47] => Array
(
[id] => 1190200298
[name] => สมาร์ทอิงลิชหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[48] => Array
(
[id] => 1190200299
[name] => อัจฉริยะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[49] => Array
(
[id] => 1190200300
[name] => สอนภาษาต่างประเทศอินลิงกัวหาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[50] => Array
(
[id] => 1190200301
[name] => เสริมสวยอินทนิน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[51] => Array
(
[id] => 1190200307
[name] => เปี่ยมปัญญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[52] => Array
(
[id] => 1190200310
[name] => การเรียนรู้คอมพิวเตอร์ไทยคอม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[53] => Array
(
[id] => 1190200316
[name] => กวดวิชาดาวนายร้อย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[54] => Array
(
[id] => 1190200320
[name] => พัฒนาทักษะรวีธีรภาพ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[55] => Array
(
[id] => 1190200325
[name] => สอนศิลปะ หอศิลป์สยาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[56] => Array
(
[id] => 1190200328
[name] => กวดวิชาไบร์ทคิดส์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[57] => Array
(
[id] => 1190200333
[name] => กวดวิชาต้นกล้า
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[58] => Array
(
[id] => 1190200335
[name] => กวดวิชายุพาวดีวิทย์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[59] => Array
(
[id] => 1190200336
[name] => สอนตัดขนสุนัขโกลมี่เพ็ท กรูมมิ่ง แอนด์ สปา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[60] => Array
(
[id] => 1190200339
[name] => ภาษาสาระสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[61] => Array
(
[id] => 1190200340
[name] => พัฒนาอัจฉริยภาพสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[62] => Array
(
[id] => 1190200341
[name] => สงขลาการบริบาล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[63] => Array
(
[id] => 1190200343
[name] => กวดวิชาม่วงงาม
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[64] => Array
(
[id] => 1190200344
[name] => วันทูวัน หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[65] => Array
(
[id] => 1190200346
[name] => สอนขับรถสงขลาสมาร์ท
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[66] => Array
(
[id] => 1190200347
[name] => กวดวิชา คณิต ๔
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[67] => Array
(
[id] => 1190200348
[name] => เสริมสวย มายด์แฮร์ ดีไซน์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[68] => Array
(
[id] => 1190200352
[name] => กวดวิชาทรัพย์ปัญญา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[69] => Array
(
[id] => 1190200353
[name] => สอนขับรถเอกชนเขาตันหยง สาขา 2 สิงหนคร
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[70] => Array
(
[id] => 1190200354
[name] => บ้านภาษาระโนด
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[71] => Array
(
[id] => 1190200355
[name] => นานชาติเซาเทิร์น หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[72] => Array
(
[id] => 1190200356
[name] => กวดวิชาณภัทรศึกษา หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[73] => Array
(
[id] => 1190200357
[name] => กวดวิชา ภนิตา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[74] => Array
(
[id] => 1190200358
[name] => ไอเดีย ไอ สปีค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[75] => Array
(
[id] => 1190200359
[name] => สอนขับรถ หาดใหญ่ คาร์ เทรนเนอร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[76] => Array
(
[id] => 1190200360
[name] => กวดวิชา เดอะ ลอร์ด คาเด็ท
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[77] => Array
(
[id] => 1190200362
[name] => กวดวิชาบ้านลดา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[78] => Array
(
[id] => 1190200363
[name] => สอนคณิตศาสตร์ และภาษาครูซีรีน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[79] => Array
(
[id] => 1190200364
[name] => กวดวิชาและสอนภาษาออเรียนโทลแบมบู สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[80] => Array
(
[id] => 1190200365
[name] => วิชาชีพสุขภาพ สปาและความงาม เนเชอรัลโซล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[81] => Array
(
[id] => 1190200367
[name] => โปรเกรสซีฟ แลงเกวจ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[82] => Array
(
[id] => 1190200368
[name] => กวดวิชาหาดใหญ่ใน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[83] => Array
(
[id] => 1190200369
[name] => กวดวิชาคณิตศาสตร์พี่ก้อ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[84] => Array
(
[id] => 1190200370
[name] => รักษ์อุบลการบริบาลสงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[85] => Array
(
[id] => 1190200371
[name] => สอนภาษาเดอะไบรท์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[86] => Array
(
[id] => 1190200372
[name] => กวดวิชาเดลอคาเดมิค
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[87] => Array
(
[id] => 1190200373
[name] => ดนตรีสยามกลการ สงขลา
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[88] => Array
(
[id] => 1190200374
[name] => สอนภาษาจีนเฉียนหย่ง
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[89] => Array
(
[id] => 1190200375
[name] => จะนะอินเตอร์บริบาล
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[90] => Array
(
[id] => 1190200376
[name] => อิงลิชโนฮาว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[91] => Array
(
[id] => 1190200384
[name] => ดนตรีคาไว หาดใหญ่
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[92] => Array
(
[id] => 1190200385
[name] => อะเบาท์มอนเทสซอริ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[93] => Array
(
[id] => 1190200386
[name] => หาดใหญ่เวชกรรมไทย
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[94] => Array
(
[id] => 1190200388
[name] => ท็อปโรบอทคิดส์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[95] => Array
(
[id] => 1190200389
[name] => กวดวิชาแอมมี่ติวเตอร์
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[96] => Array
(
[id] => 1190300001
[name] => บ้านเกาะแต้ว
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[97] => Array
(
[id] => 1190300002
[name] => อัลฟาลาฮีหย๊ะ
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[98] => Array
(
[id] => 1190300003
[name] => บ้านท่าสะอ้าน
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
[99] => Array
(
[id] => 1190300004
[name] => สถาบันอัลกุรอ่านอิบรอฮิมี
[kind] =>
[area] =>
[tambon] =>
[amphoe] =>
)
)