PHP searches based on ElasticSearch

ElasticSearch is a search server based on Lucene. It provides a distributed multi-user capable full-text search engine based on a RESTful web interface. Developed in Java and released as open source under the terms of the Apache license, Elasticsearch is a popular enterprise-level search engine. Designed for use in cloud computing, it can achieve real-time search, is stable, reliable, fast, and is easy to install and use.

Course Recommendation →: "Elasticsearch Full Text Search Practical Combat" (Practical Video)

From the course "Concurrency Solution for Tens of Millions of Data (Theory and Practical Combat)"

PHP Search Based on ElasticSearch

Doing Search I thought of ElasticSearch , and it also supports PHP, so I made a simple example for testing. It felt good and I made a record.

Environment

php 7.2

elasticsearch 6.2 Download

elasticsearch-php 6 Download

Install elasticsearch

Download the source file, unzip it, create a new user, and change the directory's group to this user, because elasticsearch cannot be started with the root user.

wget https://artifacts.elastic.co/downloads/elasticsearch/elasticsearch-6.2.3.tar.gz
tar zxvf elasticsearch-6.2.3.tar.gz
useradd elasticsearch
password elasticsearch
chown elasticsearch:elasticsearch elasticsearch-6.2.3
cd elasticsearch-6.2.3
./bin/elasticsearch  // 启动

Install PHP extension

I am using composer Install elasticsearch-php. Add "elasticsearch/elasticsearch": "~6.0" to the composer.json file and execute composer update.

{
  "require": {
    // ...
    "elasticsearch/elasticsearch": "~6.0"
    // ...
  }
}

Test example

Create table and test data

I have prepared an article table for testing. The first is to create a table, and then write the test data. After the preparation is completed, start editing the test cases.

create table articles(
  id int not null primary key auto_increment,
  title varchar(200) not null comment '标题',
  content text comment '内容'
);
insert into articles(title, content) values ('Laravel 测试1', 'Laravel 测试文章内容1'),
('Laravel 测试2', 'Laravel 测试文章内容2'),
('Laravel 测试3', 'Laravel 测试文章内容3');

Read data from Mysql

try {
  $db = new PDO('mysql:host=127.0.0.1;dbname=test', 'root', 'root');
  $sql = 'select * from articles';
  $query = $db->prepare($sql);
  $query->execute();
  $lists = $query->fetchAll();
  print_r($lists);
} catch (Exception $e) {
  echo $e->getMessage();
}

Instantiation

require './vendor/autoload.php';
use Elasticsearch\ClientBuilder;
$client = ClientBuilder::create()->build();

Explanation of noun: Index is equivalent to MySQL The table in , the document is equivalent to the row record in MySQL

elasticsearch ’s dynamic nature, the index is automatically created when the first document is added and some default settings.

Add document to index

foreach ($lists as $row) {
  $params = [
    'body' => [
      'id' => $row['id'],
      'title' => $row['title'],
      'content' => $row['content']
    ],
    'id' => 'article_' . $row['id'],
    'index' => 'articles_index',
    'type' => 'articles_type'
  ];
  $client->index($params);
}

Get document from index

$params = [
  'index' => 'articles_index',
  'type' => 'articles_type',
  'id' => 'articles_1'
];
$res = $client->get($params);
print_r($res);

Delete document from index

$params = [
  'index' => 'articles_index',
  'type' => 'articles_type',
  'id' => 'articles_1'
];
$res = $client->delete($params);
print_r($res);

Delete index

$params = [
    'index' => 'articles_index'
];
$res = $client->indices()->delete($params);
print_r($res);

Create index

$params['index'] = 'articles_index';  
$params['body']['settings']['number_of_shards'] = 2;  
$params['body']['settings']['number_of_replicas'] = 0;  
$client->indices()->create($params);

Search

$params = [ 
  'index' => 'articles_index',
  'type' => 'articles_type',
];      
$params['body']['query']['match']['content'] = 'Laravel';
$res = $client->search($params);
print_r($res);

The above is the detailed content of PHP searches based on ElasticSearch. For more information, please follow other related articles on the PHP Chinese website!