query($query);
if (!empty($results)) {
print "
Web sites summary
\n";
print '
' . "\n";
print "| Website | Unique visitors | Total visits |
|---|
\n";
foreach ($results as $row) {
print "| " . $row["site"] . " | " . $row["visitors"]
. " | " . $row["visits"] . " |
\n";
}
print "
\n";
} else {
print "No results\n";
}
}
$dbh = new PDO('sqlite:../db/visitors.db');
#$dbh = new PDO('sqlite:visitors.db');
if (!$dbh) {
print "No database available\n";
} else {
$query = "select * from summary order by visitors desc";
show_summary_table($dbh, $query);
}
?>