blob: 5e9cd95d2d3fdc7c5040be2bf88192dc7ab8cc09 [file]
<?php
require_once 'tutorial_insert_data.php';
// Receive data from database
$db = ezcDbInstance::get();
$query = $db->createSelectQuery();
$query
->select( '*' )
->from( 'browser_hits' );
$statement = $query->prepare();
$statement->execute();
// Create chart from data
$chart = new ezcGraphPieChart();
$chart->title = 'Browser statistics';
$chart->legend = false;
$chart->data['browsers'] = new ezcGraphDatabaseDataSet(
$statement,
array(
ezcGraph::KEY => 'browser',
ezcGraph::VALUE => 'hits',
)
);
// Some graph output formatting
$chart->renderer = new ezcGraphRenderer3d();
$chart->renderer->options->pieChartGleam = .3;
$chart->renderer->options->pieChartGleamColor = '#FFFFFF';
$chart->renderer->options->dataBorder = false;
$chart->renderer->options->pieChartShadowSize = 5;
$chart->renderer->options->pieChartShadowColor = '#000000';
$chart->renderer->options->pieChartSymbolColor = '#55575388';
$chart->renderer->options->pieChartHeight = 5;
$chart->renderer->options->pieChartRotation = .8;
// Render
$chart->render( 400, 150, 'tutorial_multiple.svg' );
?>