";
$elenco_id=array();
} else {
// posso creare il json per APP
$elenco_id[]=27;
$elenco_id[]=81;
$elenco_id[]=29;
$elenco_id[]=30;
$elenco_id[]=31;
$elenco_id[]=32;
}
}
if ($esitoArray['esito']===false){
//print "falso";
// utente NON autenticato ... puo' vedere SOLO i dati istantanei ...
$elenco_id=array();
}
// ecco la query .....
$query="select stazione as id,nome,data,
ifnull(temp,-9999) as temp,
ifnull(umid,-9999) as umid,
ifnull(vent,-9999) as vent,
ifnull(t50bag,-9999) as t50bag,
ifnull(t50asc,-9999) as t50asc,
ifnull(fb_ora,-9999) as fb,
ifnull(piog_oggi,-9999) as piog_oggi from meteo.ultimo_record,gestione.stazioni_4326 where
id=stazione and (stazione>=7 and stazione<=97) order by stazione ";
//-------------------------------------------------------------------------------
// ora che ho costruito la query "adatta" ... prelevo i dati dal DB e creo il json
//-------------------------------------------------------------------------------
$link = mysql_connect("panoramix","normale","normale");
if (!$link) {die('Errore! : ' . mysql_error());}
/*
if ($id==0){
$query="select stazione as id,nome,data,ifnull(temp,-999) as temp,
ifnull(umid,-9999) as umid,
ifnull(t50asc,-9999) as t50asc, ifnull(t50bag,-9999) as t50bag,
ifnull(vent,-9999) as vent,
ifnull(fb_ora,-9999) as fb,
piog_oggi from meteo.ultimo_record,gestione.stazioni_4326 where
id=stazione and (stazione<>20 and stazione<>93 and stazione<=97) order by stazione ";
}
if ($id==15){
$query="select stazione as id,nome,data,ifnull(temp,-9999) as temp,
ifnull(umid,-9999) as umid,
(-9999) as t50asc, (-9999) as t50bag,
ifnull(vent,-9999) as vent,
ifnull(fb_ora,-9999) as fb,
piog_oggi from meteo.ultimo_record,gestione.stazioni_4326 where id=stazione and stazione=$id ";
// $query="select stazione as id,data,temp,umid,piog_oggi from meteo.ultimo_record where stazione=$id";
}
if ($id>0 and $id<>15){
$query="select stazione as id,nome,data,ifnull(temp,-9999) as temp,
ifnull(umid,-9999) as umid,
ifnull(t50asc,-9999) as t50asc, ifnull(t50bag,-9999) as t50bag,
ifnull(vent,-9999) as vent,
ifnull(fb_ora,-9999) as fb,
piog_oggi from meteo.ultimo_record,gestione.stazioni_4326 where id=stazione and stazione=$id ";
// $query="select stazione as id,data,temp,umid,piog_oggi from meteo.ultimo_record where stazione=$id";
}
*/
//print "$query
";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$rows=array();
$c=0;
while($r=mysql_fetch_assoc($result)){
$idx=$r['id'];
if (!in_array($idx, $elenco_id)) {
$r['fb']="null";
$r['t50bag']="null";
} else {
//print "falso
";
}
if ($id==0 or $id==""){
$rows[$c]=$r;
$c++;
} else {
if ($idx==$id){
$rows[$c]=$r;
$c++;
}
}
}
$output = json_encode($rows);
echo $output;
mysql_close();
?>