WETTER - Die automatische Wetterstation im Internet

Letzte Messung:

*aktuell:*	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktAußentemperatur = $myrow['daten']; if($gemaktAußentemperatur >-100) { $aktAußentemperatur = $gemaktAußentemperatur; } else { $aktAußentemperatur = "-"; } echo "" . $aktAußentemperatur; echo " °C "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktluftdruck = $myrow['daten']; if($gemaktluftdruck >0) { $aktluftdruck = $gemaktluftdruck + 52; } else { $aktluftdruck = "-"; } echo "" . $aktluftdruck; echo " hPa"; } ?> Tendenz: "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktluftdruck = $myrow['daten']; if($gemaktluftdruck >0) { $aktluftdruck = $gemaktluftdruck + 52; } else { $aktluftdruck = "-"; } } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT savetime, weatherdata as daten FROM airpressure WHERE savetime > (SELECT timestamp 'now' - interval '1 hour')"; $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktluftdruckVor1h = $myrow['daten']; // brauchma normal net weil wir binnen einer stunde sowieso einen wert kriegen /* if($gemaktluftdruckVor1h >0) { $aktluftdruckVor1h = $gemaktluftdruckVor1h + 52; } else { $aktluftdruckVor1h = "-"; } */ //echo $myrow['savetime'] . " "; // abbruch nach dem 1. schleifendurchlauf, da diese der zeit von -1 stunde am nähesten ist! break; } $Tendenz = $aktluftdruck - $aktluftdruckVor1h; // zum testen!!! $Tendenz = $aktluftdruck - $aktluftdruckVor1h; if ($Tendenz == 0) { echo "gleichbleibend"; } else { if ($aktluftdruck > $aktluftdruckVor1h){ echo "steigend"; } else { echo "fallend"; } } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktLuftfeuchte = $myrow['daten']; if($gemaktLuftfeuchte >0) { $aktLuftfeuchte = $gemaktLuftfeuchte; } else { $aktLuftfeuchte = "-"; } echo "" . $aktLuftfeuchte; echo " % "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktWindrichtung = $myrow['daten']; if($gemaktWindrichtung >0) { $aktWindrichtung = $gemaktWindrichtung; } else { $aktWindrichtung = "-"; } echo "" . $aktWindrichtung; echo " Grad "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktWindgeschwindigkeit = $myrow['daten']; if($gemaktWindgeschwindigkeit >-1) { $aktWindgeschwindigkeit = $gemaktWindgeschwindigkeit; } else { $aktWindgeschwindigkeit = "-"; } echo " " . $aktWindgeschwindigkeit; echo " km/h"; } ?>	(SELECT timestamp 'now' - interval '1 hour' )"; //$sunshineyesterday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $sunshine1hour = $myrow['daten']; } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM sunshine where savetime < (SELECT timestamp 'now')"; //$sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $sunshinetoday = $myrow['daten']; } $sunshineToday = $sunshineToday - $sunshine1hour; echo "" . $sunshineToday; echo " h "; ?> (Letzte Stunde)	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemNiederschlagvorStunde = $myrow['daten']; } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM rainfall where savetime < (SELECT timestamp 'now')"; //$sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemNiederschlagNow = $myrow['daten']; } $Niederschlag = $gemNiederschlagNow - $gemNiederschlagvorStunde; echo "" . $Niederschlag; echo " Liter/m2"; ?> (Letzte Stunde)
*minimum:*	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemminAußentemperatur = $myrow['daten']; if($gemminAußentemperatur >-100) { $minAußentemperatur = $gemminAußentemperatur; } else { $minAußentemperatur = "-"; } echo "" . $minAußentemperatur; echo " ° "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemminluftdruck = $myrow['daten']; if($gemminluftdruck >0) { $minluftdruck = $gemminluftdruck + 52; } else { $minluftdruck = "-"; } echo "" . $minluftdruck; echo " hPa "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemminLuftfeuchte = $myrow['daten']; if($gemminLuftfeuchte <>500) { $minLuftfeuchte = $gemminLuftfeuchte; } else { $minLuftfeuchte = "-"; } echo "" . $minLuftfeuchte; echo " % "; } ?>	Hauptrichtung "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktWindrichtung = $myrow['daten']; if($gemaktWindrichtung >0) { $aktWindrichtung = $gemaktWindrichtung; } else { $aktWindrichtung = "-"; } echo "" . $aktWindrichtung; echo " Grad"; } ?> (letzte Stunde)	Durchschnitt (SELECT timestamp 'yesterday')"; $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktWindgeschwindigkeit = $myrow['daten']; echo "" . $gemaktWindgeschwindigkeit; echo " km/h"; } ?> (seit Mitternacht)	(SELECT timestamp 'yesterday')"; $sunshineyesterday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxSonnenschein = $myrow['daten']; if($gemmaxSonnenschein >0) { $maxSonnenscheinYesterday = $gemmaxSonnenschein; } else { $maxSonnenscheinYesterday = "-"; } } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM sunshine where savetime < (SELECT timestamp 'now')"; $sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxSonnenschein = $myrow['daten']; if($gemmaxSonnenschein >0) { $maxSonnenscheinNow = $gemmaxSonnenschein; } else { $maxSonnenscheinNow = "-"; } } $sunshineToday = $maxSonnenscheinNow - $maxSonnenscheinYesterday; echo "" . $sunshineToday; echo " h "; ?> (seit Mitternacht)	(SELECT timestamp 'yesterday')"; $sunshineyesterday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxNiederschlag = $myrow['daten']; if($gemmaxNiederschlag >0) { $maxNiederschlagYesterday = $gemmaxNiederschlag; } else { $maxNiederschlagYesterday = "-"; } } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM rainfall where savetime < (SELECT timestamp 'now')"; $sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxNiederschlag = $myrow['daten']; if($gemmaxNiederschlag >0) { $maxNiederschlagNow = $gemmaxNiederschlag; } else { $maxNiederschlagNow = "-"; } } $sunshineToday = $maxNiederschlagNow - $maxNiederschlagYesterday; echo " " . $sunshineToday; echo " Liter/m2"; ?> (seit Mitternacht)
*maximum:*	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxAußentemperatur = $myrow['daten']; if($gemmaxAußentemperatur >-100) { $maxAußentemperatur = $gemmaxAußentemperatur; } else { $maxAußentemperatur = "-"; } echo "" . $maxAußentemperatur; echo " ° "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxluftdruck = $myrow['daten']; // seehöhe 416 m daher 52 hPa dazu. pro 8m von Meereshöhe 1 hPa if($gemmaxluftdruck >0) { $maxluftdruck = $gemmaxluftdruck + 52; } else { $maxluftdruck = "-"; } echo "" . $maxluftdruck; echo " hPa "; } ?>	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxLuftfeuchte = $myrow['daten']; // seehöhe 416 m daher 52 hPa dazu. pro 8m von Meereshöhe 1 hPa if($gemmaxLuftfeuchte >0) { $maxLuftfeuchte = $gemmaxLuftfeuchte; } else { $maxLuftfeuchte = "-"; } echo "" . $maxLuftfeuchte; echo " % "; } ?>	Hauptrichtung "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemaktWindrichtung = $myrow['daten']; if($gemaktWindrichtung >0) { $aktWindrichtung = $gemaktWindrichtung; } else { $aktWindrichtung = "-"; } echo "" . $aktWindrichtung; echo " Grad"; } ?> (seit Mitternacht)	"; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxWindgeschwindigkeit = $myrow['daten']; echo " " . $gemmaxWindgeschwindigkeit; echo " km/h"; } ?>	(SELECT timestamp 'now' - interval '24 hour')"; $sunshineyesterday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxSonnenschein = $myrow['daten']; if($gemmaxSonnenschein >0) { $maxSonnenscheinYesterday = $gemmaxSonnenschein; } else { $maxSonnenscheinYesterday = "-"; } } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM sunshine where savetime < (SELECT timestamp 'now')"; $sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxSonnenschein = $myrow['daten']; if($gemmaxSonnenschein >0) { $maxSonnenscheinNow = $gemmaxSonnenschein; } else { $maxSonnenscheinNow = "-"; } } $sunshineToday = $maxSonnenscheinNow - $maxSonnenscheinYesterday; echo " " . $sunshineToday; echo " h"; ?> (Letzte 24 Stunden)	(SELECT timestamp 'now' - interval '24 hour')"; $sunshineyesterday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxNiederschlag = $myrow['daten']; if($gemmaxNiederschlag >0) { $maxNiederschlagYesterday = $gemmaxNiederschlag; } else { $maxNiederschlagYesterday = "-"; } } $db = pg_connect('host=localhost dbname=ws550 user=postgres password=weather'); $query = "SELECT max(counteramount) as daten FROM sunshine where savetime < (SELECT timestamp 'now')"; $sunshinetoday = pg_query($query); $result = pg_query($query); if (!$result) { echo "Problem with query " . $query . " "; echo pg_last_error(); exit(); } while($myrow = pg_fetch_assoc($result)) { $gemmaxNiederschlag = $myrow['daten']; if($gemmaxNiederschlag >0) { $maxNiederschlagNow = $gemmaxNiederschlag; } else { $maxNiederschlagNow = "-"; } } $sunshineToday = $maxNiederschlagNow - $maxNiederschlagYesterday; echo " " . $sunshineToday; echo " Liter/m2"; ?> (Letzte 24 Stunden)