Weather report from Zelgstrasse in Adliswil";
include("/home/html/webbservern/_huvud.html");
include("/home/html/webbservern/handbok/_innehall.html");
include("/home/html/webbservern/_huvud2.html");
echo "Weather report from Zelgstrasse in Adliswil
";
echo "The weather station moved to Switzerland in 2013 and got installed on the balcony on 18th of December.
";
echo "Between 2009 and 2013 it was at Guldheden in Gothenburg.
";
echo "The weather station device was bought at Clas Ohlson (artikelnr 36-3242) but is sold as many different brands internationally. The most common product name seems to be WH1080.
";
echo "RSS feed: hourly och daily.
";
echo "Weather station id on Weather Underground: IZRICHAD2
";
echo "Thermometers at home
| Room | Temperature °C | Updated | More details |
|---|
";
//echo "Server room
";
$mysqlBaseGarage = "tempsserverroom";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside, inflow, serverroom FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageInflow = $rowGarage["inflow"];
$garageServerroom = $rowGarage["serverroom"];
$garageDate = $rowGarage["date"];
/*echo "Ventilation air temperature: ".$garageInflow." [".$garageDate."]
";
echo "Corridor: " .$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
echo "More details";*/
echo "| Server room ventilation | ".$garageInflow." | ".$garageDate." | More details |
";
echo "| Server room | ".$garageServerroom." | ".$garageDate." | |
";
echo "| Server room corridor | ".$garageIndoor." | ".$garageDate." | More details |
";
$mysqlBaseGarage = "tempsbastelraum";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Garage temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
//echo "| Bastelraum | ".$garageIndoor." | ".$garageDate." | More details |
";
$mysqlBaseGarage = "tempslivingroom";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Garage temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
echo "| Living room | ".$garageIndoor." | ".$garageDate." | More details |
";
$mysqlBaseGarage = "tempsbathroom";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Garage temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
echo "| Bathroom | ".$garageIndoor." | ".$garageDate." | More details |
";
//echo "Garage
";
$mysqlBaseGarage = "tempsgarage";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Garage temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
//echo "More details";
//echo "More details";
echo "| Garage | ".$garageIndoor." | ".$garageDate." | More details |
";
$mysqlBaseGarage = "tempsgate";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
mysqli_close($conGarage);
echo "| Gate | ".$garageIndoor." | ".$garageDate." | More details |
";
//echo "Winter garden
";
$mysqlBaseWintergarten = "tempswintergarten";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseWintergarten");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
$queryGarage = "SELECT date,inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Wintergarten temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
//echo "More details";
echo "| Winter garden | ".$garageIndoor." | ".$garageDate." | More details |
";
//echo "Washing room
";
$mysqlBase = "tempswashingroom";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBase");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
$queryGarage = "SELECT date,inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Washingroom temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
//echo "More details";
echo "| Washing room | ".$garageIndoor." | ".$garageDate." | More details |
";
/* the rpi A is not used now
echo "| Wine cellar | ";
$mysqlBase = "tempswinecellar";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBase");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
$queryGarage = "SELECT date,inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
echo $garageIndoor." | ".$garageDate." | ";
mysqli_close($conGarage);
echo "More details |
";
*/
echo "| Wine cellar | ";
$mysqlBase = "tempswinecellar";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBase");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
$queryGarage = "SELECT date,inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
echo $garageIndoor." | ".$garageDate." | ";
mysqli_close($conGarage);
echo "More details |
";
//echo "Bed room
";
$mysqlBaseGarage = "tempsbedroom";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "| Bed room | ".$garageIndoor." | ".$garageDate." | More details |
";
$mysqlBaseGarage = "tempskitchen";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
echo "| Kitchen | ".$garageIndoor." | ".$garageDate." | More details |
";
//echo "Office
";
$mysqlBaseGarage = "tempsoffice";
$mysqlUserGarage = "temps";
$mysqlPassGarage = "digitemp";
$conGarage = mysqli_connect('webbservern3', "$mysqlUserGarage", "$mysqlPassGarage", "$mysqlBaseGarage");
if(!$conGarage)
{
die('Could not connect: ' . mysqli_error($conGarage));
}
//mysql_select_db( "$mysqlBaseGarage", $conGarage );
$queryGarage = "SELECT date, inside FROM data ORDER BY date DESC LIMIT 1";
$resultGarage = mysqli_query($conGarage, $queryGarage);
$rowGarage = mysqli_fetch_assoc($resultGarage);
$garageIndoor = $rowGarage["inside"];
$garageDate = $rowGarage["date"];
//echo "Office temperature: ".$garageIndoor." [".$garageDate."]
";
mysqli_close($conGarage);
//echo "More details";
//echo "More details";
echo "| Master's Bedroom | ".$garageIndoor." | ".$garageDate." | More details |
";
echo "
";
echo "Last 6 hours
";
#echo "
\n";
include("/var/www/weather/6hrs.txt");
#echo "
";
echo "Last 24 hours
";
echo "![](\"/weather/24hrs.png\")
";
echo "
";
#echo "";
include("/var/www/weather/24hrs.txt");
#echo "
";
echo "Last week
";
echo "![](\"/weather/7days.png\")
";
echo "Last month
";
echo "![](\"/weather/28days.png\")
";
/*
-rw-r--r-- 1 root root 7845 Jan 14 07:32 24hrs.png
-rw-r--r-- 1 root root 1354 Jan 14 07:32 24hrs.txt
-rw-r--r-- 1 root root 1322 Jan 14 07:32 6hrs.txt
-rw-r--r-- 1 root root 10779 Jan 14 07:32 7days.png
-rw-r--r-- 1 root root 911 Jan 14 07:32 plot_24.cmd
-rw-r--r-- 1 root root 1274 Jan 14 07:32 plot_24_pressure.dat
-rw-r--r-- 1 root root 600 Jan 14 07:32 plot_24_rain.dat
-rw-r--r-- 1 root root 1176 Jan 14 07:32 plot_24_temp.dat
-rw-r--r-- 1 root root 1470 Jan 14 07:32 plot_24_wind.dat
-rw-r--r-- 1 root root 916 Jan 14 07:32 plot_7.cmd
-rw-r--r-- 1 root root 4468 Jan 14 07:32 plot_7_pressure.dat
-rw-r--r-- 1 root root 699 Jan 14 07:32 plot_7_rain.dat
-rw-r--r-- 1 root root 4081 Jan 14 07:32 plot_7_temp.dat
-rw-r--r-- 1 root root 5110 Jan 14 07:32 plot_7_wind.dat
jonas@webbservern2:/tmp/data/tmp/weather$
*/
//include("/home/html/webbservern/_fot.html");
?>