$S->banner = "<h1>Example Four</h1>"; // This is the banner. $S->defaultCss = "../css/style.css"; $sql = "create table if not exists $S->masterdb.test (`name` varchar(20), `date` datetime, `lasttime` datetime)"; $S->query($sql); for($i=0; $i<5; $i++) { $name = "A-name$i"; $S->query("insert into $S->masterdb.test (name, date, lasttime) values('$name', now(), now())"); } $sql = "select * from $S->masterdb.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 dbTables($S); $tbl = $T->maketable($sql, ['attr'=>['id'=>'table1', 'border'=>'1']])[0]; $S->query("drop table $S->masterdb.test"); [$top, $footer] = $S->getPageTopBottom(); echo <<<EOF $top <hr> <p>Here are some entries from the 'test' table.</p> $tbl <hr> <a target="_top" href="/newspapers?url=example1.php">Example1</a><br> <a target="_top" href="/newspapers?url=example2.php">Example2</a><br> <a target="_top" href="/newspapers?url=example3.php">Example3</a><br> <a target="_top" href="/newspapers?url=example4.php">Example4</a><br> <a target="_top" href="/newspapers?url=example5.php">Example5</a><br> <a target="_top" href="/newspapers?url=example6.php">Example6</a><br> <a target="_top" href="/newspapers?url=../phpinfo.php">PHPINFO</a> <hr> $footer EOF;

title = "Example 4"; // The $S->banner = "<h1>Example Four</h1>"; // This is the banner. $S->defaultCss = "../css/style.css"; $sql = "create table if not exists $S->masterdb.test (`name` varchar(20), `date` datetime, `lasttime` datetime)"; $S->query($sql); for($i=0; $i<5; $i++) { $name = "A-name$i"; $S->query("insert into $S->masterdb.test (name, date, lasttime) values('$name', now(), now())"); } $sql = "select * from $S->masterdb.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 dbTables($S); $tbl = $T->maketable($sql, ['attr'=>['id'=>'table1', 'border'=>'1']])[0]; $S->query("drop table $S->masterdb.test"); [$top, $footer] = $S->getPageTopBottom(); echo <<<EOF $top <hr> <p>Here are some entries from the 'test' table.</p> $tbl <hr> <a target="_top" href="/newspapers?url=example1.php">Example1</a><br> <a target="_top" href="/newspapers?url=example2.php">Example2</a><br> <a target="_top" href="/newspapers?url=example3.php">Example3</a><br> <a target="_top" href="/newspapers?url=example4.php">Example4</a><br> <a target="_top" href="/newspapers?url=example5.php">Example5</a><br> <a target="_top" href="/newspapers?url=example6.php">Example6</a><br> <a target="_top" href="/newspapers?url=../phpinfo.php">PHPINFO</a> <hr> $footer EOF;