JoinClause
class JoinClause (View source)
Properties
| string | $type | The type of join being performed. |
|
| string | $table | The table the join clause is joining to. |
|
| array | $clauses | The "on" clauses for the join. |
|
| array | $bindings | The "on" bindings for the join. |
Methods
void
__construct(string $type, string $table)
Create a new join clause instance.
$this
on(string $first, string $operator, string $second, string $boolean = 'and', bool $where = false)
Add an "on" clause to the join.
orOn(string $first, string $operator, string $second)
Add an "or on" clause to the join.
where(string $first, string $operator, string $second, string $boolean = 'and')
Add an "on where" clause to the join.
orWhere(string $first, string $operator, string $second)
Add an "or on where" clause to the join.
whereNull(string $column, string $boolean = 'and')
Add an "on where is null" clause to the join
Details
void
__construct(string $type, string $table)
Create a new join clause instance.
$this
on(string $first, string $operator, string $second, string $boolean = 'and', bool $where = false)
Add an "on" clause to the join.
JoinClause
orOn(string $first, string $operator, string $second)
Add an "or on" clause to the join.
JoinClause
where(string $first, string $operator, string $second, string $boolean = 'and')
Add an "on where" clause to the join.
JoinClause
orWhere(string $first, string $operator, string $second)
Add an "or on where" clause to the join.
JoinClause
whereNull(string $column, string $boolean = 'and')
Add an "on where is null" clause to the join