| <?php |
| |
| require_once 'tutorial_insert_data.php'; |
| |
| // Receive data from database |
| $db = ezcDbInstance::get(); |
| $query = $db->createSelectQuery(); |
| $query |
| ->select( 'hits' ) |
| ->from( 'browser_hits' ); |
| $statement = $query->prepare(); |
| $statement->execute(); |
| |
| // Create chart from data |
| $chart = new ezcGraphLineChart(); |
| $chart->title = 'Browser statistics'; |
| $chart->options->fillLines = 220; |
| |
| $chart->data['browsers'] = new ezcGraphDatabaseDataSet( $statement ); |
| $chart->data['average'] = new ezcGraphDataSetAveragePolynom( |
| $chart->data['browsers'] |
| ); |
| |
| $chart->render( 400, 150, 'tutorial_single.svg' ); |
| |
| ?> |