Codice: Seleziona tutto
<?php
require_once("top.php");
$sql=mysql_query("SELECT * FROM Gesta_Albero");
$rows = array();
while($r = mysql_fetch_array($sql)) {
$rows[] = $r;
}
$jsonTable = json_encode($rows);
?>
<div id="chart_div"></div>
<script type='text/javascript' src='https://www.google.com/jsapi'></script>
<script type='text/javascript' src='js/jquery.min.js'></script>
<script type="text/javascript">
function drawVisualization() {
// Create and populate the data table.
var data = new google.visualization.DataTable(<?php echo $jsonTable; ?>);
// Create and draw the visualization.
new google.visualization.OrgChart(document.getElementById('visualization')).
draw(data, {allowHtml: true});
}
google.setOnLoadCallback(drawVisualization);
google.load('visualization', '1', {packages: ['orgchart']});
</script>
il json esce cosi [{"0":"1","id":"1","1":"17","parent_id":"17","2":"jack Sparrow","sopra":"jack Sparrow","3":"Barbara Jimenez","sotto":"Barbara Jimenez"}]