connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
$query = 'SELECT temp as max, name, id FROM rete_meteo WHERE temp = (SELECT max(temp) FROM rete_meteo WHERE online="1" AND blocco="0")';
if ($result = $mysqli->query($query)) {
/* print html loop */
$row = $result->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query2 = 'SELECT temp as min, name, id FROM rete_meteo WHERE temp = (SELECT min(temp) FROM rete_meteo WHERE online="1" AND blocco="0")';
if ($result2 = $mysqli->query($query2)) {
/* print html loop */
$row = $result2->fetch_assoc();
$valueArr[] = $row["min"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query3 = 'SELECT windsp as max, name, id FROM rete_meteo WHERE windsp = (SELECT max(windsp) FROM rete_meteo WHERE online="1" AND blocco="0")';
if ($result3 = $mysqli->query($query3)) {
/* print html loop */
$row = $result3->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query4 = 'SELECT rr as max, name, id FROM rete_meteo WHERE rr = (SELECT max(rr) FROM rete_meteo WHERE online="1" AND blocco="0")';
if ($result4 = $mysqli->query($query4)) {
/* print html loop */
$row = $result4->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query5 = 'SELECT hitemp as max, name, id FROM rete_meteo WHERE hitemp = (SELECT max(hitemp) FROM rete_meteo WHERE online="1" AND hitemp >= -25 AND hitemp <= 45 AND blocco="0")';
if ($result5 = $mysqli->query($query5)) {
/* print html loop */
$row = $result5->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query6 = 'SELECT lowtemp as min, name, id FROM rete_meteo WHERE lowtemp = (SELECT min(lowtemp) FROM rete_meteo WHERE online="1" AND lowtemp >= -25 AND lowtemp <= 45 AND blocco="0")';
if ($result6 = $mysqli->query($query6)) {
/* print html loop */
$row = $result6->fetch_assoc();
$valueArr[] = $row["min"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query7 = 'SELECT hiwind as max, name, id FROM rete_meteo WHERE hiwind = (SELECT max(hiwind) FROM rete_meteo WHERE online="1" AND blocco="0")';
if ($result7 = $mysqli->query($query7)) {
/* print html loop */
$row = $result7->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
$query8 = 'SELECT dayrain as max, name, id FROM rete_meteo WHERE dayrain = (SELECT max(dayrain) FROM rete_meteo WHERE online="1" AND dayrain >= 0 AND dayrain <= 400 AND name != "Stroppiello" AND blocco="0")';
if ($result8 = $mysqli->query($query8)) {
/* print html loop */
$row = $result8->fetch_assoc();
$valueArr[] = $row["max"];
$valueArr[] = $row["name"];
$valueArr[] = $row["id"];
}
/* free result set */
$result->free();
$result2->free();
$result3->free();
$result4->free();
$result5->free();
$result6->free();
$result7->free();
$result8->free();
/* close connection */
$mysqli->close();
return $valueArr;
}
?>