phpcms v9搜索结果缺少及搜索信息不准确
时间：2021-08-13 17:57:08  点击: 来源：  作者：

if(!empty($segment_q)) {
        $sql = "`siteid`= $siteid AND `typeid` = $typeid $sql_time AND MATCH (`data`) AGAINST ($segment_q IN BOOLEAN MODE)";
}else {
        $sql = "`siteid`= $siteid AND `typeid` = $typeid $sql_time AND `data` like %$q%";
}

if(!empty($segment_q)) {
        $length = strlen($segment_q);
        $q_key = "'".$segment_q."'";
        if($length>=9){
                $sql = "`siteid`= '1' AND `typeid` = '$typeid' AND (SELECT (LENGTH(`data`)-LENGTH(REPLACE(`data`,$q_key,'')))) >17";              
        }else{
                $sql = "`siteid`= '1' AND `typeid` = '$typeid' AND (SELECT (LENGTH(`data`)-LENGTH(REPLACE(`data`,$q_key,'')))) >11";              
        }                              
} else {
        $sql = "`siteid`= '$siteid' AND `typeid` = '$typeid' AND `data` like '%$q%'";                                      
}

phpcms v9各版本下载可前往本站下载点 :

https://mirror.cnop.net/?search=phpcms

”您可通过以下微信二维码，赞赏作者“

 

发表评论 共有条评论 用户名: 密码: 验证码: 匿名发表