/*根据关键词搜索文章*/
public function search($key = '百岁', $status = 1){
$perfix = C('DB_PREFIX');
/*用OR拼接LIKE语句*/
$map['_logic'] = 'OR';
$map['title'] = array('like', '%'.$key.'%');
$map['description'] = array('like', '%'.$key.'%');
$map['id'] = array('IN', 'SELECT id FROM `'.$perfix.'document_article` WHERE content LIKE %'.$key.'%');
/*拼接AND语句*/
$maps['_complex'] =$map;
$maps['status'] = '1';
$maps['id'] = array('NOT IN', '4,15');
$temp = $this->field(true)->where($maps)->select();
dump($temp);
} 最佳答案
