PHP DatabaseUtils::updateData 예제들

예제 #1

파일: checkout.php 프로젝트: sh932111/BrainProject

$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $select_array = array("orderID" => $orderID);
    $selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
    $orderRecord = mysql_fetch_array($selectOrder);
    $wordNum = (int) $orderRecord['wordNum'];
    $selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
    if (!$selectDetail) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $code = 0;
    while ($record = mysql_fetch_array($selectDetail)) {
        $code++;
    }
    if ($code != $wordNum) {
        $db_utils->responseError($start_time, "單字尚未選滿！要選好選滿R！", 209, $user_link);
    }
    $obj["status"] = 2;
    if (!$db_utils->updateData($user_link, TableName::getOrderTable, $obj, "orderID", $orderID)) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $res["message"] = "更新資料成功！";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}

예제 #2

파일: update.php 프로젝트: sh932111/BrainProject

} else {
    $data = $_POST['data'];
}
$obj = json_decode($data, true);
$enWord = $obj["enWord"];
$enWordID = $obj["enWordID"];
$definitionList = $obj["definitionList"];
$exampleList = $obj["exampleList"];
$translateList = $obj["translateList"];
$db_utils = new DatabaseUtils();
$start_time = TimeUtils::getNowTime();
$update_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $enWordObj = array("enWord" => $enWord);
    if (!$db_utils->updateData($user_link, TableName::getENWordTable, $enWordObj, "enWordID", $enWordID)) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    for ($i = 0; $i < count($definitionList); $i++) {
        $definitionItem = $definitionList[$i];
        $enDefinition = $definitionItem["enDefinition"];
        $enDefinitionID = $definitionItem["enDefinitionID"];
        $enDefObj = array("enDefinition" => $enDefinition);
        if (!$db_utils->updateData($user_link, TableName::getWordDefinitionTable, $enDefObj, "enDefinitionID", $enDefinitionID)) {
            $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
        }
        $exampleItem = $exampleList[$i];
        $zhExample = $exampleItem["zhExample"];
        $enExample = $exampleItem["enExample"];
        $enExampleID = $exampleItem["enExampleID"];
        $enExaObj = array("enExample" => $enExample, "zhExample" => $zhExample);

예제 #3

파일: finish.php 프로젝트: sh932111/BrainProject

    $userScore = 100;
    while ($detailRecord = mysql_fetch_array($selectDetail)) {
        $enWordID = $detailRecord['enWordID'];
        $test = $detailRecord['test'];
        $detailID = $detailRecord['detailID'];
        $select_enWord = array("enWordID" => $enWordID);
        $enWordObj = $db_utils->selectTableAnd($user_link, TableName::getENWordTable, $select_enWord);
        if (!$enWordObj) {
            $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
        }
        $wordRecord = mysql_fetch_array($enWordObj);
        $enWord = $wordRecord['enWord'];
        if ($enWord == $test) {
            $updateDetailObj = array();
            $updateDetailObj["testResult"] = 1;
            if (!$db_utils->updateData($user_link, TableName::getOrderDetailTable, $updateDetailObj, "detailID", $detailID)) {
                $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
            }
        } else {
            $userScore = $userScore - $score;
        }
    }
    $resultOrder["status"] = 4;
    $resultOrder["testResult"] = $userScore;
    if (!$db_utils->updateData($user_link, TableName::getOrderTable, $resultOrder, "orderID", $orderID)) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $res["message"] = "更新資料成功！";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);

예제 #4

파일: updateWord.php 프로젝트: sh932111/BrainProject

include "../../utils/tokenUtils.php";
$data = $_POST["data"];
if (get_magic_quotes_gpc()) {
    $data = stripslashes($_POST['data']);
} else {
    $data = $_POST['data'];
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$list = $obj["list"];
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $upd["status"] = 3;
    if (!$db_utils->updateData($user_link, TableName::getOrderTable, $upd, "orderID", $orderID)) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    for ($i = 0; $i < count($list); $i++) {
        $item = $list[$i];
        $detailID = $item["detailID"];
        if (!$db_utils->updateData($user_link, TableName::getOrderDetailTable, $item, "detailID", $detailID)) {
            $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
        }
    }
    $res["message"] = "更新資料成功！";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}