query($sql);
for($i=0; $i<5; $i++) {
$name = "A-name$i";
$S->query("insert into barton.test (name, date, lasttime) values('$name', now(), now())");
}
$sql = "select * from barton.test order by lasttime";
// For more information on dbTables you can look at the source or the documentation in the docs
// directory on on line at https://bartonlp.github.io/site-class/
$T = new SimpledbTables($S);
$tbl = $T->maketable($sql, ['attr'=>['id'=>'table1', 'border'=>'1']])[0];
$S->query("drop table barton.test");
echo <<
We are using the SimpledbMysqli and SimpledbTables class. We can't have \$top or \$footer. Also, isBot() and many more things are not in the SimpledbMysqli class.
$tbl