fujix - プログラム倉庫

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