Beispiel #1
0
    }
    if ($detailNum > 0) {
        $selectRoot = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
        if (!$selectRoot) {
            $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
        }
        $rootfetch = mysql_fetch_array($selectRoot);
        $wordNum = (int) $rootfetch["wordNum"];
        if ($detailNum >= $wordNum) {
            $db_utils->responseError($start_time, "無法加入,單字已經達上限!", 300, $user_link);
        } else {
            $detailID = TimeUtils::getId();
            $obj["detailID"] = $detailID;
            $obj["create_time"] = $update_time;
            $obj["update_time"] = $update_time;
            $db_utils->addOrderDetailTable($user_link, $obj, "", 2);
            $res["message"] = "加入成功!";
            $db_utils->response($start_time, $res, $user_link);
        }
    } else {
        $detailID = TimeUtils::getId();
        $obj["detailID"] = $detailID;
        $obj["create_time"] = $update_time;
        $obj["update_time"] = $update_time;
        $db_utils->addOrderDetailTable($user_link, $obj, "", 2);
        $res["message"] = "加入成功!";
        $db_utils->response($start_time, $res, $user_link);
    }
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
Beispiel #2
0
header('Content-Type: text/html; charset=utf8');
date_default_timezone_set('Asia/Taipei');
include "../../../database/DatabaseUtils.php";
include "../../../utils/TimeUtils.php";
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);
$list = $obj["list"];
/*Dictionary:enTypeName(string)*/
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    for ($i = 0; $i < count($list); $i++) {
        $enTypeDiry = $list[$i];
        $enTypeDiry["enTypeID"] = TimeUtils::getId();
        $enTypeDiry["create_time"] = $update_time;
        $enTypeDiry["update_time"] = $update_time;
        $db_utils->addENTypeTable($user_link, $enTypeDiry);
    }
    $res["message"] = "加入成功!";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
Beispiel #3
0
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    for ($i = 0; $i < count($wordList); $i++) {
        $enWordDiry = $wordList[$i];
        $enWordID = TimeUtils::getId();
        $enWordDiry["enWordID"] = $enWordID;
        $enWordDiry["create_time"] = $update_time;
        $enWordDiry["update_time"] = $update_time;
        $db_utils->addENWordTable($user_link, $enWordDiry);
        $configList = $enWordDiry["configList"];
        for ($x = 0; $x < count($configList); $x++) {
            $configDiry = $configList[$x];
            $configDiry["enExampleID"] = TimeUtils::getId();
            $configDiry["enDefinitionID"] = TimeUtils::getId();
            $configDiry["enTranslateID"] = TimeUtils::getId();
            $configDiry["enWordID"] = $enWordID;
            $configDiry["create_time"] = $update_time;
            $configDiry["update_time"] = $update_time;
            $db_utils->addWordDefinitionTable($user_link, $configDiry);
            $db_utils->addWordTranslateTable($user_link, $configDiry);
            $db_utils->addWordExampleTable($user_link, $configDiry);
        }
    }
    $res["message"] = "加入成功!";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
Beispiel #4
0
<?php

header("Access-Control-Allow-Origin: *");
header('Content-Type: text/html; charset=utf8');
date_default_timezone_set('Asia/Taipei');
include "../../database/DatabaseUtils.php";
include "../../utils/TimeUtils.php";
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);
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $orderID = TimeUtils::getId();
    $obj["orderID"] = $orderID;
    $obj["create_time"] = $update_time;
    $obj["update_time"] = $update_time;
    $db_utils->addOrderTable($user_link, $obj, 1, 0);
    $res["orderID"] = $orderID;
    $res["message"] = "加入成功!";
    $db_utils->response($start_time, $res, $user_link);
} else {
    $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}