<html>
<head>
<meta charset="utf-8"/>
<title>社会人口統計体系</title>
<script src="jquery.js"></script>
<script src="sox.js"></script>
</head>
<body onload="f()">
<select id="topic" name="topic">
</select>
<div id="chart" style="width: 800px; height: 500px;"></div>
</body>
</html>
sox=new Array();
var soxnumber;
function f() {
var query = "SELECT * FROM " +
'1paGzEyuBKmAvFMrYGr5kOrP8bCDH914Vqure00A';
var encodedQuery = encodeURIComponent(query);
var url = ['https://www.googleapis.com/fusiontables/v1/query'];
url.push('?sql=' + encodedQuery);
url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
url.push('&callback=?');
var sx;
sx=0;
$.ajax({
url: url.join(''),
dataType: 'jsonp',
success: function (data) {
var rows = data['rows'];
for (var i in rows) {
sx=sx+1;
sox[sx]= rows[i][0];
}
soxnumber=sx;
select();
$("#chart").text("準備終了");
}
});
}
function select(){
var s;
for(s=1;s<soxnumber+1;s++){
var option = $('<option />');
option.val(s);
option.html(sox[s]);
$("#topic").append(option);
}
}
最終更新:2013年12月28日 20:46