//$keyword是用户输入的搜索词 $fenci=file_get_contents("http://116.196.101.207/get.php?source=".$keyword."¶m1=0¶m2=1&json=1"); $fenci_array=json_decode($fenci,true); $key_a=array(); $where="create_time >= 0 and categories !=55 and categories !=56 "; $order_str=""; //利用返回的搜索结果拼接sql搜索条件 if(!empty($fenci_array)) { foreach ($fenci_array as $key=>$val) { $key_a[$key]=$val["t"]; $where.=" OR post_title like '%{$val["t"]}%' OR post_content like '%{$val["t"]}%'"; $order_str.="((CASE WHEN `post_title` LIKE '%{$val["t"]}%' then ".(1000-10*$key)." else 0 end)+(CASE WHEN `post_content` LIKE '%{$val["t"]}%' then ".(1000-10*$key)." else 0 end))+"; } $order_str=rtrim($order_str,'+')." DESC"; } else { $order_str=" create_time DESC"; } //$sql="select * from cmf_portal_post $where $order_str"; //echo $sql;exit; $article_list=Db::name("portal_post")->where($where)->order($order_str)->paginate(10);
如果本文对你有帮助,欢迎打赏本站