Exemplos de DatabaseUtils::selectTableAnd em PHP

Exemplo n.º 1

Arquivo: createWord.php Projeto: 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"];
$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);
    $selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
    if (!$selectDetail) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $detailNum = 0;
    while ($record = mysql_fetch_array($selectDetail)) {
        $detailNum++;
    }
    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) {

Exemplo n.º 2

Arquivo: list.php Projeto: sh932111/BrainProject

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();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $select_array = array();
    $select_obj = $db_utils->selectTableAnd($user_link, TableName::getENTypeTable, $select_array);
    if (!$select_obj) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $list = array();
    while ($record = mysql_fetch_array($select_obj)) {
        $get["enTypeID"] = $record['enTypeID'];
        $get["enTypeName"] = $record['enTypeName'];
        $get["create_time"] = $record['create_time'];
        $get["update_time"] = $record['update_time'];
        array_push($list, $get);
    }
    $res["list"] = $list;
    $res["message"] = "取得資料成功！";
    $db_utils->response($start_time, $res, $user_link);
} else {

Exemplo n.º 3

Arquivo: view.php Projeto: sh932111/BrainProject

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);
$enWordID = $obj["enWordID"];
$db_utils = new DatabaseUtils();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $select_enWord = array("enWordID" => $enWordID);
    $select_obj = $db_utils->selectTableAnd($user_link, TableName::getENWordTable, $select_enWord);
    if (!$select_obj) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }
    $record = mysql_fetch_array($select_obj);
    $get["enWord"] = $record['enWord'];
    $get["enWordID"] = $record['enWordID'];
    $get["enTypeID"] = $record['enTypeID'];
    $get["create_time"] = $record['create_time'];
    $get["update_time"] = $record['update_time'];
    $definitionList = array();
    $translateList = array();
    $exampleList = array();
    $definitionDiry = $db_utils->selectTableAnd($user_link, TableName::getWordDefinitionTable, $select_enWord);
    while ($definitionRecord = mysql_fetch_array($definitionDiry)) {
        $getDefinition["enDefinitionID"] = $definitionRecord['enDefinitionID'];

Exemplo n.º 4

Arquivo: finish.php Projeto: sh932111/BrainProject

if (get_magic_quotes_gpc()) {
    $data = stripslashes($_POST['data']);
} else {
    $data = $_POST['data'];
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$isTest = $obj["isTest"];
/*1.測試模式0.英文模式*/
$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);
    $status = (int) $orderRecord['status'];
    if ($isTest != 1) {
        if ($status == 2) {
            $db_utils->responseError($start_time, "尚未上傳成績！請點擊上傳按鈕！", 209, $user_link);
        }
        if ($status == 4) {
            $db_utils->responseError($start_time, "已經結算過了！", 163, $user_link);
        }
    }
    $wordNum = (int) $orderRecord['wordNum'];
    $score = 100 / $wordNum;
    $selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
    if (!$selectDetail) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);

Exemplo n.º 5

Arquivo: view.php Projeto: sh932111/BrainProject

    $data = $_POST['data'];
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
if (!$orderID) {
    $db_utils->responseError($start_time, "get not found", 302, $user_link);
}
$showTranslate = $obj["showTranslate"];
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
    $res = array();
    $select_array = array("orderID" => $orderID);
    $selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
    $orderRecord = mysql_fetch_array($selectOrder);
    $res["orderID"] = $orderRecord['orderID'];
    $res["deviceAddress"] = $orderRecord['deviceAddress'];
    $res["userName"] = $orderRecord['userName'];
    $res["userYearOld"] = (int) $orderRecord['userYearOld'];
    $res["testTime"] = (int) $orderRecord['testTime'];
    $res["status"] = (int) $orderRecord['status'];
    $res["testResult"] = (int) $orderRecord['testResult'];
    $res["wordNum"] = (int) $orderRecord['wordNum'];
    $res["create_time"] = $orderRecord['create_time'];
    $res["update_time"] = $orderRecord['update_time'];
    $selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
    if (!$selectDetail) {
        $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
    }

Exemplo n.º 6

Arquivo: list.php Projeto: 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);
$status = $obj["status"];
$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("status" => $status);
    $selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
    $list = array();
    while ($orderRecord = mysql_fetch_array($selectOrder)) {
        $res["orderID"] = $orderRecord['orderID'];
        $res["deviceAddress"] = $orderRecord['deviceAddress'];
        $res["userName"] = $orderRecord['userName'];
        $res["userYearOld"] = (int) $orderRecord['userYearOld'];
        $res["testTime"] = (int) $orderRecord['testTime'];
        $res["status"] = (int) $orderRecord['status'];
        $res["testResult"] = (int) $orderRecord['testResult'];
        $res["wordNum"] = (int) $orderRecord['wordNum'];
        $res["create_time"] = $orderRecord['create_time'];
        $res["update_time"] = $orderRecord['update_time'];
        array_push($list, $res);
    }
    $over["list"] = $list;