PHP timestamp_to_fecha Examples

Example #1

File: getChatData.php Project: joanma100/bolsaphp

function getData($lastID)
{
    global $db;
    $SELECT = "SELECT *, UNIX_TIMESTAMP(log_fecha) as timestamp_unix from log";
    $SELECT .= " WHERE log_descripcion != 'login' AND log_descripcion != 'logout' ";
    if ($lastID >= 0) {
        $SELECT .= " AND log_id > '" . $lastID . "' ";
    }
    $SELECT .= " ORDER BY log_id DESC LIMIT 0 , 40 ";
    $result = $db->get_results($SELECT);
    if ($result) {
        $row = 0;
        array_multisort($result, SORT_ASC, $result);
        while (isset($result[$row]->log_id)) {
            $fecha = timestamp_to_fecha($result[$row]->timestamp_unix);
            echo $result[$row]->log_id . " ---";
            echo $result[$row]->log_usuario_login . " ---";
            echo $result[$row]->log_descripcion . " ---";
            echo $fecha . " ---";
            echo $result[$row]->log_tipo . " ---";
            // --- is being used to separete the fields in the output
            $row++;
        }
    }
}

Example #2

File: plugfunctions.php Project: joanma100/bolsaphp

 function ordenes_en_cola()
 {
     global $db, $config;
     echo "<div>Órdenes en cola</div>";
     echo "<div><a href=\"http://bolsaphp.sukiweb.net/index.php?ordenes=todas\">Todas las órdenes</a></div>";
     echo "<div id=\"datos-ticker\">";
     echo "<fieldset><legend>Compras</legend>";
     echo "<div class=\"cuatrocolumnas\">";
     echo "<div class=\"col4izq\"><strong>Ticker</strong></div>";
     echo "<div class=\"col4cen1\"><strong>Acc. / Precio</strong></div>";
     echo "<div class=\"col4cen2\"><strong>Usuario</strong></div>";
     echo "<div class=\"col4der\"><strong>Fecha</strong></div>";
     $SELECT = "SELECT *, UNIX_TIMESTAMP(timestamp) as timestamp_unix FROM ordenes ";
     $SELECT .= " WHERE intencion='COMPRA' ";
     if ($_GET["ordenes"] != "todas") {
         $SELECT .= " AND usuario='" . $_SESSION["usuario"] . "' ";
     }
     $SELECT .= " ORDER BY timestamp ASC";
     $compra = $db->get_results($SELECT);
     $row = 0;
     while (isset($compra[$row]->id)) {
         $fecha = timestamp_to_fecha($compra[$row]->timestamp_unix);
         echo "<div class=\"col4izq\"><a href=\"index.php?ticker=" . $compra[$row]->ticker . "\">" . $compra[$row]->ticker . "</a></div>";
         echo "<div class=\"col4cen1\">" . $compra[$row]->acciones . " / " . $compra[$row]->valor . " €</div>";
         echo "<div class=\"col4cen2\"><a href=\"index.php?usuario=" . $compra[$row]->usuario . "\">" . $compra[$row]->usuario . "</a></div>";
         echo "<div class=\"col4der\">" . $fecha . "</div>";
         $row++;
     }
     echo "</div>";
     echo "</fieldset>";
     echo "</div>";
     echo "<div id=\"datos-ticker-cartera\">";
     echo "<fieldset><legend>Ventas</legend>";
     echo "<div class=\"cuatrocolumnas\">";
     echo "<div class=\"col4izq\"><strong>Ticker</strong></div>";
     echo "<div class=\"col4cen1\"><strong>Acc. / Precio</strong></div>";
     echo "<div class=\"col4cen2\"><strong>Usuario</strong></div>";
     echo "<div class=\"col4der\"><strong>Fecha</strong></div>";
     $SELECT = "SELECT *, UNIX_TIMESTAMP(timestamp) as timestamp_unix FROM ordenes ";
     $SELECT .= " WHERE intencion='VENTA' ";
     if ($_GET["ordenes"] != "todas") {
         $SELECT .= " AND usuario='" . $_SESSION["usuario"] . "' ";
     }
     $SELECT .= " ORDER BY timestamp ASC";
     $venta = $db->get_results($SELECT);
     $row = 0;
     while (isset($venta[$row]->id)) {
         $fecha = timestamp_to_fecha($venta[$row]->timestamp_unix);
         echo "<div class=\"col4izq\"><a href=\"index.php?ticker=" . $venta[$row]->ticker . "\">" . $venta[$row]->ticker . "</a></div>";
         echo "<div class=\"col4cen1\">" . $venta[$row]->acciones . " / " . $venta[$row]->valor . " €</div>";
         echo "<div class=\"col4cen2\"><a href=\"index.php?usuario=" . $venta[$row]->usuario . "\">" . $venta[$row]->usuario . "</a></div>";
         echo "<div class=\"col4der\">" . $fecha . "</div>";
         $row++;
     }
     echo "</div>";
     echo "</fieldset>";
     echo "</div>";
 }