PHP Database::updateById Examples

Example #1

File: active.php Project: bignunxd/otog

        if ($_POST["val"] == "contest" or $_POST["val"] == "blind_contest") {
            // Database::deleteAllThat("backup","`task_id` > 0");
            $re_task = Database::getAllThat("task", "`see` = 1");
            while ($task = mysql_fetch_array($re_task)) {
                $input["task_id"] = $task["task_id"];
                Database::putInTo("backup", $input);
                $inputx["see"] = 0;
                Database::updateById("task", $task["task_id"], $inputx);
            }
        } else {
            if ($_POST["val"] == "online") {
                mysql_query("TRUNCATE TABLE `ask`");
                $re_backup = Database::getAll("backup");
                while ($task = mysql_fetch_array($re_backup)) {
                    $input["see"] = 1;
                    Database::updateById("task", $task["task_id"], $input);
                }
                Database::deleteAllThat("backup", "`task_id` > 0");
            }
        }
    }
    $sql = "UPDATE `config` SET `val` = '" . $_POST["val"] . "' WHERE `index` = '" . $_POST["index"] . "'";
    mysql_query($sql) or die("<div style='background-color:#FFBFD3'><br><div style='height:1px'></div><h4>UNSUCCESS</h4><div style='height:1px'></div><br></div>");
} else {
    if ($_POST["type"] == "main_time") {
        $date = strtotime($_POST["val"]);
        $sql = "UPDATE `config` SET `val` = '" . $date . "' WHERE `index` = '" . $_POST["index"] . "'";
        mysql_query($sql) or die("<div style='background-color:#FFBFD3'><br><div style='height:1px'></div><h4>UNSUCCESS</h4><div style='height:1px'></div><br></div>");
    } else {
        if ($_REQUEST["action"] == "add_task") {
            Database::putInTo("task", $_POST);