yii2/TP 逗号查询

转载已于 2024-02-24 10:26:43 修改 · 219 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://blog.youkuaiyun.com/weixin_33713503/article/details/89804906

文章标签：

#linux #html #运维 #php

于 2023-04-20 16:25:14 首次发布

TP 逗号数据库逗号隔开与逗号隔开的条件匹配
if(!empty($select_id)){
    $select_arr = explode(',',implode(',',$select_id));
    foreach ($select_arr as $key => $value) {
        if($key == 0){
            $where_str = 'find_in_set('.$value.',category)';
        }else{
            $where_str = $where_str.' and find_in_set('.$value.',category)';
            }
     }
}



$newWhere = ' FIND_IN_SET("468", b.fangCharachteristic)';

Yii2多个关键字查询

$kw=explode(',',$data['keyword']);

foreach($kw as $k=>$v){
    if($k==0){
        $wheres[] = 'or';
        $wheres[] = 'FIND_IN_SET(:id'.$k.',keyword)';
    }else{
        $wheres[] = 'FIND_IN_SET(:id'.$k.',keyword)';
    }
    $wheress[':id'.$k] = $v;
}
$query->where(
    $wheres
    , $wheress);

$query->asArray();
$datalike=$query->one();
echo $query->createCommand()->getRawSql();