$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; } }
<?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; }