=$TimeStop)) { $sql = "SELECT * FROM THERMOSTAT WHERE F_NUMREC>1 AND F_TIMESTART < CAST(NOW() AS TIME) AND F_TIMESTOP >= CAST(NOW() AS TIME)"; // $sql = "SELECT * FROM THERMOSTAT WHERE F_NUMREC>1 AND F_TIMESTART < CAST($now AS TIME) AND F_TIMESTOP >= CAST($now AS TIME)"; $row = mysqli_fetch_assoc(mysqli_query($con, $sql)); $NumProg = $row['F_NUMPROG']; $Desc = $row['F_DESC']; $BaseTemp = $row['F_BASETEMP']; $Delta = $row['F_DELTA']; $TimeStart= $row['F_TIMESTART']; $TimeStop= $row['F_TIMESTOP']; $Test='Passé par ici'; $sql = "UPDATE THERMOSTAT SET F_NUMPROG = '$NumProg', F_DESC = '$Desc', F_BASETEMP= '$BaseTemp', F_TIMESTART=CAST('$TimeStart' AS TIME),F_TIMESTOP=CAST('$TimeStop' AS TIME),F_DELTA='$Delta' WHERE F_NUMREC=1"; mysqli_query($con, $sql); } $sql = "SELECT * FROM MinuteInfo WHERE F_NUMREC=1"; $row = mysqli_fetch_assoc(mysqli_query($con, $sql)); $TMaison = $row['F_TMAISON']; $TGrange = $row['F_TGRANGE']; $TExterieur = $row['F_TEXTERIEUR']; $sql="SELECT F_NUMREC,F_LOCATION,F_TEMP,F_HUMIDITY,F_PRESSURE,F_DATE FROM climat WHERE F_LOCATION=1 ORDER BY F_NUMREC DESC LIMIT 25"; $result1=mysqli_query($con, $sql); $sql="SELECT F_NUMREC,F_LOCATION,F_TEMP,F_HUMIDITY,F_PRESSURE,F_DATE FROM climat WHERE F_LOCATION=2 ORDER BY F_NUMREC DESC LIMIT 25"; $result2=mysqli_query($con, $sql); $sql="SELECT F_NUMREC,F_LOCATION,F_TEMP,F_HUMIDITY,F_PRESSURE,F_DATE FROM climat WHERE F_LOCATION=9 ORDER BY F_NUMREC DESC LIMIT 25"; $result5=mysqli_query($con, $sql); $sql="SELECT F_NUMREC,F_LOCATION,F_MINT,F_MAXT,F_DATE FROM minmax WHERE F_LOCATION=1 ORDER BY F_NUMREC DESC LIMIT 25"; $result3=mysqli_query($con, $sql); $sql="SELECT F_NUMREC,F_LOCATION,F_MINT,F_MAXT,F_DATE FROM minmax WHERE F_LOCATION=2 ORDER BY F_NUMREC DESC LIMIT 25"; $result4=mysqli_query($con, $sql); $sql="SELECT F_NUMREC,F_LOCATION,F_MINT,F_MAXT,F_DATE FROM minmax WHERE F_LOCATION=9 ORDER BY F_NUMREC DESC LIMIT 25"; $result6=mysqli_query($con, $sql); CloseCon($con); while ($data = mysqli_fetch_assoc($result1)){ $sensor1_data[] = $data; } while ($data = mysqli_fetch_assoc($result2)){ $sensor2_data[] = $data; } while ($data = mysqli_fetch_assoc($result3)){ $sensor3_data[] = $data; } while ($data = mysqli_fetch_assoc($result4)){ $sensor4_data[] = $data; } while ($data = mysqli_fetch_assoc($result5)){ $sensor5_data[] = $data; } while ($data = mysqli_fetch_assoc($result6)){ $sensor6_data[] = $data; } $readings_time1 = array_column($sensor1_data, 'F_DATE'); $readings_time2 = array_column($sensor2_data, 'F_DATE'); $readings_time3 = array_column($sensor3_data, 'F_DATE'); $readings_time4 = array_column($sensor4_data, 'F_DATE'); $readings_time5 = array_column($sensor5_data, 'F_DATE'); $readings_time6 = array_column($sensor6_data, 'F_DATE'); $value1 = json_encode(array_reverse(array_column($sensor1_data, 'F_TEMP')), JSON_NUMERIC_CHECK); $value2 = json_encode(array_reverse(array_column($sensor1_data, 'F_HUMIDITY')), JSON_NUMERIC_CHECK); $value3 = json_encode(array_reverse(array_column($sensor1_data, 'F_PRESSURE')), JSON_NUMERIC_CHECK); $reading_time1 = json_encode(array_reverse($readings_time1), JSON_NUMERIC_CHECK); $value4 = json_encode(array_reverse(array_column($sensor2_data, 'F_TEMP')), JSON_NUMERIC_CHECK); $value5 = json_encode(array_reverse(array_column($sensor2_data, 'F_HUMIDITY')), JSON_NUMERIC_CHECK); $value6 = json_encode(array_reverse(array_column($sensor2_data, 'F_PRESSURE')), JSON_NUMERIC_CHECK); $reading_time2 = json_encode(array_reverse($readings_time2), JSON_NUMERIC_CHECK); $value7 = json_encode(array_reverse(array_column($sensor3_data, 'F_MINT')), JSON_NUMERIC_CHECK); $value8 = json_encode(array_reverse(array_column($sensor3_data, 'F_MAXT')), JSON_NUMERIC_CHECK); $reading_time3 = json_encode(array_reverse($readings_time3), JSON_NUMERIC_CHECK); $value9 = json_encode(array_reverse(array_column($sensor4_data, 'F_MINT')), JSON_NUMERIC_CHECK); $value10 = json_encode(array_reverse(array_column($sensor4_data, 'F_MAXT')), JSON_NUMERIC_CHECK); $reading_time4 = json_encode(array_reverse($readings_time4), JSON_NUMERIC_CHECK); $value11 = json_encode(array_reverse(array_column($sensor5_data, 'F_TEMP')), JSON_NUMERIC_CHECK); $reading_time5 = json_encode(array_reverse($readings_time5), JSON_NUMERIC_CHECK); $value12 = json_encode(array_reverse(array_column($sensor6_data, 'F_MINT')), JSON_NUMERIC_CHECK); $value13 = json_encode(array_reverse(array_column($sensor6_data, 'F_MAXT')), JSON_NUMERIC_CHECK); $reading_time6 = json_encode(array_reverse($readings_time6), JSON_NUMERIC_CHECK); mysqli_free_result($result1); mysqli_free_result($result2); mysqli_free_result($result3); mysqli_free_result($result4); mysqli_free_result($result5); mysqli_free_result($result6); ?>

METEO

Maison : °   Grange : °   Ext : °

ALARME

image intrusion non transmise