xvb - プログラム倉庫

google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
 
function drawTable() {
 
var artist=new Array();
var num=new Array();
var s,number;
var pp=new Array();
 
$.get( "sql.php", function( data ) {
 
pp=data.split(",");
 
number=pp.length/2; 
 
for(s=1;s<number+1;s++){
artist[s]=pp[2*s-2];
num[s]=parseInt(pp[2*s-1]);
} 
 
var data = new google.visualization.DataTable();
data.addColumn('string', 'artist');
data.addColumn('number', 'rank');
data.addRows(number);
for(s=1;s<number+1;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 n,a FROM fuji");
 
$sx=0; 
while ($row = mysql_fetch_assoc($result)) {
$sx=$sx+1;
$artist[$sx]=$row['a'];
$number[$sx]=$row['n'];
}
$n=$sx;
for($s=1;$s<$n;$s++){
print($artist[$s]);
print(",");
print($number[$s]);
print(",");
}
$s=$n;
print($artist[$s]);
print(",");
print($number[$s]);
mysql_close($link);
?>