db\QueryTrait andFilterWhere()

andFilterWhere() public method

Adds an additional WHERE 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 andWhere(). 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.

public $this andFilterWhere ( array $condition )
$condition	array	The new WHERE condition. Please refer to where() on how to specify this parameter.
return	$this	The query object itself

Popular Articles

db\QueryTrait $indexBy $indexBy public property The name of the column by which the query results should be indexed by. This can also be a callable (e.g. anonymous func

db\QueryTrait offset() offset() public method Sets the OFFSET part of the query. public $this offset ( $offset )$offset integer The offset. Use null or negative valu

db\QueryTrait $limit $limit public property Maximum number of records to be returned. If not set or less than 0, it means no limit. public integer $limit = null

db\QueryTrait normalizeOrderBy() normalizeOrderBy() protected method Normalizes format of ORDER BY data protected array normalizeOrderBy ( $columns )$columns array|string|yii\

db\QueryTrait $offset $offset public property Zero-based offset from where the records are to be returned. If not set or less than 0, it means starting from the beginn