PHP class_DBOperation::fetch_obj Examples

Example #1

File: getChatList.php Project: ghostceo/MOMO_SERVER

$resultArr = $dbOperation->fetch_obj_arr($sql);
if (!$resultArr) {
    $resultString = json_encode(QUERY_FAILD);
    echo $resultString;
    return;
}
if (count($resultArr) == 0) {
    $resultString = json_encode(QUERY_RESULT_IS_NULL);
    echo $resultString;
} else {
    for ($i = 0; $i < count($resultArr); $i++) {
        $uid = $resultArr[$i]->sender_id;
        $sql = "select * from lbs_member where userid='{$uid}'";
        $checkResult = $dbOperation->query($sql);
        if ($checkResult) {
            $resultObj = $dbOperation->fetch_obj($checkResult);
            if ($resultObj) {
                $sender_name = $resultObj->username;
                $resultArr[$i]->sender_name = $sender_name;
            }
        }
        $uid = $resultArr[$i]->recver_id;
        $sql = "select * from lbs_member where userid='{$uid}'";
        $checkResult = $dbOperation->query($sql);
        if ($checkResult) {
            $resultObj = $dbOperation->fetch_obj($checkResult);
            if ($resultObj) {
                $sender_name = $resultObj->username;
                $resultArr[$i]->recver_name = $sender_name;
            }
        }

Example #2

File: applyChewei.php Project: ghostceo/MOMO_SERVER

<?php

require 'Class_DBOperation.php';
require 'global.php';
$dbOperation = new class_DBOperation(DBHOST, DBUSER, DBPWD, DBNAME, DBCHARSET);
$uid = $_GET['uid'];
$id = $_GET['id'];
$sql = "select * from lbs_chewei_apply where chewei_id='{$id}' and apply_userid='{$uid}' ";
$checkResult = $dbOperation->query($sql);
$resultArr = $dbOperation->fetch_obj($checkResult);
if (!$resultArr) {
    $sql = "insert into lbs_chewei_apply(chewei_id,apply_userid,apply_time) values('{$id}','{$uid}',now()) ";
    $dbOperation->query($sql);
    $resultJson = json_encode(array('regTag' => 1));
    echo $resultJson;
    return;
} else {
    $resultJson = json_encode(array('regTag' => 0));
    echo $resultJson;
}