phpcms v9搜索结果缺少及搜索信息不准确

打开 phpcms/modules/search/index.php
找到:

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

发表评论

您的邮箱地址不会被公开。