<html>
<head>
<meta charset="utf-8">
<title>社会人口統計体系</title>
<script src="jquery.js"></script>
<script src="fusion.js"></script>
<script src="sample.js"></script>
</head>
<body onload="fusion()">
<select id="pic" name="pic">
</select>
<input type="button" value="選択" onClick="f()" />
<p id="memo">準備中</div>
</body>
</html>
t=new Array();
var number;
function fusion() {
var query = "SELECT * FROM ";
query=query+"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;
t[sx]= rows[i][0];
}
number=sx;
select();
$("#memo").text("準備完了");
}
});
}
function select(){
var s;
for(s=1;s<number+1;s++){
var option = $('<option />');
option.val(s);
option.html(t[s]);
$("#pic").append(option);
}
}
function f(){
var str;
var n=$("#pic").val();
if(n>50)n=1;
str="<img src=\"pic/"+n+".jpg\">";
$("#memo").html(str);
}
最終更新:2014年01月01日 07:21