当时是想运用一个函数就能解决,但是百度了好久,都没有找到合适的,只能用sql中的find_in_set()方法,走的循环查询,下边粘一下代码。
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)';
}
}
}