PHPackages                             ahmedkhan847/mysqlwithelasticsearch - 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. [Search & Filtering](/categories/search)
4. /
5. ahmedkhan847/mysqlwithelasticsearch

ActiveLibrary[Search & Filtering](/categories/search)

ahmedkhan847/mysqlwithelasticsearch
===================================

A small package to connect MySQL with Elasticsearch

2.0.0(9y ago)392.1k11[2 issues](https://github.com/ahmedkhan847/mysqlwithelasticsearch/issues)MITPHPCI failing

Since Jan 27Pushed 4y ago3 watchersCompare

[ Source](https://github.com/ahmedkhan847/mysqlwithelasticsearch)[ Packagist](https://packagist.org/packages/ahmedkhan847/mysqlwithelasticsearch)[ RSS](/packages/ahmedkhan847-mysqlwithelasticsearch/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (2)Versions (5)Used By (0)

Connect MySQL With Elasticsearch using PHP
==========================================

[](#connect-mysql-with-elasticsearch-using-php)

A small library to connect MySQL with Elasticsearch. Use it to sync data and do full text search.

Click here to find the [API documentation for v2](https://ahmedkhan847.github.io/mysqlwithelasticsearch)

Downloading the latest release
==============================

[](#downloading-the-latest-release)

Clone the library

`git clone -b release2 https://github.com/ahmedkhan847/mysqlwithelasticsearch`

Now, run `composer install` to install the required dependencies.

Or use composer to install complete package.

`composer require ahmedkhan847/mysqlwithelasticsearch:2.*`

What's in release2?
-------------------

[](#whats-in-release2)

In release2 package is fully redesign. Now you don't need to pass $config file to constructor. You can set index, type, sql query, sql connection dyamically. Even now you can create your own function for searching in Elasticsearch. Let's see how you can achieve the following:

- [Mapping in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#mapping-in-elasticsearch)
- [Indexing All MySQL data in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#indexing-all-mysql-data-in-elasticsearch)
- [Indexing All MySQL data in Elasticsearch using MySqli Connection](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#indexing-all-mysql-data-in-elasticsearch-using-mysqli-connection)
- [Indexing Single Data in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#indexing-single-data-in-elasticsearch)
- [Updating in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#updating-in-elasticsearch)
- [Deleting in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#deleting-data-from-elasticsearch)
- [Searching in Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#searching-in-elasticsearch)
- [Creating your own search class for Elasticsearch](https://github.com/ahmedkhan847/mysqlwithelasticsearch/tree/master#creating-your-own-search-class-for-elasticsearch)

Mapping in Elasticsearch
------------------------

[](#mapping-in-elasticsearch)

```