Documentation

Query
in package

Table of Contents

INNER_JOIN  = 'inner'
LEFT_JOIN  = 'left'
OUTER_JOIN  = 'full outer'
RIGHT_JOIN  = 'right'
$conditions  : array<string|int, mixed>
$fields  : array<string|int, mixed>
$from  : string|Query
$groups  : array<string|int, mixed>
$joins  : array<string|int, mixed>
$max  : int
$offset  : int
$orders  : array<string|int, mixed>
$variables  : array<string|int, mixed>
__construct()  : mixed
addCondition()  : void
addFields()  : void
addGroupBy()  : void
addInnerJoin()  : void
addJoin()  : void
addOrderBy()  : void
addVariables()  : void
conditions()  : array<string|int, mixed>
fields()  : array<string|int, mixed>
from()  : string|Query
groupBy()  : array<string|int, mixed>
joins()  : array<string|int, mixed>
max()  : int
offset()  : int
orderBy()  : array<string|int, mixed>
setFields()  : void
setLimit()  : void
variables()  : array<string|int, mixed>
allFields()  : array<string|int, mixed>
shouldSelectAllFields()  : bool

Constants

INNER_JOIN

public mixed INNER_JOIN = 'inner'

LEFT_JOIN

public mixed LEFT_JOIN = 'left'

OUTER_JOIN

public mixed OUTER_JOIN = 'full outer'

RIGHT_JOIN

public mixed RIGHT_JOIN = 'right'

Properties

$conditions

protected array<string|int, mixed> $conditions = []

$fields

protected array<string|int, mixed> $fields = []

$groups

protected array<string|int, mixed> $groups = []

$joins

protected array<string|int, mixed> $joins = []

$max

protected int $max = -1

$offset

protected int $offset = -1

$orders

protected array<string|int, mixed> $orders = []

$variables

protected array<string|int, mixed> $variables = []

Methods

__construct()

public __construct(string|Query $from) : mixed
Parameters
$from : string|Query
Return values
mixed —

addCondition()

public addCondition(string $condition[, array<string|int, mixed> $variables = [] ]) : void
Parameters
$condition : string
$variables : array<string|int, mixed> = []
Return values
void —

addFields()

public addFields(array<string|int, mixed> $fields) : void
Parameters
$fields : array<string|int, mixed>
Return values
void —

addGroupBy()

public addGroupBy(string $name) : void
Parameters
$name : string
Return values
void —

addInnerJoin()

public addInnerJoin(string|array<string|int, mixed> $from, string $condition[, array<string|int, mixed> $variables = [] ]) : void
Parameters
$from : string|array<string|int, mixed>
$condition : string
$variables : array<string|int, mixed> = []
Return values
void —

addJoin()

public addJoin(string $type, string|array<string|int, mixed> $from, string $condition[, array<string|int, mixed> $variables = [] ]) : void
Parameters
$type : string
$from : string|array<string|int, mixed>
$condition : string
$variables : array<string|int, mixed> = []
Return values
void —

addOrderBy()

public addOrderBy(string $name[, string $dir = 'asc' ]) : void
Parameters
$name : string
$dir : string = 'asc'
Return values
void —

addVariables()

public addVariables(array<string|int, mixed> $variables) : void
Parameters
$variables : array<string|int, mixed>
Return values
void —

conditions()

public conditions() : array<string|int, mixed>
Return values
array<string|int, mixed> —

fields()

public fields() : array<string|int, mixed>
Return values
array<string|int, mixed> —

groupBy()

public groupBy() : array<string|int, mixed>
Return values
array<string|int, mixed> —

joins()

public joins() : array<string|int, mixed>
Return values
array<string|int, mixed> —

max()

public max() : int
Return values
int —

offset()

public offset() : int
Return values
int —

orderBy()

public orderBy() : array<string|int, mixed>
Return values
array<string|int, mixed> —

setFields()

public setFields(array<string|int, mixed> $fields) : void
Parameters
$fields : array<string|int, mixed>
Return values
void —

setLimit()

public setLimit(int $offset, int $max) : void
Parameters
$offset : int
$max : int
Return values
void —

variables()

public variables() : array<string|int, mixed>
Return values
array<string|int, mixed> —

allFields()

private allFields() : array<string|int, mixed>
Return values
array<string|int, mixed> —

shouldSelectAllFields()

private shouldSelectAllFields() : bool
Return values
bool —

Search results