MySQL全文检索

    public function testKeywords(){
        $keywords = request()->param('keywords');
        $keywords = fenci($keywords);  // 调用百度分词
        $keywordsStr = "";
        for ($i = 0 ;$i<count($keywords);$i++){
            if($i==count($keywords)-1){
                $keywordsStr.="$keywords[$i]";
            }else{
                $keywordsStr.="$keywords[$i] ";
            }
        }
        echo $keywordsStr;
        $res = \think\Db::query("SELECT * FROM fa_love_chat WHERE MATCH (first_str) AGAINST ('{$keywordsStr}')");
    }

public function testKeywords(){ $keywords = request()->param('keywords'); $keywords = fenci($keywords); // 调用百度分词 $keywordsStr = ""; for ($i = 0 ;$i<count($keywords);$i++){ if($i==count($keywords)-1){ $keywordsStr.="$keywords[$i]"; }else{ $keywordsStr.="$keywords[$i] "; } } echo $keywordsStr; $res = \think\Db::query("SELECT * FROM fa_love_chat WHERE MATCH (first_str) AGAINST ('{$keywordsStr}')"); }