<?php
// Connexion à MySQL.
$link = mysql_connect( 'localhost', 'logger', 'password' ); // ici on remplace password par son mot de passe mysql.
if ( !$link ) {
die( 'Could not connect: ' . mysql_error() );
}
// Sélection de la base de données.
$db = mysql_select_db( 'temperatures', $link );
if ( !$db ) {
die ( 'Error selecting database temperatures : ' . mysql_error() );
}
// Récupération des lignes pointchaud.
$sth = mysql_query("SELECT dateandtime FROM temperaturedata WHERE sensor='pointchaud' ");
$rows = array();
$rows['name'] = 'dateandtime';
while($r = mysql_fetch_array($sth)) {
$rows['data'][] = $r['dateandtime'];
}
$sth = mysql_query("SELECT temperature FROM temperaturedata WHERE sensor = 'pointchaud' ");
$rows1 = array();
$rows1['name'] = 'temperature';
while($rr = mysql_fetch_array($sth)) {
$rows1['data'][] = $rr['temperature'];
}
$sth = mysql_query("SELECT humidity FROM temperaturedata WHERE sensor = 'pointchaud' ");
$rows2 = array();
$rows2['name'] = 'humidity';
while($rrr = mysql_fetch_assoc($sth)) {
$rows2['data'][] = $rrr['humidity'];
}
// Récupération des lignes pointfroid.
$sth = mysql_query("SELECT dateandtime FROM temperaturedata WHERE sensor = 'pointfroid' ");
$rows3 = array();
$rows3['name'] = 'dateandtime';
while($rrrr = mysql_fetch_array($sth)) {
$rows3['data'][] = $rrrr['dateandtime'];
}
$sth = mysql_query("SELECT temperature FROM temperaturedata WHERE sensor = 'pointfroid' ");
$rows4 = array();
$rows4['name'] = 'temperature';
while($rrrrr = mysql_fetch_array($sth)) {
$rows4['data'][] = $rrrrr['temperature'];
}
$sth = mysql_query("SELECT humidity FROM temperaturedata WHERE sensor = 'pointfroid' ");
$rows5 = array();
$rows5['name'] = 'humidity';
while($rrrrrr = mysql_fetch_assoc($sth)) {
$rows5['data'][] = $rrrrrr['humidity'];
}
$result = array();
array_push($result,$rows);
array_push($result,$rows1);
array_push($result,$rows2);
array_push($result,$rows3);
array_push($result,$rows4);
array_push($result,$rows5);
// Afficher les résultats
print json_encode($result, JSON_NUMERIC_CHECK);
// Fermer la connexion à MySQL
mysql_close($link);
?>