tp5 空格拆分关键词，多个关键词进行查询

tp5 空格拆分关键词，多个关键词进行查询

$data['keyword'] = preg_replace("/\s+/",' ',$data['keyword']);//所有空格替换成一个空格
    $keyarr=explode(' ',$data['keyword']);//以空格拆分成数组
    $whereSql = '';
    //拼接sql
    foreach ($keyarr as $k => $v) {
        $whereSql .= "  (artist_name like '%$v%' Or product_name like '%$v%')";
        if(count($keyarr) != $k + 1){
            $whereSql .= "Or";
        }
    }
    $whereSql = "and (".$whereSql.")";
    Db::query("select * from  tp_keyword where parent_id >0 ".$whereSql." ");