\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "Wetterdaten vom " . $rvar_datum . " - Österreich - Wien - Hirschstetten - 1220\n"; echo "\n"; echo "\n"; //echo "\n"; echo "\n"; echo "
\n"; echo "Dandy - Wetterstation
Wien - Hirschstetten
Daten seit 05.01.2006

\n"; echo "\n"; echo "Serverzeit ",$datum," ",$uhrzeit," Uhr

"; // Ergebnisse in HTML ausgeben // for-Schleife für die Ausgabe-Inhalte for($wetterart=TEMP_OUTSIDE1;$wetterart<=RAINFALL;$wetterart++) { /////////////////////////// // 0: Temperatur Süd // 1: Temperatur Nord // 2: Luftfeuchtigkeit // 3: Luftdruck // 4: Windgeschwindigkeit // 5: Windrichtung // 6: Sonnenscheindauer // 7: Regenmenge /////////////////////////// switch($wetterart) { case TEMP_OUTSIDE1: $table = "outside_temp"; break; case TEMP_OUTSIDE2: $table = "temp2"; break; case HUMIDITY: $table = "outside_hum"; break; case AIRPRESSURE: $table = "airpressure"; break; case WINDSPEED: $table = "windforce"; break; case WINDDIRECTION: $table = "winddirection"; break; case SUNSHINE: $table = "sunshine"; break; case RAINFALL: $table = "rainfall"; break; default: $table = ""; } /////////////////////////////////// // // 1. Schritt: min, max, avg Werte holen // /////////////////////////////////// $sql="select "; if ($wetterart == WINDDIRECTION) $rest1 = "0 as min, 0 as max, case when avg(degree) >= 348.75 then 'N' when avg(degree) < 11.25 then 'N' when avg(degree) >= 11.25 and avg(degree) < 33.75 then 'NNO' when avg(degree) >= 33.75 and avg(degree) < 56.25 then 'NO' when avg(degree) >= 56.25 and avg(degree) < 78.75 then 'ONO' when avg(degree) >= 78.75 and avg(degree) < 101.25 then 'O' when avg(degree) >= 101.25 and avg(degree) < 123.75 then 'OSO' when avg(degree) >= 123.75 and avg(degree) < 146.25 then 'SO' when avg(degree) >= 146.25 and avg(degree) < 168.75 then 'SSO' when avg(degree) >= 168.75 and avg(degree) < 191.25 then 'S' when avg(degree) >= 191.25 and avg(degree) < 213.75 then 'SSW' when avg(degree) >= 213.75 and avg(degree) < 236.25 then 'SW' when avg(degree) >= 236.25 and avg(degree) < 258.75 then 'WSW' when avg(degree) >= 258.75 and avg(degree) < 281.25 then 'W' when avg(degree) >= 281.25 and avg(degree) < 303.75 then 'WNW' when avg(degree) >= 303.75 and avg(degree) < 326.25 then 'NW' when avg(degree) >= 326.25 and avg(degree) < 348.75 then 'NNW' end as avg from "; else if ($wetterart == SUNSHINE) $rest1 = "min(suncounter)+3 as min, max(suncounter)-3 as max, round(cast (cast ((max(counteramount)-min(counteramount)) as numeric) /60 as numeric),2) as avg from "; else if ($wetterart == RAINFALL) $rest1 = "min(raincounter)+1 as min, max(raincounter) as max, round(cast (cast (cast (((max(counteramount)-min(counteramount))) as numeric) as numeric) * 0.295 as numeric),2) as avg from "; else $rest1 = " min(weatherdata) as min, max(weatherdata) as max,avg(weatherdata) as avg from "; $rest2= " where date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"; $result = pg_exec($sql . $rest1 . $table . $rest2); $nrows = pg_numrows($result); if($nrows != 0) { $min_zeit = ""; $max_zeit = ""; /////////////////////////////////// // // Schleife für Ausgabe der Daten // inkl. Tabellenheader // /////////////////////////////////// $row = pg_fetch_array($result); if ($wetterart == TEMP_OUTSIDE1) { print "
"; print "\n"; print "\n"; } print "\n"; } else print "

No Entry for " . $sql . $rest1 . $table . $rest2; print "

\n"; } echo "\n"; echo ""; echo "
Daten vom "; print $rvar_datum; print "
Wetterart"; print "DurchschnittMinimumMaximum
"; switch($wetterart) { case TEMP_OUTSIDE1: print "Temperatur Süd (° C)"; break; case TEMP_OUTSIDE2: print "Temperatur Nord (° C)"; break; case HUMIDITY: print "Luftfeuchtigkeit (%)"; break; case AIRPRESSURE: print "Luftdruck (hPa, absolut)"; break; case WINDSPEED: print "Windgeschwindigkeit (km/h)"; break; case WINDDIRECTION: print "Windrichtung"; break; case SUNSHINE: print "Sonnenscheindauer (h)"; break; case RAINFALL: print "Regenmenge (l/m²)"; break; default: print "undefined"; } $min = round($row["min"],2); $max = round($row["max"],2); if ($wetterart != WINDDIRECTION) $avg = round($row["avg"],2); else $avg = $row["avg"]; if ($wetterart == AIRPRESSURE) { $min = round(ConvertRelativeToAbsolutePressure(160, $min),2); $max = round(ConvertRelativeToAbsolutePressure(160, $max),2); $avg = round(ConvertRelativeToAbsolutePressure(160, $avg),2); } print ""; //if ($wetterart != SUNSHINE && $wetterart != RAINFALL) print $avg; //else print " "; print $avg; if ($wetterart == WINDSPEED) { print (""); if ($avg <= 0.7) print (" (Windstille)"); else if ($avg > 0.7 && $avg <= 5.4) print (" (leiser Zug)"); else if ($avg > 5.4 && $avg <= 11.9) print (" (leichte Brise)"); else if ($avg > 11.9 && $avg <= 19.4) print (" (schwache Brise)"); else if ($avg > 19.4 && $avg <= 28.5) print (" (mäßige Brise)"); else if ($avg > 28.5 && $avg <= 38.5) print (" (frische Brise)"); else if ($avg > 38.5 && $avg <= 49.8) print (" (starker Wind)"); else if ($avg > 49.8 && $avg <= 61.7) print (" (steifer Wind)"); else if ($avg > 61.7 && $avg <= 74.6) print (" (stürmischer Wind)"); else if ($avg > 74.6 && $avg <= 88.9) print (" (Sturm)"); else if ($avg > 88.9 && $avg <= 102.4) print (" (schwerer Sturm)"); else if ($avg > 102.4 && $avg <= 117.4) print (" (orkanartiger Sturm)"); else if ($avg > 117.4) print (" (Orkan)"); print (""); } print ""; // Sunshine, Rainfall Max, Min Datum holen if (($wetterart == RAINFALL && (($max - $min) > 0)) || ($wetterart == SUNSHINE && (($min - $max) != 6.0)) || $wetterart == TEMP_OUTSIDE1 || $wetterart == TEMP_OUTSIDE2) { if ($min > 0) { //" order by to_char(savetime, 'HH24:MI')" //" date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"; // NEU: 28.06.2006, GSc, Einschränkung auf eingegeben Tag if ($wetterart == SUNSHINE) $resultm = pg_exec("select min(to_char(savetime, 'HH24:MI')) as min_zeit from sunshine where suncounter between " . $min . " and " . ($min + 3) . " and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == RAINFALL) $resultm = pg_exec("select min(to_char(savetime, 'HH24:MI')) as min_zeit from rainfall where raincounter >= " . $min . " and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == TEMP_OUTSIDE1) $resultm = pg_exec("select min(to_char(savetime, 'HH24:MI')) as min_zeit from outside_temp where weatherdata = '" . $min . "' and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == TEMP_OUTSIDE2) $resultm = pg_exec("select min(to_char(savetime, 'HH24:MI')) as min_zeit from temp2 where weatherdata = '" . $min . "' and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); //DEBUG //print "\n"; //print "select to_char(savetime, 'HH24:MI') as min_zeit from sunshine where suncounter between " . $min . " and " . ($min + 3) . " order by to_char(savetime, 'HH24:MI')"; //print $min; $nrowsm = pg_numrows($resultm); if($nrowsm != 0) { $rowm = pg_fetch_array($resultm); $min_zeit = $rowm["min_zeit"]; } } if ($max > 0) { print "\n"; // NEU: 28.06.2006, GSc, Einschränkung auf eingegeben Tag if ($wetterart == SUNSHINE) $resultx = pg_exec("select max(to_char(savetime, 'HH24:MI')) as max_zeit from sunshine where suncounter between " . ($max - 3) . " and " . $max . " and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == RAINFALL) $resultx = pg_exec("select min(to_char(savetime, 'HH24:MI')) as max_zeit from rainfall where raincounter = " . $max . " and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == TEMP_OUTSIDE1) $resultx = pg_exec("select min(to_char(savetime, 'HH24:MI')) as max_zeit from outside_temp where weatherdata = '" . $max . "' and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); else if ($wetterart == TEMP_OUTSIDE2) $resultx = pg_exec("select min(to_char(savetime, 'HH24:MI')) as max_zeit from temp2 where weatherdata = '" . $max . "' and date_trunc('day',savetime) = '" . $jahr . "-" . $monat . "-" . $tag . " 00:00:00'"); $nrowsx = pg_numrows($resultx); if($nrowsx != 0) { $rowx = pg_fetch_array($resultx); $max_zeit = $rowx["max_zeit"]; } } } if ($wetterart != WINDDIRECTION && $wetterart != SUNSHINE && $wetterart != RAINFALL) { print $min; if (!empty ($min_zeit)) print " (" . $min_zeit . "h)"; } else if (($wetterart == SUNSHINE || $wetterart == RAINFALL) && !empty ($min_zeit)) print $min_zeit . "h"; else print " "; if ($wetterart == WINDSPEED) { print (""); if ($min <= 0.7) print (" (Windstille)"); else if ($min > 0.7 && $min <= 5.4) print (" (leiser Zug)"); else if ($min > 5.4 && $min <= 11.9) print (" (leichte Brise)"); else if ($min > 11.9 && $min <= 19.4) print (" (schwache Brise)"); else if ($min > 19.4 && $min <= 28.5) print (" (mäßige Brise)"); else if ($min > 28.5 && $min <= 38.5) print (" (frische Brise)"); else if ($min > 38.5 && $min <= 49.8) print (" (starker Wind)"); else if ($min > 49.8 && $min <= 61.7) print (" (steifer Wind)"); else if ($min > 61.7 && $min <= 74.6) print (" (stürmischer Wind)"); else if ($min > 74.6 && $min <= 88.9) print (" (Sturm)"); else if ($min > 88.9 && $min <= 102.4) print (" (schwerer Sturm)"); else if ($min > 102.4 && $min <= 117.4) print (" (orkanartiger Sturm)"); else if ($min > 117.4) print (" (Orkan)"); print (""); } print ""; if ($wetterart != WINDDIRECTION && $wetterart != SUNSHINE && $wetterart != RAINFALL) { print $max; if (!empty ($max_zeit)) print " (" . $max_zeit . "h)"; } else if (($wetterart == SUNSHINE || $wetterart == RAINFALL) && !empty ($max_zeit)) print $max_zeit . "h"; else print " "; if ($wetterart == WINDSPEED) { print (""); if ($max <= 0.7) print (" (Windstille)"); else if ($max > 0.7 && $max <= 5.4) print (" (leiser Zug)"); else if ($max > 5.4 && $max <= 11.9) print (" (leichte Brise)"); else if ($max > 11.9 && $max <= 19.4) print (" (schwache Brise)"); else if ($max > 19.4 && $max <= 28.5) print (" (mäßige Brise)"); else if ($max > 28.5 && $max <= 38.5) print (" (frische Brise)"); else if ($max > 38.5 && $max <= 49.8) print (" (starker Wind)"); else if ($max > 49.8 && $max <= 61.7) print (" (steifer Wind)"); else if ($max > 61.7 && $max <= 74.6) print (" (stürmischer Wind)"); else if ($max > 74.6 && $max <= 88.9) print (" (Sturm)"); else if ($max > 88.9 && $max <= 102.4) print (" (schwerer Sturm)"); else if ($max > 102.4 && $max <= 117.4) print (" (orkanartiger Sturm)"); else if ($max > 117.4) print (" (Orkan)"); print (""); } print "
"; echo "
\n"; echo "Min/Max Wetterwerte vom\n"; echo "
"; echo "\n"; echo ""; echo "\n"; echo "Tag Monat Jahr\n"; echo "
"; echo "		"; echo ""; echo " "; echo ""; echo " "; echo "
\n"; // footer echo "\n"; echo "\n"; echo "\n"; echo "

\n"; echo "\n"; //echo "\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
\n"; echo "
NächsteZufallListe
\n"; echo "

\n"; echo "

\n"; echo "Datenrettung Österreich - Defekte Festplatten
attingo informationstechnologie gmbh

\n"; echo "\"Hattrick

\n"; echo "\"SETI@home\"\n"; echo "

\n"; echo "\n"; echo "Datenrettung\n"; echo "defekte Festplatte\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "© 2006 by Dandy Enterprises\n"; echo "\n"; echo "

\n"; echo "\n"; echo "\n"; // Verbindung schliessen pg_close($dbconn); ?>