File: demos/sqlike.html

Recommend this page to a friend!
  Classes of Tom Schaefer   Wunderground Weather API   demos/sqlike.html   Download  
File: demos/sqlike.html
Role: Example script
Content type: text/plain
Description: how query web response and print out a simple result table without server support
Class: Wunderground Weather API
Retrieve weather information with Wunderground API
Author: By
Last change:
Date: 11 years ago
Size: 1,884 bytes
 

Contents

Class file image Download
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Simple HTML RESULT TABLE</title> <script type="text/javascript" src="../wunderground.js"></script> <script type="text/javascript" src="http://www.thomasfrank.se/SQLike/js/SQLike.js"></script> <script type="text/javascript"> htmlTable=function(json){ if(!json){return}; var x,header="",content="", colNames={},colAlign={}; for(var i=0;i<json.length;i++){ for(var j in json[i]){ colNames[j]=1 json[i][j]==json[i][j]/1 && (colAlign[j]=1) } } for(var i=0;i<json.length;i++){ content+='<tr>'; for(var j in colNames){ if(!i){ header+='<td style="'+(colAlign[j]?'text-align:right;':'')+'background:#666;color:#fff"><b>'+j+'</b></td>' }; content+='<td style="background:'+(i%2==0?'#ddd':'#fff')+'" '+(colAlign[j]?'align="right"':'')+'>'+(json[i][j]+"").replace(/ /g,'&nbsp;')+'</td>' }; content+='</tr>' } x='<table cellspacing=1 cellpadding=3 border=0 width="710"><tr>'+ header+'</tr>'+content+'</table>'; return x }; </script> <script type="text/javascript"> var w = new wunderground({ service: "layerradar", options: { minlat: 50, maxlat:54 }, type: "CityCountry", params:["Erftstadt", "Germany"], culture: "DE", apikey: "--your api key here--" }); w.getData(function(data){ var dataTable = data.response.results var rs=SQLike.q({ Select: ['*'], From: dataTable, OrderBy: ['city','|desc|'] }); var tbl=htmlTable(rs); function createDiv(html){ var _body = document.getElementsByTagName('body') [0]; var _div = document.createElement('div'); _div.innerHTML=html; _body.appendChild(_div); } createDiv(tbl); }); </script> </head> <body> </body> </html>