tops();//栏目信息
$ta = $this->tags();//标签信息
$this->assign([
'column'=>$column,//栏目信息
'ta'=>$ta,//标签信息
]);
}
protected function tops(){//头部栏目数据
$co = db('column')->order('id asc')->select();
return $co;
}
protected function tags(){//热门标签
$tag = db('article')->field('id,keywords')->where('keywords','not null')->select();
//***解决重复关键词(keywords)只显示其中的一个
$qc=[];
foreach ($tag as $ka){
$key = explode(",",$ka['keywords']);
foreach ($key as $k){
$qc[]=$k;
}
}
$tags = array_unique($qc);
//_______________________________________________end
return $tags;
}
public function search(){//热门标签搜索
$keywords=input('keywords');
if($keywords){
$map['title']=['like','%'.$keywords.'%'];
$ke['keywords']=['like','%'.$keywords.'%'];
$searchres=db('article')->where($map)->whereOr($ke)->select();
$this->assign(array(
'searchres'=>$searchres,
'keywords'=>$keywords,
));
}else{
echo "";
}
return view();
}
public function searchtop(){//头部关键词搜索
if(request()->isPost()) {
$keywords = input('keywords');
if($keywords){
$map['title']=['like','%'.$keywords.'%'];
$ke['keywords']=['like','%'.$keywords.'%'];
$search=db('article')->where($map)->whereOr($ke)->select();
if($search){
$this->assign(array(
'search'=>$search,
'keywords'=>$keywords,
));
}else{
$this->assign(array(
'search'=>null,
'keywords'=>'没有搜索到关键词!',
));
}
}
}else{
echo "";
}
return view();
}
}