1. class
  2. XELOS
  3. \
  4. Framework
  5. \
  6. XF
  7. \
  8. DB
  9. \
  10. QueryBuilder
  11. \
  12. Condition

Condition

class Condition

Object to reflect SQL conditions

Constants

VALID_OPERATORS

UNESCAPED_VALUES

OP_EQUAL

OP_LESS

OP_GREATER

OP_UNEQUAL

OP_GREATER_OR_EQUAL

OP_LESS_OR_EQUAL

OP_LIKE

OP_NOT_LIKE

OP_NULL

OP_NOT_NULL

OP_IN

Methods

__construct(string $field, string $operator = null, mixed $value = null, bool $isRaw = false, bool $negate = false)

Condition constructor

string
__toString()

No description

bool|string
getField()

No description

string
getSQL()

No description

static Condition
where($field, $operator, $value)

No description

static Condition
whereEqual($field, $value)

No description

static ConditionGroup
whereGroup()

No description

static Condition
whereIsNotNull(string $field)

No description

static Condition
whereIsNull(string $field)

No description

static Condition
whereNot($field, $operator, $value)

No description

static Condition
whereNotEqual($field, $value)

No description

static Condition
whereRaw(string $rawSQL)

No description

Details

at line 50
protected __construct(string $field, string $operator = null, mixed $value = null, bool $isRaw = false, bool $negate = false)

Condition constructor

Cases:

  1. Full: All three parameters are being passed ($field, $operator, $value)
  2. Shortend Equal: Only parameter 1 and 2 are being passed which results in an simple equal condition ($field, $value)
  3. RAW Condition: Only parameter 1 is being passed

Parameters

string $field
string $operator
mixed $value
bool $isRaw
bool $negate

at line 98
string __toString()

No description

Return Value

string

at line 84
bool|string getField()

No description

Return Value

bool|string

at line 91
string getSQL()

No description

Return Value

string

at line 138
static Condition where($field, $operator, $value)

No description

Parameters

$field
$operator
$value

Return Value

Condition

at line 111
static Condition whereEqual($field, $value)

No description

Parameters

$field
$value

Return Value

Condition

at line 77
static ConditionGroup whereGroup()

No description

Return Value

ConditionGroup

at line 176
static Condition whereIsNotNull(string $field)

No description

Parameters

string $field

Return Value

Condition

at line 167
static Condition whereIsNull(string $field)

No description

Parameters

string $field

Return Value

Condition

at line 149
static Condition whereNot($field, $operator, $value)

No description

Parameters

$field
$operator
$value

Return Value

Condition

at line 124
static Condition whereNotEqual($field, $value)

No description

Parameters

$field
$value

Return Value

Condition

at line 158
static Condition whereRaw(string $rawSQL)

No description

Parameters

string $rawSQL

Return Value

Condition