$S->banner = "<h1>Example Three</h1>"; // This is the banner. $S->defaultCss = "../css/style.css"; // There is more information about the mysql functions at https://bartonlp.github.io/site-class/ or // in the docs directory. $sql = "select site, ip, agent, finger, count, created, lasttime from $S->masterdb.logagent where lasttime>=current_date() and site='Examples'"; $S->query($sql); while([$site, $ip, $agent, $finger, $count, $created, $lasttime] = $S->fetchrow('num')) { $rows .= "<tr><td>$site</td><td>$ip</td><td>$agent</td><td>$finger</td><td>$count</td><td>$created</td><td>$lasttime</td></tr>"; } // Now here is an easier way using dbTables. // 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]; [$top, $footer] = $S->getPageTopBottom(); echo <<<EOF $top <hr> <p>Here are the entries from the 'logagent' table for today.</p> <table border='1'> <thead> <tr><th>site</th><th>ip</th><th>agent</th><th>finger</th><th>count</th><th>created</th><th>lasttime</th></tr> </thead> <tbody> $rows </tbody> </table> <p>Same table but with dbTables</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 3"; // The $S->banner = "<h1>Example Three</h1>"; // This is the banner. $S->defaultCss = "../css/style.css"; // There is more information about the mysql functions at https://bartonlp.github.io/site-class/ or // in the docs directory. $sql = "select site, ip, agent, finger, count, created, lasttime from $S->masterdb.logagent where lasttime>=current_date() and site='Examples'"; $S->query($sql); while([$site, $ip, $agent, $finger, $count, $created, $lasttime] = $S->fetchrow('num')) { $rows .= "<tr><td>$site</td><td>$ip</td><td>$agent</td><td>$finger</td><td>$count</td><td>$created</td><td>$lasttime</td></tr>"; } // Now here is an easier way using dbTables. // 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]; [$top, $footer] = $S->getPageTopBottom(); echo <<<EOF $top <hr> <p>Here are the entries from the 'logagent' table for today.</p> <table border='1'> <thead> <tr><th>site</th><th>ip</th><th>agent</th><th>finger</th><th>count</th><th>created</th><th>lasttime</th></tr> </thead> <tbody> $rows </tbody> </table> <p>Same table but with dbTables</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;