Constants

OP_CONTAINS

OP_CONTAINS

OP_NOT_CONTAINS

OP_NOT_CONTAINS

OP_STARTS_WITH

OP_STARTS_WITH

OP_ENDS_WITH

OP_ENDS_WITH

OP_EMPTY

OP_EMPTY

OP_NOT_EMPTY

OP_NOT_EMPTY

Properties

$columnName

$columnName : string

The name of the DB column you need to filter.

Type

string

$tableName

$tableName : string

The name of the table in which the filtered column is present.

Type

string

Methods

__construct()

__construct() 

This filter implementation can be instantiated in one of two ways:

1) By passing the table and column names, respectively 2) By passing an arbitrary SQL expression as an instance of \Dewdrop\Db\Expr

Throws

\Dewdrop\Db\Select\Filter\Exception

apply()

apply(\Dewdrop\Db\Select  $select,   $conditionSetName, array  $queryVars) 

Parameters

\Dewdrop\Db\Select $select
$conditionSetName
array $queryVars

getComparisonExpression()

getComparisonExpression(\Dewdrop\Db\Select  $select) 

Parameters

\Dewdrop\Db\Select $select

isExpr()

isExpr() : boolean

Returns

boolean

filterContains()

filterContains(\Dewdrop\Db\Select  $select,   $conditionSetName,   $value) 

Parameters

\Dewdrop\Db\Select $select
$conditionSetName
$value

filterNotContains()

filterNotContains(\Dewdrop\Db\Select  $select,   $conditionSetName,   $value) 

Parameters

\Dewdrop\Db\Select $select
$conditionSetName
$value

filterStartsWith()

filterStartsWith(\Dewdrop\Db\Select  $select,   $conditionSetName,   $value) 

Parameters

\Dewdrop\Db\Select $select
$conditionSetName
$value

filterEndsWith()

filterEndsWith(\Dewdrop\Db\Select  $select,   $conditionSetName,   $value) 

Parameters

\Dewdrop\Db\Select $select
$conditionSetName
$value

filterEmptyOrNotEmpty()

filterEmptyOrNotEmpty(  $operator, \Dewdrop\Db\Select  $select,   $conditionSetName) 

Parameters

$operator
\Dewdrop\Db\Select $select
$conditionSetName

isValidOperator()

isValidOperator(  $operator) 

Parameters

$operator