PHP setLocalTime Beispiele

Beispiel #1

Datei: general.class.php Projekt: NioFBI/majordomo

function recLocalTime($table, $id, $gmt, $field = "ADDED")
{
    // UPDATES TIMESTAMP FIELD USING GMT
    $rec = SQLSelectOne("SELECT ID, DATE_FORMAT({$field}, '%Y-%m-%d %H:%i') as DAT FROM {$table} WHERE ID='{$id}'");
    if (isset($rec["ID"])) {
        $new_dat = setLocalTime($rec['DAT'], $gmt);
        SQLExec("UPDATE {$table} SET {$field}='{$new_dat}' WHERE ID='{$id}'");
    }
}

Beispiel #2

Datei: general.class.php Projekt: novozhenets/majordomo

function recLocalTime($table, $id, $gmt, $field="ADDED") {
 // UPDATES TIMESTAMP FIELD USING GMT
 $rec=SQLSelectOne("SELECT ID, DATE_FORMAT($field, '%Y-%m-%d %H:%i') as DAT FROM $table WHERE ID='$id'");
 if (IsSet($rec["ID"])) {
  $new_dat=setLocalTime($rec['DAT'], $gmt);
  SQLExec("UPDATE $table SET $field='$new_dat' WHERE ID='$id'");
 }
}