function checkSolarTemp()
{
global $minSolar;
$sql = query("SELECT sensorId FROM sensoren where name = 'Solar'");
$row = fetch($sql);
$temp = getSensorTemp($row[sensorId]);
logToFile("Skript: Prüfe Solartemperatur - Solarpanel IST: {$temp} Min.: {$minSolar}");
if ($minSolar > $temp) {
//logToFile("Skript: Solar EIN - Solarpanel IST: $temp Min.: $minSolar");
return 1;
} else {
//logToFile("Skript: Solar AUS - Solarpanel IST: $temp Min.: $minSolar");
return 0;
}
}
function getPoolTemp()
{
$sql = query("SELECT sensorId FROM sensoren where name = 'Pool'");
$row = fetch($sql);
$temp = getSensorTemp($row[sensorId]);
return $temp;
}
<?php
include "funktionen.php";
$sensor = $_GET["sensor"];
$action = $_GET[action];
//echo "tets";
$sensors = explode(",", $sensor);
$count = 0;
$count1 = 0;
if ($action == "file") {
foreach ($sensors as $value) {
if ($count == 0) {
$output = $output . getSensorTemp($value);
} else {
$output = $output . "," . getSensorTemp($value);
}
$count++;
}
echo $output;
}
if ($action == "database") {
// echo "database";
$output = "";
foreach ($sensors as $sensor) {
$sql = query("SELECT value FROM logtemp WHERE iid = '" . $sensor . "' ORDER BY id DESC LIMIT 1");
$row = fetch($sql);
//var_dump($row);
//echo $row["value"] . "<br>";
// $output = $output . "," . $row['value'];
if ($count == 0) {
$output = $output . sprintf("%1\$.2f", $row['value']);
<?php
include "funktionen.php";
$sql = query("SELECT * FROM sensoren");
//var_dump($sql);
while ($sensor = fetch($sql)) {
$sensors[$sensor[name]] = getSensorTemp($sensor[sensorId]);
$temp = getSensorTemp($sensor[sensorId]);
$sql1 = query("SELECT value FROM logtemp WHERE name= '" . $sensor[name] . "' ORDER BY id DESC LIMIT 1");
$temp_1h = fetch($sql1);
//var_dump($temp_1h);
$diff = $temp - $temp_1h[0];
$diff = sprintf("%1\$.2f", $diff);
//echo $sensor[name] . " - 1h: " . $temp_1h[0] . " - aktuell: " . $temp . " diff:" . $diff . "<br>" ;
$update = query("UPDATE temptrend SET {$sensor['name']} = '" . $diff . "' ");
logSensortemp($sensor[name], $sensor[sensorId], $temp);
}
//$cpu_temperature = round(exec("cat /sys/class/thermal/thermal_zone0/temp ") / 1000, 2);
//logSensortemp("Raspberry","1",$cpu_temperature);
