PHP dbex::getALL方法代码示例

function money_get_user_money($user_id)
{
    global $tablePreStr;
    $t_money = $tablePreStr . "money";
    $result_rs = array();
    $dbo = new dbex();
    dbplugin('r');
    /*select isns_money.*, isns_users.user_point from iwebsns.isns_money, isns_users where isns_users.user_id=isns_money.user_id and isns_money.user_id=1;*/
    $sql = "select {$t_money}.* from {$t_money} where {$t_money}.user_id={$user_id}";
    $result_rs = $dbo->getALL($sql);
    return $result_rs;
}

function pals_sort($uid = '')
{
    $uid = intval($uid);
    if ($uid == 0) {
        $uid = get_sess_userid();
    }
    global $tablePreStr;
    $t_pals_sort = $tablePreStr . "pals_sort";
    $result_rs = array();
    $dbo = new dbex();
    dbplugin('r');
    $sql = " select * from {$t_pals_sort} where user_id={$uid} ";
    $result_rs = $dbo->getALL($sql);
    return $result_rs;
}

function message_get_affair_uid($id, $type = '', $num = 20)
{
    $limit = intval($num) ? " limit {$num} " : "";
    $type_str = filt_num_array($type);
    $id_str = filt_num_array($id);
    $sql_type = "";
    if ($type_str != '') {
        $sql_type = " and mod_type in ({$type_str}) ";
    }
    global $tablePreStr;
    $t_recent_affair = $tablePreStr . "recent_affair";
    $result_rs = array();
    $dbo = new dbex();
    dbplugin('r');
    $sql = "select * from {$t_recent_affair} where user_id in ({$id_str}) {$sql_type} order by id desc {$limit} ";
    $result_rs = $dbo->getALL($sql);
    return $result_rs;
}

function paper_get_pick_reasons($paper_id, $user_id)
{
    $paper_is_owned_user = paper_get_is_owned_user($user_id, $paper_id);
    global $tablePreStr;
    $t_users = $tablePreStr . "users";
    $t_comments = $tablePreStr . "comments";
    //评论类型
    $comment_type = 0;
    $paper_pick_reason_rs = array();
    $dbo = new dbex();
    dbplugin('r');
    $paper_comments_sql = "";
    if (1 == $paper_is_owned_user) {
        $paper_comments_sql = "select {$t_users}.*, {$t_comments}.* \n\tfrom {$t_comments}, {$t_users} where {$t_users}.user_id = {$t_comments}.commenter_id \n\tand {$t_comments}.paper_id = {$paper_id} and ({$t_comments}.comment_type=1 or {$t_comments}.comment_type=2) order by {$t_comments}.comment_time";
    } else {
        $paper_is_user_picked = paper_get_is_user_picked($paper_id, $user_id);
        if (1 == $paper_is_user_picked) {
            /*select isns_users.*, isns_comments.* 
            from isns_comments, isns_users where isns_users.user_id = isns_comments.commenter_id and isns_comments.commenter_id = 2
            and isns_comments.paper_id = 111113 and (isns_comments.comment_type=1 or isns_comments.comment_type=2) 
            order by isns_comments.comment_time*/
            $paper_comments_sql = "select {$t_users}.*, {$t_comments}.* \n\tfrom {$t_comments}, {$t_users} where {$t_users}.user_id = {$t_comments}.commenter_id and {$t_comments}.commenter_id = {$user_id}\n\tand {$t_comments}.paper_id = {$paper_id} and ({$t_comments}.comment_type=1 or {$t_comments}.comment_type=2) order by {$t_comments}.comment_time";
        } else {
            return null;
        }
    }
    $paper_pick_reason_rs = $dbo->getALL($paper_comments_sql);
    $re_pick_reasons = array();
    foreach ($paper_pick_reason_rs as $_ => $paper_reason) {
        $commenter_id = $paper_reason['commenter_id'];
        if (null == $re_pick_reasons[$commenter_id]) {
            $re_pick_reasons[$commenter_id] = array();
        }
        $re_pick_reasons[$commenter_id][] = $paper_reason;
    }
    return $re_pick_reasons;
}

<?php

require "api/base_support.php";
//引入语言包
$pu_langpackage = new publiclp();
//变量取得
$least_paper_id = get_argg("least_paper_id");
//返回数量
$return_num = 10;
$result = array();
if ($least_paper_id <= 0) {
    echo json_encode($result);
}
//数据表定义区
$t_papers = $tablePreStr . "papers";
$t_users = $tablePreStr . "users";
$dbo = new dbex();
dbplugin('r');
$get_more_papers_sql = "select {$t_papers}.*, {$t_users}.* from {$t_papers}, {$t_users} where {$t_users}.user_id={$t_papers}.user_id and {$t_papers}.paper_id < {$least_paper_id} limit {$return_num}";
//						  select isns_papers.*, isns_users.user_name from isns_papers, isns_users where isns_users.user_id=isns_papers.user_id and isns_papers.paper_id < 222239 limit 2;
//$get_more_papers_sql = "select * from $t_papers where $t_papers.paper_id < $least_paper_id limit $return_num";
$result = $dbo->getALL($get_more_papers_sql);
$result = calc_all_distance($result);
echo json_encode($result);

function paper_related_last_paper()
{
    global $tablePreStr;
    $t_papers = $tablePreStr . "papers";
    $result_rs = array();
    $dbo = new dbex();
    dbplugin('r');
    $sql = "select * from {$t_papers} where picture is not null and picture <> '' order by paper_id desc limit 5";
    $result_rs = $dbo->getALL($sql);
    return $result_rs;
}