Elasticsearch在thinkphp5中的使用（模糊查詢）

需要安裝elasticsearch、elastic-header-master、kibana、analysis-ik四個包，如下圖所示：（需要的包直接去github上搜索就可以，至于安裝教程可以在csdn上搜，看好是按照在win還是linux上的，最主要的是按照會遇到很多問題，有錢首次安裝會生成一個賬號、密碼、和code，記得保存在電腦上，首次啟用kibaba時需要輸入才可運行，記得安裝好jdk>=1.8的版本，前提條件，所有安裝的包都要對應相同的版本，否則在plugings中的ik重啟就會失敗）

注意：千萬別去官網下載最新的，因為最新的那個下載后沒有對應的ik中文，配置的話，我以后再寫。也可以看別人的，我下載的是7.17.2的包，大于8的可能或多或少的出現問題。只針對于thinkphp5的Elasticsearch的增刪改查。

一、創建索引

public function index(){$es = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();$params = ['index' => 'movies',//類似于庫名'body' => ['settings' => ['number_of_shards' => 3,'number_of_replicas' => 2],'mappings' => ['_source' => ['enabled' => true],'properties' => ['title' => ['type' => 'text',"analyzer" => "ik_max_word","search_analyzer" => "ik_max_word"]]]]];//執行創建$r = $es->indices()->create($params);dump($r);}

二、索引中新增數據

public function add_movies_data(){$data = Movies::select();//查詢數據$res = (new Collection($data))->toArray();$es = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();foreach ($res as $k=>$v){$params = ['index' =>'movies',//索引'type' =>'_doc',//表(額外需要注意的，這里是固定的寫法)'id' => $v['id'],//主鍵'body' =>$v//數據];$r = $es->index($params);}echo 'success';}

三、實現在Elasticsearch中數據的搜索（使得搜索的關鍵字高亮）

public function search_movies(){$word = input('word');//接收關鍵字$page = input('page',1);//接收當前頁（如果沒接收到，默認是1）$size = 5;//每頁顯示條數$limit = ($page-1)*$size;//偏移量$client = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();//創建es實例//設置查詢的條件$params = ['index' => 'movies',//索引（類似于庫）//'type' => '_doc','body' => [//查詢內容'query' => ['match' => [//匹配'title' => $word//匹配字段]],'highlight' => [//高亮'pre_tags' => ["<em style='color: red'>"],//樣式自己寫'post_tags' => ["</em>"],'fields' => ["title" => new \stdClass()]]]];//分頁限制$params["size"] = $size;//每頁顯示條數$params["from"] = $limit;//偏移量$results = $client->search($params);//es搜索foreach ($results['hits']['hits'] as $k=>$v){$results['hits']['hits'][$k]['_source']['title'] = $v['highlight']['title'][0];}$data = array_column($results['hits']['hits'],'_source');$arr['data'] = $data;//數據$arr['page'] = $page;//當前頁$arr['total'] = $results['hits']['total']['value'];//總條數$arr['last_page'] = ceil($results['hits']['total']['value']/$size);//總頁數print_r($arr);//剩下的就是前端展示的事情了}

前端頁面展示：

elasticsearch索引展示：

我將代碼復制到此處：
Controller中的代碼：

public function first(){$es = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();$params = ['index' => 'movies01',//類似于庫名'body' => ['settings' => ['number_of_shards' => 3,'number_of_replicas' => 2],'mappings' => ['_source' => ['enabled' => true],'properties' => ['title' => ['type' => 'text',"analyzer" => "ik_max_word","search_analyzer" => "ik_max_word"],'goods_name' => [//goods_name 文檔名稱 相當于mysql中的字段'type' => 'text',//text文本'analyzer' => 'ik_max_word',//analyzer 指定分詞器為ik'search_analyzer'=>'ik_max_word',//指定搜索時的分詞器],'goods_logo' => ['type' => 'text'],'goods_price' => ['type' => 'text',//text文本],'goods_desc' => ['type' => 'text',//text文本'analyzer' => 'ik_max_word',//analyzer 指定分詞器為ik'search_analyzer'=>'ik_max_word'//指定搜索時的分詞器],'goods_remark' => ['type' => 'text',//text文本'analyzer' => 'ik_max_word',//analyzer 指定分詞器為ik'search_analyzer'=>'ik_max_word'//指定搜索時的分詞器],"news_source"=>["type"=>"text","fielddata"=>true]]]]];//執行創建$r = $es->indices()->create($params);dump($r);}public function add_movies_data(){$data = Goods::select();//查詢數據$res = (new Collection($data))->toArray();$es = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();foreach ($res as $k=>$v){$params = ['index' =>'movies01',//索引'type' =>'_doc',//表(額外需要注意的，這里是固定的寫法)'id' => $v['id'],//主鍵'body' =>$v//數據];$r = $es->index($params);}echo 'success';}public function search_movies($word){header("Access-Control-Allow-Origin:*");header("Access-Control-Allow-Methods:GET, POST, OPTIONS, DELETE");header("Access-Control-Allow-Headers:DNT,X-Mx-ReqToken,Keep-Alive,User-Agent,X-Requested-With,If-Modified-Since,Cache-Control,Content-Type, Accept-Language, Origin, Accept-Encoding");// $word = input('word');//接收關鍵字$page = input('page',1);//接收當前頁（如果沒接收到，默認是1）$size = 5;//每頁顯示條數$limit = ($page-1)*$size;//偏移量$client = ClientBuilder::create()->setHosts(['127.0.0.1:9200'])->build();//創建es實例//設置查詢的條件$params = ['index' => 'movies01',//索引（類似于庫）//'type' => '_doc','body' => [//查詢內容'query' => ['match' => [//匹配'title' => $word//匹配字段]],'highlight' => [//高亮'pre_tags' => ["<em style='color: red'>"],//樣式自己寫'post_tags' => ["</em>"],'fields' => ["title" => new \stdClass()]]]];//分頁限制$params["size"] = $size;//每頁顯示條數$params["from"] = $limit;//偏移量$results = $client->search($params)->asArray();//es搜索foreach ($results['hits']['hits'] as $k=>$v){$results['hits']['hits'][$k]['_source']['title'] = $v['highlight']['title'][0];}$data = array_column($results['hits']['hits'],'_source');$arr['data'] = $data;//數據$arr['page'] = $page;//當前頁$arr['total'] = $results['hits']['total']['value'];//總條數$arr['last_page'] = ceil($results['hits']['total']['value']/$size);//總頁數 // print_r($arr);//剩下的就是前端展示的事情了return json($arr); // return view('index/index',compact('arr',$arr));}

數據庫數據展示：

前端代碼：

<html xmlns="http://www.w3.org/1999/xhtml"> <head><meta charset="utf-8"><title>xx信息查詢</title><script src="https://code.jquery.com/jquery-3.1.1.js"></script><script type="text/javascript" src="http://code.jquery.com/jquery-1.11.3.min.js"></script> </head> <body> <form><table id="table-search" width="80%" align="center" border="1"><tr><td>輸入關鍵字</td><td><input type="text" maxlength="50" name="word" id="word"></td></tr><td><input type="button" value="搜索" id="btSearch" class="ui right floated positive button btn-search"/></td></tr></table> </form> <br/> <table id="table-result" width="80%" align="center" border="1"><tr><th>貨物名稱</th><th>貨物圖標</th><th>貨物價格</th><th>貨物備注</th><th>分類</th></tr><tbody id="tbody-result"></tbody> </table> </body><script>$(function () {$('#btSearch').click(function () {var word = $('#word').val();var tbody = window.document.getElementById("tbody-result");$.ajax({type: "post",dataType: "json",url: "http://www.el.com/index.php/index/index/search_movies?word="+word,success: function (msg) {console.log(msg);if (msg) {var str = "";var data = msg.data;for (i in data) {str += "<tr>" +"<td align='center'>" + data[i].goods_name + "</td>" +"<td align='center'>" + data[i].goods_logo + "</td>" +"<td align='center'>" + data[i].goods_price + "</td>" +"<td align='center'>" + data[i].goods_remark + "</td>" +"<td align='center'>" + data[i].title + "</td>" +"</tr>";}document.getElementById('tbody-result').innerHTML = str;}},error: function () {alert("查詢失敗")}});});}); </script> </html>

總結

以上是生活随笔為你收集整理的Elasticsearch在thinkphp5中的使用增删改查（模糊查询、批量查询）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。