$queryData = Db::connect('数据库')->table('表')->where(function($query)use($userId,$v) {
$query->where(['goodId'=>$v['wxId'],'userId'=>$userId,'status'=>'1']);
})->whereor(function($query)use($userId,$v){
$query->where(['goodId'=>$v['wxId'],'userId'=>$userId,'status'=>'2']);
})->field('wxId,字段')->find();
tp5 whereor多条件查询。记录一下。其中use中匿名函数传递参数。
$list = Db::table('page')->select();
$list_length = count($list);
$this->assign('list_length',$list_length);
多个活动 合并起来给前端,老板天天加东西。。。
$goodInfo=Db::connect('数据库')->query('SELECT o.userId, o.createAt, u.avatUrl, u.nickName
FROM 表1 o
LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.payStatus = '已付款'
AND o.directorId = '''.$userId.'''
UNION ALL
SELECT o.userId, o.createAt, u.avatUrl, u.nickName
FROM 表2 o
LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.memCashId = '''.$memId[''wxId''].'''');
$page=($page-1)*20;
$goodInfo=Db::connect('数据库')->query("SELECT *
FROM (
SELECT o.preGoodNum, o.goodNum, o.userId, o.createAt AS payTime, u.avatUrl
, u.nickName, o.goodTitle
FROM 表1 o
LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.payStatus = '已付款'
AND o.directorId = Id
ORDER BY o.createAt DESC
) a
UNION ALL
SELECT *
FROM (
SELECT o.sumTimes AS preGoodNum, o.remainTimes AS goodNum, o.userId, o.createAt AS payTime, u.avatUrl
, u.nickName, o.describe AS goodTitle
FROM 表2 o
LEFT JOIN 表0 u ON o.userId = u.wxId
WHERE o.memCashId = 'wxId'
ORDER BY o.createAt DESC
) b
ORDER BY payTime DESC
LIMIT $page, 20");