PHP thinkphp like模糊搜索
public function vsearch($q){
$keywords = '%'.$q.'%';
$where['title|content'] = array('like',$keywords); //用like条件搜索title和content两个字段
$where['type']=2;
$Mposts=new \Home\Model\PostsModel;
$resarr=$Mposts->vsearch($where);
$this->assign('resarr',$resarr);
$this->display();
}
模型中的是
public function vsearch($where){
return $this->where($where)->select();
}