PHPackages lingxiang/laravel-elasticsearch - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. lingxiang/laravel-elasticsearch ActiveLibrary[Database & ORM](/categories/database) lingxiang/laravel-elasticsearch =============================== Use SQL statements to query elasticsearch 1.0.5(6y ago)41.6kMITPHPPHP >=7.0 Since Feb 14Pushed 6y ago2 watchersCompare [ Source](https://github.com/Ethennoob/laravel-elasticsearch)[ Packagist](https://packagist.org/packages/lingxiang/laravel-elasticsearch)[ Docs](https://github.com/Ethennoob/laravel-elasticsearch)[ RSS](/packages/lingxiang-laravel-elasticsearch/feed)WikiDiscussions master Synced 2d ago READMEChangelog (6)Dependencies (3)Versions (7)Used By (0) Laravel Elasticsearch ===================== [](#laravel-elasticsearch) 版本对应 ---- [](#版本对应) Elasticsearch Versionlaravel-elasticsearch Branch>= 7.01.\*Install ------- [](#install) You can install the package via composer: ``` composer require lingxiang/laravel-elasticsearch ``` Laravel ------- [](#laravel) 服务区提供者，门面配置 `config / app.php` ``` 'providers' => [ Lingxiang\Elasticsearch\LaravelServiceProvider::class ] ``` ``` 'aliases' => [ 'Elasticsearch' => Lingxiang\Elasticsearch\LaravelServiceFacade::class ] ``` 创建config配置search.php ``` php artisan vendor:publish --provider="Lingxiang\Elasticsearch\LaravelServiceProvider" ``` 简单上手 ---- [](#简单上手) ### Create [](#create) ``` $result = \Elasticsearch::index('index')->type('type')->create([ 'key' => 'value', 'key2' => 'value2', ]); ``` ### Update [](#update) ``` $result = \Elasticsearch::index('index')->type('type')->update('id',[ 'key' => 'value2', ]); dump($result); ``` ### Delete [](#delete) ``` $result = \Elasticsearch::index('index')->type('type')->delete('id'); dump($result); ``` ### Select [](#select) ``` //指定索引index和type $builder = \Elasticsearch::index('laisiou_test')->type('user'); //全查询，但因ES聚合查询引擎的原因只能返回10条 $result = $builder->get(); //骚操作全查询 $result = $builder->take($builder->count())->get(); //根据id查询一条 注：查询不到则返回 null $result = $builder->whereTerm('id',1)->first(); //子条件查询 $result = $builder->where(function ($inQuery) { $inQuery->whereTerm('key',1)->orWhereTerm('key',2) })->whereTerm('key1',1)->get(); ``` ### 更多查询 [](#更多查询) skip / take ``` $builder->take(10)->get(); // or limit(10) $builder->offset(10)->take(10)->get(); // or skip(10) ``` term query ``` $builder->whereTerm('key',value)->first(); ``` match query ``` $builder->whereMatch('key',value)->first(); ``` range query ``` $builder->whereBetween('key',[value1,value2])->first(); ``` where in query ``` $builder->whereIn('key',[value1,value2])->first(); ``` logic query ``` $builder->whereTerm('key',value)->orWhereTerm('key2',value)->first(); ``` nested query ``` $result = $builder->where(function (Builder $inQuery) { $inQuery->whereTerm('key',1)->orWhereTerm('key',2) })->whereTerm('key1',1)->get(); ``` ### 所有可用条件方法 [](#所有可用条件方法) ``` public function select($columns): self ``` ``` public function where($column, $operator = null, $value = null, $leaf = 'term', $boolean = 'and'): self ``` ``` public function orWhere($field, $operator = null, $value = null, $leaf = 'term'): self ``` ``` public function whereMatch($field, $value, $boolean = 'and'): self ``` ``` public function orWhereMatch($field, $value, $boolean = 'and'): self ``` ``` public function whereTerm($field, $value, $boolean = 'and'): self ``` ``` public function whereIn($field, array $value) ``` ``` public function orWhereIn($field, array $value) ``` ``` public function orWhereTerm($field, $value, $boolean = 'or'): self ``` ``` public function whereRange($field, $operator = null, $value = null, $boolean = 'and'): self ``` ``` public function orWhereRange($field, $operator = null, $value = null): self ``` ``` public function whereBetween($field, array $values, $boolean = 'and'): self ``` ``` public function orWhereBetween($field, array $values): self ``` ``` public function orderBy(string $field, $sort): self ``` ``` public function scroll(string $scroll): self ``` ``` public function aggBy($field, $type): self ``` ``` public function select($columns): self ``` ### 获取结果的方法 [](#获取结果的方法) ``` public function get(): Collection ``` ``` public function paginate(int $page, int $perPage = 15): Collection ``` ``` public function first() ``` ``` public function byId($id) ``` ``` public function byIdOrFail($id): stdClass ``` ``` public function chunk(callable $callback, $limit = 2000, $scroll = '10m') ``` ``` public function create(array $data, $id = null, $key = 'id'): stdClass ``` ``` public function update($id, array $data): bool ``` ``` public function delete($id) ``` ``` public function count(): int ``` ### 日志 [](#日志) ``` $builder->enableQueryLog(); ``` ### Elastisearch object [](#elastisearch-object) ``` \Elasticsearch::getElasticSearch() // 或者 \Elasticsearch::search() ``` License ------- [](#license) [MIT license](https://opensource.org/licenses/MIT) ### Health Score 28 — LowBetter than 54% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity19 Limited adoption so far Community4 Small or concentrated contributor base Maturity56 Maturing project, gaining track record How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~5 days Total 6 Last Release 2254d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/ceb80170985c799151d8bccae93597133af87ee1c38f8ce9662e55a21ad251d7?d=identicon)[lingxiang](/maintainers/lingxiang) --- Tags phplaravelelasticsearchormsql ### Embed Badge ![Health badge](/badges/lingxiang-laravel-elasticsearch/health.svg) ``` [![Health](https://phpackages.com/badges/lingxiang-laravel-elasticsearch/health.svg)](https://phpackages.com/packages/lingxiang-laravel-elasticsearch) ``` ### Alternatives [illuminate/database The Illuminate Database package. 2.8k52.4M9.4k](/packages/illuminate-database)[crcms/elasticsearch Use SQL statements to query elasticsearch 1058.3k1](/packages/crcms-elasticsearch)[basemkhirat/elasticsearch Laravel, Lumen and Native php elasticseach query builder to build complex queries using an elegant syntax 402312.0k](/packages/basemkhirat-elasticsearch)[pdphilip/elasticsearch An Elasticsearch implementation of Laravel's Eloquent ORM 145360.2k4](/packages/pdphilip-elasticsearch)[matchory/elasticsearch The missing elasticsearch ORM for Laravel! 3059.0k](/packages/matchory-elasticsearch)[crcms/repository Detached model and controller warehouse data provider 674.4k3](/packages/crcms-repository) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)