9951 explained code solutions for 126 technologies

sphinxsearchHow do I integrate Sphinxsearch with Yii2?

Integrating Sphinxsearch with Yii2 is fairly simple and can be done in a few steps.

  1. Install the sphinx-yii2 extension.

  2. Configure the extension in the config/web.php file:

'sphinx' => [
    'class' => 'yii\sphinx\Connection',
    'dsn' => 'mysql:host=;port=9306;',
    'username' => '',
    'password' => '',
  1. Create a model that extends yii\sphinx\ActiveRecord and define your searchable attributes:
class MyModel extends \yii\sphinx\ActiveRecord
    public function attributes()
        return ['id', 'title', 'description'];
  1. Create a search query using the model:
$query = MyModel::find()
    ->match('title', 'My Title')
  1. Execute the query and get the results:
$results = $query->all();

foreach ($results as $result) {
    echo $result->title;

This is the basic workflow for integrating Sphinxsearch with Yii2. For more information, please see the sphinx-yii2 extension documentation.

Edit this code on GitHub