$req = mysql_query($query, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error()); while ($periph = mysql_fetch_assoc($req)) { if ($periph['batterie'] == 0) { $batterie = "<img src='./img/batterie_ok.png' height='20px'/>"; } else { $batterie = "<img src='./img/batterie_ko.png' height='20px'/>"; } if ($periph['libelle'] == "") { $nom = $periph['nom']; } else { $nom = $periph['libelle']; } echo "<TR class=tab-ligne bgcolor='" . ($i % 2 == 1 ? '#dddddd' : '#eeeeee') . "'>"; $i++; echo "<TD>" . $batterie . "</TD>"; echo "<TD><span style='vertical-align:3px'>" . $nom . "</span></TD>"; if ($periph['date_chgt_batterie'] != "0000-00-00") { echo "<TD style='text-align: center;'>" . date_francais($periph['date_chgt_batterie']) . "</TD>"; } else { echo "<TD></TD>"; } if ($periph['alerte_batterie'] != "0000-00-00 00:00:00") { echo "<TD style='text-align: center;'>" . date_simplifiee($periph['alerte_batterie']) . "</TD>"; } else { echo "<TD></TD>"; } echo "</TR>"; } ?> </TABLE></CENTER>
$i = 0; include_once "./lib/date_francais.php"; echo "<CENTER><TABLE width=500px>"; echo "<TR class=tab-titre><TD></TD><TD>Capteur</TD><TD width=100px>Luminosité</TD><TD width=150px>Dernier enregistrement</TD></TR>"; $query = "SELECT * FROM peripheriques WHERE periph = 'luminosite'"; $req = mysql_query($query, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error()); while ($periph = mysql_fetch_assoc($req)) { if ($periph['batterie'] == 0) { $batterie = ""; } else { $batterie = "<img src='./img/batterie_ko.png' style='height:20px'/>"; } $query0 = "SELECT * FROM `luminosite_" . $periph['nom'] . "` ORDER BY `date` DESC LIMIT 1"; $req0 = mysql_query($query0, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error()); while ($value0 = mysql_fetch_assoc($req0)) { if ($periph['libelle'] == "") { $nom = $periph['nom']; } else { $nom = $periph['libelle']; } echo "<TR class=tab-ligne bgcolor='" . ($i % 2 == 1 ? '#dddddd' : '#eeeeee') . "' id='TR_" . $periph['id'] . "'>"; echo " <TD>" . $batterie . "</TD>"; echo " <TD><span style='vertical-align:3px'>" . $nom . "</span></TD>"; echo " <TD ALIGN=CENTER>" . $value0['lum'] . "</TD>"; echo " <TD>" . date_simplifiee($value0['date']) . "</TD>"; echo "</TR>"; $i++; } } echo "</TABLE></CENTER>";
<?php include_once "./lib/date_francais.php"; $i = 0; echo "<CENTER><TABLE width=500px>"; echo "<TR class=tab-titre><TD></TD><TD>Appareil</TD><TD width=120px>Puissance instantannée</TD><TD width=150px>Dernier enregistrement</TD></TR>"; $query = "SELECT * FROM peripheriques WHERE periph = 'conso'"; $req = mysql_query($query, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error()); while ($periph = mysql_fetch_assoc($req)) { if ($periph['batterie'] == 0) { $batterie = ""; } else { $batterie = "<img src='./img/batterie_ko.png' style='height:20px'/>"; } $query0 = "SELECT * FROM `conso_" . $periph['nom'] . "` ORDER BY `date` DESC LIMIT 1"; $req0 = mysql_query($query0, $link) or die('Erreur SQL !<br>' . $sql . '<br>' . mysql_error()); while ($value0 = mysql_fetch_assoc($req0)) { if ($periph['libelle'] == "") { $nom = $periph['nom']; } else { $nom = $periph['libelle']; } echo "<TR class=tab-ligne bgcolor='" . ($i % 2 == 1 ? '#dddddd' : '#eeeeee') . "' id='TR_" . $periph['id'] . "'><TD>" . $batterie . "</TD><TD><span style='vertical-align:3px'>" . $nom . "</span></TD><TD ALIGN=CENTER>" . $value0['conso'] . " W</TD><TD>" . date_simplifiee($value0['date']) . "</TD></TR>"; $i = $i + 1; } } echo "</TABLE></CENTER>";