$resultaat = $db->query($sql);
$data = array();
array_push($data, array('Project shopping - balans inkomsten vs uitgaven', '', '', ''));
array_push($data, array('Maand', 'Inkomsten', 'Uitgaven', 'Balans'));
while ($row = $resultaat->fetch(PDO::FETCH_ASSOC)) {
$tempArray = array($row["maand"], $row["inkomsten"], $row["uitgaven"], calculateBalance($row["inkomsten"], $row['uitgaven']));
array_push($data, $tempArray);
}
// Setup graph context
$graph = new CanvasGraph(803, 387);
// Setup the basic table and font
$table = new GTextTable();
$table->Set($data);
$table->SetFont(FF_TIMES, FS_NORMAL, 11);
$table->SetFont(FF_TIMES, FS_NORMAL, 12);
$table->SetCellFont(0, 0, FF_ARIAL, FS_BOLD, 16);
$table->SetMinColWidth(200);
$table->MergeRow(0);
// Setup color
$table->SetRowFillColor(0, '#0b82ff@0.5');
$table->SetColFillColor(0, '#b7ceff@0.5');
//$table->SetFillColor(0, 0, 4, 0, 'lightgray@0.5');
// Set default table alignment
$table->SetAlign('right');
// Add table to graph
$graph->Add($table);
$table->SetAlign("center");
$table->SetColAlign(0, "left");
$table->SetRowAlign(0, 'center');
// send it back to the client
$graph->Stroke();
<?php
require_once 'jpgraph/jpgraph.php';
require_once 'jpgraph/jpgraph_canvas.php';
require_once 'jpgraph/jpgraph_table.php';
// Setup a basic canvas graph context
$graph = new CanvasGraph(430, 600);
// Setup the basic table
$data = array(array('GROUP 1O', 'w631', 'w632', 'w633', 'w634', 'w635', 'w636'), array('Critical (sum)', 13, 17, 15, 8, 3, 9), array('High (sum)', 34, 35, 26, 20, 22, 16), array('Low (sum)', 41, 43, 49, 45, 51, 47), array('Sum:', 88, 95, 90, 73, 76, 72));
// Setup the basic table and default font
$table = new GTextTable();
$table->Set($data);
$table->SetFont(FF_TIMES, FS_NORMAL, 11);
// Default table alignment
$table->SetAlign('right');
// Adjust font in (0,0)
$table->SetCellFont(0, 0, FF_TIMES, FS_BOLD, 14);
// Rotate all textxs in row 0
$table->SetRowTextOrientation(0, 90);
// Adjust alignment in cell (0,0)
$table->SetCellAlign(0, 0, 'center', 'center');
// Add table to graph
$graph->Add($table);
// Send back table to client
$graph->Stroke();
?>
