PHP addDaysToDate Exemples

Exemple #1

Fichier : create.php Projet : eb/phptourney

            if ($season['double_elimination'] != "") {
                $deadline = $lb_startdate;
                dbQuery("INSERT INTO `{$cfg['db_table_prefix']}deadlines` (`round`, `deadline`, `id_season`) " . "VALUES ('lb0', '{$deadline}', {$season['id']})");
                for ($i = 1; $i <= getNumLBRounds($season); $i++) {
                    if ($i == 1) {
                        $deadline = addDaysToDate($deadline, $_REQUEST['wb_round_length']);
                    } elseif (1 & $i) {
                        $deadline = addDaysToDate($deadline, $_REQUEST['wb_round_length'] - $_REQUEST['lb_round_length']);
                    } else {
                        $deadline = addDaysToDate($deadline, $_REQUEST['lb_round_length']);
                    }
                    dbQuery("INSERT INTO `{$cfg['db_table_prefix']}deadlines` (`round`, `deadline`, `id_season`) " . "VALUES ('lb{$i}', '{$deadline}', {$season['id']})");
                }
                // Gf
                dbQuery("INSERT INTO `{$cfg['db_table_prefix']}deadlines` (`round`, `deadline`, `id_season`) " . "VALUES ('gf0', '{$deadline}', {$season['id']})");
                $deadline = addDaysToDate($deadline, $_REQUEST['wb_round_length'] - $_REQUEST['lb_round_length']);
                dbQuery("INSERT INTO `{$cfg['db_table_prefix']}deadlines` (`round`, `deadline`, `id_season`) " . "VALUES ('gf1', '{$deadline}', {$season['id']})");
            }
            $content_tpl->parse("H_MESSAGE_DEADLINES_SETUP", "B_MESSAGE_DEADLINES_SETUP");
            $content_tpl->parse("H_MESSAGE", "B_MESSAGE");
            $content_tpl->set_var("I_ID_SEASON", $season['id']);
            $content_tpl->parse("H_BACK_OVERVIEW", "B_BACK_OVERVIEW");
        }
        if (!$is_complete) {
            $content_tpl->parse("H_WARNING", "B_WARNING");
            $content_tpl->parse("H_BACK", "B_BACK");
        }
    }
} else {
    $content_tpl->parse("H_WARNING_NO_ACCESS", "B_WARNING_NO_ACCESS");
    $content_tpl->parse("H_WARNING", "B_WARNING");

Exemple #2

Fichier : data_edit.php Projet : bash-t/admidio

$db->query($sql);
$sql = 'UPDATE ' . TBL_DATES . ' SET dat_begin = \'' . addDaysToDate(10) . ' 15:00:00\'
                               , dat_end = \'' . addDaysToDate(10) . ' 19:00:00\'
         WHERE dat_id = 6 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_DATES . ' SET dat_begin = \'' . addDaysToDate(-1) . ' 00:00:00\'
                               , dat_end = \'' . addDaysToDate(0) . ' 00:00:00\'
         WHERE dat_id = 7 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_FOLDERS . ' SET fol_timestamp = \'' . addDaysToDate(-7) . '\'
         WHERE fol_id = 1 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_GUESTBOOK . ' SET gbo_timestamp_create = \'' . addDaysToDate(-14) . ' 12:14:42\'
         WHERE gbo_id = 1 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_GUESTBOOK . ' SET gbo_timestamp_create = \'' . addDaysToDate(-5) . ' 20:16:42\'
         WHERE gbo_id = 2 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_GUESTBOOK_COMMENTS . ' SET gbc_timestamp_create = \'' . addDaysToDate(-4) . ' 16:23:12\'
         WHERE gbc_id = 1 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_LINKS . ' SET lnk_timestamp_create = \'' . addDaysToDate(-4) . '\'
                               , lnk_timestamp_change = \'' . addDaysToDate(-3) . '\'
         WHERE lnk_id = 1 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_LINKS . ' SET lnk_timestamp_create = \'' . addDaysToDate(-4) . '\'
         WHERE lnk_id = 2 ';
$db->query($sql);
$sql = 'UPDATE ' . TBL_LINKS . ' SET lnk_timestamp_create = \'' . addDaysToDate(-4) . '\'
         WHERE lnk_id = 3 ';
$db->query($sql);