music2 - プログラム倉庫

<?php
require('calldata.php');
 
$year = $_GET['y'];
$mon = $_GET['m'];
 
$sql="SELECT y,m,w,r,a,t FROM music where y=";
$str=" and m=";
$sql=$sql.$year.$str.$mon;
 
$result = mysql_query($sql);
 
$sx=0; 
while ($row = mysql_fetch_assoc($result)) {
$sx=$sx+1;
$a[$sx]=$row['a'];
$r[$sx]=$row['r'];
$y[$sx]=$row['y'];
$m[$sx]=$row['m'];
$w[$sx]=$row['w'];
$t[$sx]=$row['t'];
}
$n=$sx;
for($s=1;$s<$n;$s++){
print($y[$s]);
print(",");
print($m[$s]);
print(",");
print($w[$s]);
print(",");
print($r[$s]);
print(",");
print($a[$s]);
print(",");
print($t[$s]);
print(",");
}
$s=$n;
print($y[$s]);
print(",");
print($m[$s]);
print(",");
print($w[$s]);
print(",");
print($r[$s]);
print(",");
print($a[$s]);
print(",");
print($t[$s]);
 
mysql_close($link);
?>
 
 
 
google.load('visualization', '1', {packages:['table']});
google.setOnLoadCallback(drawTable);
 
function drawTable() {
 
var artist=new Array();
var title=new Array();
var week=new Array();
var rank=new Array();
var month=new Array();
var s,number;
var pp=new Array();
 
$.get( "music2.php?y=2011&m=5", function( mdata ) {
 
pp=mdata.split(",");
 
number=pp.length/6; 
 
for(s=1;s<number+1;s++){
artist[s]=pp[6*s-2];
title[s]=pp[6*s-1];
rank[s]=parseInt(pp[6*s-3]);
week[s]=parseInt(pp[6*s-4]);
month[s]=parseInt(pp[6*s-5]);
} 
 
var data = new google.visualization.DataTable();
 
data.addColumn('number', '月');
data.addColumn('number', '週');
data.addColumn('number', 'ランク');
data.addColumn('string', '歌手');
data.addColumn('string', 'タイトル');
data.addRows(number);
for(s=1;s<number+1;s++){
data.setCell(s-1, 0, month[s]);
data.setCell(s-1, 1, week[s]);
data.setCell(s-1, 2, rank[s]);
data.setCell(s-1, 3, artist[s]);
data.setCell(s-1, 4, title[s]);
}
 
var table = new google.visualization.Table(document.getElementById('table'));
table.draw(data, {showRowNumber: true});
 
});
 
 
}