ThinkPHP 8数组条件拼接exp条件问题解析

1948 阅读 0 评论 1 点赞

$query->whereRaw("FIND_IN_SET(?, rw_user_id)", [$this->uid]);

适用于链式调用，如：

Db::table('table_name')->whereRaw("FIND_IN_SET(?, rw_user_id)", [$this->uid])->select();

$where_w[] = ['', 'exp', Db::raw("FIND_IN_SET(?, rw_user_id)", [$this->uid])];

$where_w[] = function($query) {
    $query->whereRaw("FIND_IN_SET(?, rw_user_id)", [$this->uid]);};

if ($is_bdy == '1') {

$where[''] = Db::raw('a.bdcdn_url IS NOT NULL');

} else {

$where[''] = Db::raw('a.bdcdn_url IS NULL');

}