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 filterWhere() filterWhere() public method Sets the WHERE part of the query but ignores empty operands. This method is similar to where(). The main difference i

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

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