Query Builder for Elasticsearch

composer require whereof/elastic-builder

//需要自行安装 https://github.com/elastic/elasticsearch-php
composer require elasticsearch/elasticsearch version 

setHosts($host)->setSSLVerification(false)->build(); $build = Elastic::getInstance($client)->index('table'); // select id,name form table where (name="whereof" or title="whereof") and password="whereof" and status BETWEEN 1 AND 2 order by id desc $rest = $build->field(['id', 'name'])->where('name|title', 'whereof')->where('password', "whereof")->whereBetween('status', 1, 2)->order('id', 'desc')->search();">

$host   = [
    "127.0.0.1:9200",
];
$client = ClientBuilder::create()->setHosts($host)->setSSLVerification(false)->build();
$build  = Elastic::getInstance($client)->index('table');

// select id,name form table where (name="whereof" or title="whereof") and password="whereof" and status BETWEEN 1 AND 2 order by id desc 
$rest    = $build->field(['id', 'name'])->where('name|title', 'whereof')->where('password', "whereof")->whereBetween('status', 1, 2)->order('id', 'desc')->search();