PHP date_simplifiee примеры использования

Пример #1

Файл: batterie.php Проект: Harkanork/ZiHome

$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>

Пример #2

Файл: luminosite_tableau_global.php Проект: Harkanork/ZiHome

$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&eacute;</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>";

Пример #3

Файл: conso_elec_tableau_global.php Проект: Harkanork/ZiHome

<?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&eacute;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>";