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.

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

Details

void __construct(string $type, string $table)

Create a new join clause instance.

Parameters

string $type
string $table

Return Value

void

$this on(string $first, string $operator, string $second, string $boolean = 'and', bool $where = false)

Add an "on" clause to the join.

Parameters

string $first
string $operator
string $second
string $boolean
bool $where

Return Value

$this

JoinClause orOn(string $first, string $operator, string $second)

Add an "or on" clause to the join.

Parameters

string $first
string $operator
string $second

Return Value

JoinClause

JoinClause where(string $first, string $operator, string $second, string $boolean = 'and')

Add an "on where" clause to the join.

Parameters

string $first
string $operator
string $second
string $boolean

Return Value

JoinClause

JoinClause orWhere(string $first, string $operator, string $second)

Add an "or on where" clause to the join.

Parameters

string $first
string $operator
string $second

Return Value

JoinClause

JoinClause whereNull(string $column, string $boolean = 'and')

Add an "on where is null" clause to the join

Parameters

string $column
string $boolean

Return Value

JoinClause

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/4.2/Illuminate/Database/Query/JoinClause.html