use yii\sphinx\Query;
use yii\sphinx\MatchExpression;

$rows = (new Query())
    ->match(new MatchExpression('@title :title', ['title' => 'Yii']))
    ->all();

use yii\sphinx\Query;
use yii\sphinx\MatchExpression;

$rows = (new Query())
    ->match(
        // produces '((@title "Yii") (@author "Paul")) | (@content "Sphinx")' :
        (new MatchExpression())
            ->match(['title' => 'Yii'])
            ->andMatch(['author' => 'Paul'])
            ->orMatch(['content' => 'Sphinx'])
    )
    ->all();

use yii\sphinx\Query;
use yii\sphinx\MatchExpression;

$rows = (new Query())
    ->match(
        // produces '@title "Yii" MAYBE "Sphinx"' :
        (new MatchExpression())->match([
            'maybe',
            'title',
            'Yii',
            'Sphinx',
        ])
    )
    ->all();

$rows = (new Query())
    ->match(
        // produces '@title "Yii"~10' :
        (new MatchExpression())->match([
            'proximity',
            'title',
            'Yii',
            10,
        ])
    )
    ->all();

public string|array|yii\db\Expression $match = null

public array $params = []

__construct() public method

Constructor.

public void __construct ( $match = null, $params = [], $config = [] )
$match	string	The MATCH expression
$params	array	Expression parameters.
$config	array	Name-value pairs that will be used to initialize the object properties

addParams() public method

Adds additional parameters to be parsed into the query.

See also params().

public $this addParams ( $params )
$params	array	List of expression parameter values indexed by parameter placeholders. For example, [':name' => 'Dan', ':age' => 31].
return	$this	The expression object itself

andFilterMatch() public method (available since version 2.0.7)

Adds an additional MATCH condition to the existing one but ignores empty operands.

The new condition and the existing one will be joined using the 'AND' operator.

This method is similar to andMatch(). The main difference is that this method will remove empty query operands. As a result, this method is best suited for building query conditions based on filter values entered by users.

See also:

• filterMatch()
• orFilterMatch()

public $this andFilterMatch ( array $condition )
$condition	array	The new MATCH condition. Please refer to match() on how to specify this parameter.
return	$this	The query object itself

andMatch() public method

Adds an additional MATCH condition to the existing one.

The new condition and the existing one will be joined using the 'AND' (' ') operator.

See also:

• match()
• orMatch()

public $this andMatch ( $condition, $params = [] )
$condition	string|array|yii\db\Expression	The new MATCH condition. Please refer to match() on how to specify this parameter.
$params	array	The parameters (name => value) to be parsed into the query.
return	$this	The expression object itself

filterCondition() protected method (available since version 2.0.7)

Removes empty operands from the given query condition.

protected array filterCondition ( $condition )
$condition	array	The original condition
return	array	The condition with empty operands removed.

filterMatch() public method (available since version 2.0.7)

Sets the MATCH part of the query but ignores empty operands.

This method is similar to match(). The main difference is that this method will remove empty query operands. As a result, this method is best suited for building query conditions based on filter values entered by users.

The following code shows the difference between this method and match():

// MATCH (@title :title)
$query->filterMatch(['name' => null, 'title' => 'foo']);
// MATCH (@title :title)
$query->match(['title' => 20]);
// MATCH (@name :name @title :title)
$query->match(['name' => null, 'age' => 20]);

Note that unlike match(), you cannot pass binding parameters to this method.

See also:

• \yii\sphinx\where()
• andFilterMatch()
• orFilterMatch()

public $this filterMatch ( array $condition )
$condition	array	The conditions that should be put in the MATCH part. See match() on how to specify this parameter.
return	$this	The query object itself

isEmpty() protected method (available since version 2.0.7)

Returns a value indicating whether the give value is "empty".

The value is considered "empty", if one of the following conditions is satisfied:

• it is null,
• an empty string (''),
• a string containing only whitespace characters,
• or an empty array.

protected boolean isEmpty ( $value )
$value	mixed
return	boolean	If the value is empty

match() public method

Sets the MATCH expression.

The method requires a $condition parameter, and optionally a $params parameter specifying the values to be parsed into the expression.

The $condition parameter should be either a string (e.g. '@name "John"') or an array.

See also:

• andMatch()
• orMatch()

public $this match ( $condition, $params = [] )
$condition	string|array|yii\db\Expression	The conditions that should be put in the MATCH expression.
$params	array	The parameters (name => value) to be parsed into the query.
return	$this	The expression object itself

orFilterMatch() public method (available since version 2.0.7)

Adds an additional MATCH condition to the existing one but ignores empty operands.

The new condition and the existing one will be joined using the 'OR' operator.

This method is similar to orMatch(). The main difference is that this method will remove empty query operands. As a result, this method is best suited for building query conditions based on filter values entered by users.

See also:

• filterMatch()
• andFilterMatch()

public $this orFilterMatch ( array $condition )
$condition	array	The new MATCH condition. Please refer to match() on how to specify this parameter.
return	$this	The query object itself

orMatch() public method

Adds an additional MATCH condition to the existing one.

The new condition and the existing one will be joined using the 'OR' ('|') operator.

See also:

• match()
• andMatch()

public $this orMatch ( $condition, $params = [] )
$condition	string|array|yii\db\Expression	The new WHERE condition. Please refer to match() on how to specify this parameter.
$params	array	The parameters (name => value) to be parsed into the query.
return	$this	The expression object itself

params() public method

Sets the parameters to be parsed into the query.

See also addParams().

public $this params ( $params )
$params	array	List of expression parameter values indexed by parameter placeholders. For example, [':name' => 'Dan', ':age' => 31].
return	$this	The expression object itself