<html>
<head>
<script src='https://www.google.com/jsapi'></script>
<script src='jquery.js'></script>
<script src='ex06.js'></script>
</head>
<body>
<div id='table'></div>
</body>
</html>
google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
function drawTable() {
var artist=new Array();
var num=new Array();
var s;
var pp=new Array();
$.get( "sql.php", function( data ) {
pp=data.split(",");
for(s=0;s<4;s++){
artist[s+1]=pp[s];
}
num[1]=100;
num[2]=200;
num[3]=300;
num[4]=400;
var data = new google.visualization.DataTable();
data.addColumn('string', 'Name');
data.addColumn('number', 'Salary');
data.addRows(4);
for(s=1;s<5;s++){
data.setCell(s-1, 0, artist[s]);
data.setCell(s-1, 1, num[s]);
}
var table = new google.visualization.Table(document.getElementById('table'));
table.draw(data, {showRowNumber: true});
});
}
<?php
require('calldata.php');
$result = mysql_query("SELECT y,a FROM mf where y=2011");
while ($row = mysql_fetch_assoc($result)) {
print($row['a']);
print(",");
}
print("abc");
mysql_close($link);
?>
最終更新：2013年12月08日 02:26
