require_once 'classes/classGRAPH.php';
require_once 'classes/classDB.php';
$hostname = "<host>:<port>";
$username = "******";
$password = "******";
$dbname = "<database>";
$objDB = new mysql_db();
$objDB->sql_connect($hostname, $username, $password, $dbname);
$ColumnChart = new Graph();
$ColumnChart->set_graphTitle("Hits Summary");
$ColumnChart->set_graphXLabel("Hour");
$ColumnChart->set_graphYLabel("Total Hits");
$ColumnChart->set_chartColumns(array("Hour", "Total Hits"));
$result = $objDB->query("select Hour(datetime) as hour, count(*) as hits from hits group by 1 order by 1 desc;");
$index = 0;
while ($line = $objDB->fetch_row($result)) {
$rows[$index][0] = $line['hour'];
$rows[$index][1] = $line['hits'];
$index++;
}
$ColumnChart->set_chartRows($rows);
$ColumnChart->set_chartGraph("ColumnChart");
$ColumnChart->get_chartGraph();
$objDB->sql_close();
// -------------------------------------------------------------------------------------------------------------------------------
$LineChart = new Graph();
$LineChart->set_graphTitle("Hits Summary");
$LineChart->set_graphXLabel("Hour");
$LineChart->set_graphYLabel("Total Hits");
$LineChart->set_chartColumns(array("Hour", "Total Hits"));
$rows = array(0 => array(0, 5), 1 => array(1, 10), 2 => array(2, 15), 3 => array(3, 20));
