tp5查询or and联合whereor

 $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");