echo Google_Base::getVarById($dataVar3) . "\n";
echo $chart;
$dataView = new Google_Data_View();
$dataView->setViewTable("dataView1");
$dataView->setDataTable($dataTable);
$dataView->setColumns(array(0, 2));
echo $dataView;
$chart2 = new Google_Chart("Table", $dataVar2);
$chart2->draw($dataView, $options);
echo $chart2;
$dataView2 = new Google_Data_View();
$dataView2->setViewTable("dataView2");
$dataView2->setDataTable($dataTable);
$dataView2->setColumns(array(0, 1, 3));
echo $dataView2;
$chart3 = new Google_Chart("Table", $dataVar3);
$chart3->draw($dataView2, $options);
echo $chart3;
?>
}
google.setOnLoadCallback(drawVisualization);
</script>
</head>
<body style="font-family: Arial;border: 0 none;">
<div>Original Data Table</div>
<div id="table1"></div>
<br />
<div>A Data View</div>
<div id="table2"></div>
<br />
<div>Another Data View</div>
$query = 'SELECT A,D WHERE D > 100 ORDER BY D';
}
} else {
$chartType = 'AreaChart';
$query = 'SELECT A,D WHERE D > 100 ORDER BY D';
}
$id = 'viz';
$url = 'http://spreadsheets.google.com/tq?key=pCQbetd-CptGXxxQIG7VFIQ&pub=1';
# new visualization using template default
$v = new Google_Visualization("Default");
# register package
$p = new Google_Package(array("packages" => array($chartType), "language" => "de_DE"));
$v->setPackage($p);
// set package object to visualization
# setup chart
$chart = new Google_Chart($chartType, Google_Base::getElementById($id));
$options = new Google_Config($chartType);
$options->setProperty("width", 550);
$chart->draw("data", $options);
# init functions
$f1 = new Google_Function('drawVisualization');
$f2 = new Google_Function('handleQueryResponse', array('response'));
# setup query
$q = new Google_Data_Query($url);
$q->setQuery($query);
$q->send($f2->getName());
$f1->add($q);
$f1->setCallBack();
$v->setFunction($f1);
# setup response
$qr = new Google_Data_QueryResponse();
