Detektor kvality ozvduší, teploty a vlhkosti

Zadejte počet minut, za které chete zobrazit hodnoty:

nebo si vyberte z přednastavených hodnot ze seznamu níže:

Vyberte časový úsek: 1 hodina 2 hodiny 3 hodiny 4 hodiny 5 hodin 6 hodin 7 hodin 8 hodin 12 hodin 1 den 2 dny 3 dny

Poslední aktualizace:

TEPLOTA

--

Teplota hodnot
Min	Max	Průměr
°C	°C	°C

VLHKOST VZDUCHU

--

Vlhkost hodnot
Min	Max	Průměr
%	%	%

Co2

--

Co2 hodnot
Min	Max	Průměr
ppm	ppm	ppm

error); $hledat = 46; $hledat2 = 48; $data1 = ''; $data2 = ''; $data5 = ''; $data6 = ''; //query to get data from the table $sql = "SELECT * FROM `SensorData` WHERE `location` LIKE '%".$hledat."%' and reading_time > now() - interval $readings_count minute "; $result = mysqli_query($mysqli, $sql); //loop through the returned data while ($row = mysqli_fetch_array($result)) { $data1 = $data1 . '"'. $row['value1'].'",'; $data2 = $data2 . '"'. $row['value2'] .'",'; $data3 = $data3 . '"'. $row['value3'] .'",'; } $sql = "SELECT * FROM `SensorData` WHERE `location` LIKE '%".$hledat2."%' and reading_time > now() - interval $readings_count minute "; $result2 = mysqli_query($mysqli, $sql); while ($row = mysqli_fetch_array($result2)) { $data4 = $data4 . '"'. $row['value1'].'",'; $data5 = $data5 . '"'. $row['value2'] .'",'; $data6 = $data6 . '"'. $row['value3'] .'",'; } $sql = "SELECT * FROM `SensorData` WHERE `location` LIKE '%".$hledat."%' and reading_time > now() - interval $readings_count minute "; $result2 = mysqli_query($mysqli, $sql); while ($row = mysqli_fetch_array($result2)) { $data7 = $data7 . '"'. $row['reading_time'] . '",'; } $data1 = trim($data1,","); $data2 = trim($data2,","); $data4 = trim($data4,","); $data5 = trim($data5,","); ?>
Posledních ' . $readings_count . ' minut '; $result = getAllReadings($readings_count); if ($result) { while ($row = $result->fetch_assoc()) { $row_id = $row["id"]; $row_sensor = $row["sensor"]; $row_location = $row["location"]; $row_value1 = $row["value1"]; $row_value2 = $row["value2"]; $row_value3 = $row["value3"]; $row_reading_time = $row["reading_time"]; // Uncomment to set timezone to - 1 hour (you can change 1 to any number) //$row_reading_time = date("Y-m-d H:i:s", strtotime("$row_reading_time - 1 hours")); //$row_reading_time = date("d.m.Y H:i:s"); // Uncomment to set timezone to + 7 hours (you can change 7 to any number) //$row_reading_time = date("Y-m-d H:i:s", strtotime("$row_reading_time + 7 hours")); echo ''; } echo '

ID	Senzor	Lokace	Teplota	Vlhkost	Co2	Časové razítko
' . $row_id . '	' . $row_sensor . '	' . $row_location . '	' . $row_value1 . '	' . $row_value2 . '	' . $row_value3 . '	' . $row_reading_time . '

'; $result->free(); } ?>