tp3.2-使用join连表查询

yangdong

[PHP] 纯文本查看 复制代码

#查询所有数据$join = array('tp_sub_user on tp_coin_account.user_id = tp_sub_user.sub_user_id');  #join数据
        $coin_account_data = $coin_account_obj->getCoinAccountList('',$where,'addtime DESC','',$join);

修改Model的对应方法：

[PHP] 纯文本查看 复制代码

public function getCoinAccountNum($where = '',$join = array())
    {
        if(count($join)){
            foreach ($join as $v){
                $this->join($v);
            }
        }
        return $this->where($where)->count();
    }