kg - プログラム倉庫

var c=new Array();
var y=new Array();
var v=new Array();
var c2=new Array();
var y2=new Array();
var v2=new Array();
a=new Array();
t=new Array();
b=new Array();                                        
var number,number_om;
var urlx,urlxs;
var p1,p2;
 
function sample(){
 
fusion();
 
sample2();
 
}
 
function fusion() {
 
var query = "SELECT * FROM ";
query=query+"13jb1i3dideYXtG56TXyUIwkDJC9cIneGIN-yxiE";
 
        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',
      async: false,
    success: function (data) {
 
 var rows = data['rows'];
 
 
for (var i in rows) {
sx=sx+1;
a[sx]= rows[i][0];
t[sx]= rows[i][1];
b[sx]= rows[i][2];
}
 
number_om=sx;
 
$("#memo").text(number_om);
 
}
});
 
}
 
function sample2() {
 
p1=100;
 
urlx="http://atsites.jp/skebank/soc/gdata/"+p1+".jsonp"
 
$.ajax({
  type: 'GET',
  url: urlx,
  dataType: 'jsonp',
  jsonpCallback: 'callback',
 async: false,
  success: function(json){
 
number = json.length;
 
var i,n;
n=0;
for(i=0; i<number; i++){
c[i+1]=json[i].city;
y[i+1]=json[i].year;
v[i+1]=json[i].v;
}
 
$("#memo2").text(number);
 
}
});
}