// 多个不定量模糊查询
$yuanhuohao = trim(I('yuanhuohao'));// 接受的变量我的是以空格分开
$yuanhuohao_arr = explode(' ',$yuanhuohao);// 分割成数组
$tmpArr = array();
//方法一
foreach($yuanhuohao_arr as $key =>$val) {
array_push($tmpArr, array('like','%'.$val.'%'));
}
array_push($tmpArr,'or');
$map['stoneno'] = $tmpArr;
// 方法二
foreach($yuanhuohao_arr as $key =>$val) {
array_push($tmpArr, '%'.$val.'%');
}
$map['stoneno'] = array('like',$tmpArr,'or');
使用场景: