';
include "connexion.php";
$SQL_REQUETE_HEURES = "SELECT HOUR(moment) as heure, MIN(mesure) as minimum, AVG(mesure) as moyenne, MAX(mesure) as maximum FROM temperature WHERE MONTH(moment) = MONTH(CURRENT_TIMESTAMP()) AND DAY(moment) = DAY(CURRENT_TIMESTAMP()) GROUP BY HOUR(moment);";
$requete = $basededonnees->prepare($SQL_REQUETE_HEURES);
$requete->execute();
$heures = $requete->fetchAll(PDO::FETCH_OBJ);
$SQL_REQUETE_MOIS = "SELECT MONTH(moment) as mois, MIN(mesure) as minimum, AVG(mesure) as moyenne, MAX(mesure) as maximum FROM temperature WHERE HOUR(moment) = HOUR(CURRENT_TIMESTAMP()) AND DAY(moment) = DAY(CURRENT_TIMESTAMP()) GROUP BY MONTH(moment);";
$requete = $basededonnees->prepare($SQL_REQUETE_MOIS);
$requete->execute();
$mois = $requete->fetchAll(PDO::FETCH_OBJ);
$SQL_REQUETE_JOUR = "SELECT DAY(moment) as jour, MIN(mesure) as minimum, AVG(mesure) as moyenne, MAX(mesure) as maximum FROM temperature WHERE MONTH(moment) = MONTH(CURRENT_TIMESTAMP()) AND DAY(moment) = DAY(CURRENT_TIMESTAMP()) GROUP BY DAY(moment);";
$requete = $basededonnees->prepare($SQL_REQUETE_JOUR);
$requete->execute();
$jour = $requete->fetchAll(PDO::FETCH_OBJ);
$SQL_REQUETE_ACTUELLE = "SELECT * FROM temperature WHERE id = (SELECT MAX(id) FROM temperature);";
$requete = $basededonnees->prepare($SQL_REQUETE_ACTUELLE);
$requete->execute();
$actuelle = $requete->fetch(PDO::FETCH_OBJ);
?>
mesure?>
minimum?>
maximum?>
moyenne?>
jour?>
minimum?>
maximum?>
moyenne?>
while True:
for octet in entree.read():
listeLettres.append(chr(octet))
valeur = ''.join(str(lettre) for lettre in listeLettres) # Transforme un type tableau en chaîne de caractères
if chr(octet) == '\n':
print("Ligne " + str(ligne) + ': ' + valeur)
requests.post('http://172.105.20.42/service.meteo/ajouter-meteo.php', data={'luminosite':valeur})
listeLettres = []
ligne += 1
break
mesure ?? "N/A"?>
minimum ?? "N/A"?>
maximum ?? "N/A"?>
moyenne ?? "N/A"?>
jour?>
minimum?>
maximum?>
moyenne?>
mesure ?? "N/A"?>
minimum ?? "N/A"?>
maximum ?? "N/A"?>
moyenne ?? "N/A"?>
jour?>
minimum?>
maximum?>
moyenne?>