JoinClause

bool

each(callable $callback, int $count = 1000)

Execute a callback over each item while chunking.

bool

chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null)

Chunk the results of a query by comparing IDs.

bool

eachById(callable $callback, int $count = 1000, string|null $column = null, string|null $alias = null)

Execute a callback over each item while chunking by ID.

Model|object|BuildsQueries|null

first(array|string $columns = ['*'])

Execute the query and get the first result.

mixed|$this

when(mixed $value, callable $callback, callable|null $default = null)

Apply the callback's query changes if the given "value" is true.

$this

tap(callable $callback)

Pass the query to a given callback.

mixed|$this

unless(mixed $value, callable $callback, callable|null $default = null)

Apply the callback's query changes if the given "value" is false.

LengthAwarePaginator

paginator(Collection $items, int $total, int $perPage, int $currentPage, array $options)

Create a new length-aware paginator instance.

Paginator

simplePaginator(Collection $items, int $perPage, int $currentPage, array $options)

Create a new simple paginator instance.

mixed

forwardCallTo(mixed $object, string $method, array $parameters)

Forward a method call to the given object.

from ForwardsCalls

static void

throwBadMethodCallException(string $method)

Throw a bad method call exception for the given method.

from ForwardsCalls

static void

macro(string $name, object|callable $macro)

from Macroable

static void

mixin(object $mixin, bool $replace = true)

Mix another object into the class.

from Macroable

static bool

hasMacro(string $name)

Checks if macro is registered.

from Macroable

static mixed

__callStatic(string $method, array $parameters)

Dynamically handle calls to the class.

from Macroable

mixed

__call(string $method, array $parameters)

Dynamically handle calls to the class.

from Macroable

void

__construct(Builder $parentQuery, string $type, string $table)

Create a new join clause instance.

$this

select(array|mixed $columns = ['*'])

Set the columns to be selected.

from Builder

$this

selectSub(Closure|$this|string $query, string $as)

Add a subselect expression to the query.

from Builder

$this

selectRaw(string $expression, array $bindings = [])

Add a new "raw" select expression to the query.

from Builder

$this

fromSub(Closure|Builder|string $query, string $as)

Makes "from" fetch from a subquery.

from Builder

$this

fromRaw(string $expression, mixed $bindings = [])

Add a raw from clause to the query.

from Builder

array

createSub(Closure|Builder|string $query)

Creates a subquery and parse it.

from Builder

array

parseSub(mixed $query)

Parse the subquery into SQL and bindings.

from Builder

$this

addSelect(array|mixed $column)

Add a new select column to the query.

from Builder

$this

distinct()

Force the query to only return distinct results.

from Builder

$this

from(Closure|Builder|string $table, string|null $as = null)

Set the table which the query is targeting.

from Builder

$this

join(string $table, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false)

Add a join clause to the query.

from Builder

$this

joinWhere(string $table, Closure|string $first, string $operator, string $second, string $type = 'inner')

Add a "join where" clause to the query.

from Builder

$this

Add a subquery join clause to the query.

from Builder

$this

leftJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)

Add a left join to the query.

from Builder

$this

leftJoinWhere(string $table, Closure|string $first, string $operator, string $second)

Add a "join where" clause to the query.

from Builder

$this

Add a subquery left join to the query.

from Builder

$this

rightJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)

Add a right join to the query.

from Builder

$this

rightJoinWhere(string $table, Closure|string $first, string $operator, string $second)

Add a "right join where" clause to the query.

from Builder

$this

Add a subquery right join to the query.

from Builder

$this

crossJoin(string $table, Closure|string|null $first = null, string|null $operator = null, string|null $second = null)

Add a "cross join" clause to the query.

from Builder

JoinClause

newJoinClause(Builder $parentQuery, string $type, string $table)

Get a new join clause.

from Builder

void

mergeWheres(array $wheres, array $bindings)

Merge an array of where clauses and bindings.

from Builder

$this

where(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')

Add a basic where clause to the query.

from Builder

$this

addArrayOfWheres(array $column, string $boolean, string $method = 'where')

Add an array of where clauses to the query.

from Builder

array

prepareValueAndOperator(string $value, string $operator, bool $useDefault = false)

Prepare the value and operator for a where clause.

from Builder

bool

invalidOperatorAndValue(string $operator, mixed $value)

Determine if the given operator and value combination is legal.

from Builder

bool

invalidOperator(string $operator)

Determine if the given operator is supported.

from Builder

$this

orWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null)

Add an "or where" clause to the query.

from Builder

$this

whereColumn(string|array $first, string|null $operator = null, string|null $second = null, string|null $boolean = 'and')

Add a "where" clause comparing two columns to the query.

from Builder

$this

orWhereColumn(string|array $first, string|null $operator = null, string|null $second = null)

Add an "or where" clause comparing two columns to the query.

from Builder

$this

whereRaw(string $sql, mixed $bindings = [], string $boolean = 'and')

Add a raw where clause to the query.

from Builder

$this

orWhereRaw(string $sql, mixed $bindings = [])

Add a raw or where clause to the query.

from Builder

$this

whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)

Add a "where in" clause to the query.

from Builder

$this

orWhereIn(string $column, mixed $values)

Add an "or where in" clause to the query.

from Builder

$this

whereNotIn(string $column, mixed $values, string $boolean = 'and')

Add a "where not in" clause to the query.

from Builder

$this

orWhereNotIn(string $column, mixed $values)

Add an "or where not in" clause to the query.

from Builder

$this

whereIntegerInRaw(string $column, Arrayable|array $values, string $boolean = 'and', bool $not = false)

Add a "where in raw" clause for integer values to the query.

from Builder

$this

orWhereIntegerInRaw(string $column, Arrayable|array $values)

Add an "or where in raw" clause for integer values to the query.

from Builder

$this

whereIntegerNotInRaw(string $column, Arrayable|array $values, string $boolean = 'and')

Add a "where not in raw" clause for integer values to the query.

from Builder

$this

orWhereIntegerNotInRaw(string $column, Arrayable|array $values)

Add an "or where not in raw" clause for integer values to the query.

from Builder

$this

whereNull(string|array $columns, string $boolean = 'and', bool $not = false)

Add a "where null" clause to the query.

from Builder

$this

orWhereNull(string $column)

Add an "or where null" clause to the query.

from Builder

$this

whereNotNull(string|array $columns, string $boolean = 'and')

Add a "where not null" clause to the query.

from Builder

$this

whereBetween(string $column, array $values, string $boolean = 'and', bool $not = false)

Add a where between statement to the query.

from Builder

$this

whereBetweenColumns(string $column, array $values, string $boolean = 'and', bool $not = false)

Add a where between statement using columns to the query.

from Builder

$this

orWhereBetween(string $column, array $values)

Add an or where between statement to the query.

from Builder

$this

orWhereBetweenColumns(string $column, array $values)

Add an or where between statement using columns to the query.

from Builder

$this

whereNotBetween(string $column, array $values, string $boolean = 'and')

Add a where not between statement to the query.

from Builder

$this

whereNotBetweenColumns(string $column, array $values, string $boolean = 'and')

Add a where not between statement using columns to the query.

from Builder

$this

orWhereNotBetween(string $column, array $values)

Add an or where not between statement to the query.

from Builder

$this

orWhereNotBetweenColumns(string $column, array $values)

Add an or where not between statement using columns to the query.

from Builder

$this

orWhereNotNull(string $column)

Add an "or where not null" clause to the query.

from Builder

$this

whereDate(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')

Add a "where date" statement to the query.

from Builder

$this

orWhereDate(string $column, string $operator, DateTimeInterface|string|null $value = null)

Add an "or where date" statement to the query.

from Builder

$this

whereTime(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')

Add a "where time" statement to the query.

from Builder

$this

orWhereTime(string $column, string $operator, DateTimeInterface|string|null $value = null)

Add an "or where time" statement to the query.

from Builder

$this

whereDay(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')

Add a "where day" statement to the query.

from Builder

$this

orWhereDay(string $column, string $operator, DateTimeInterface|string|null $value = null)

Add an "or where day" statement to the query.

from Builder

$this

whereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')

Add a "where month" statement to the query.

from Builder

$this

orWhereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null)

Add an "or where month" statement to the query.

from Builder

$this

whereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null, string $boolean = 'and')

Add a "where year" statement to the query.

from Builder

$this

orWhereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null)

Add an "or where year" statement to the query.

from Builder

$this

addDateBasedWhere(string $type, string $column, string $operator, mixed $value, string $boolean = 'and')

Add a date based (year, month, day, time) statement to the query.

from Builder

$this

whereNested(Closure $callback, string $boolean = 'and')

Add a nested where statement to the query.

from Builder

Builder

forNestedWhere()

Create a new query instance for nested where condition.

from Builder

$this

addNestedWhereQuery(Builder $query, string $boolean = 'and')

Add another query builder as a nested where to the query builder.

from Builder

$this

whereSub(string $column, string $operator, Closure $callback, string $boolean)

Add a full sub-select to the query.

from Builder

$this

whereExists(Closure $callback, string $boolean = 'and', bool $not = false)

Add an exists clause to the query.

from Builder

$this

orWhereExists(Closure $callback, bool $not = false)

Add an or exists clause to the query.

from Builder

$this

whereNotExists(Closure $callback, string $boolean = 'and')

Add a where not exists clause to the query.

from Builder

$this

orWhereNotExists(Closure $callback)

Add a where not exists clause to the query.

from Builder

$this

addWhereExistsQuery(Builder $query, string $boolean = 'and', bool $not = false)

Add an exists clause to the query.

from Builder

$this

whereRowValues(array $columns, string $operator, array $values, string $boolean = 'and')

Adds a where condition using row values.

from Builder

$this

orWhereRowValues(array $columns, string $operator, array $values)

Adds an or where condition using row values.

from Builder

$this

whereJsonContains(string $column, mixed $value, string $boolean = 'and', bool $not = false)

Add a "where JSON contains" clause to the query.

from Builder

$this

orWhereJsonContains(string $column, mixed $value)

Add an "or where JSON contains" clause to the query.

from Builder

$this

whereJsonDoesntContain(string $column, mixed $value, string $boolean = 'and')

Add a "where JSON not contains" clause to the query.

from Builder

$this

orWhereJsonDoesntContain(string $column, mixed $value)

Add an "or where JSON not contains" clause to the query.

from Builder

$this

whereJsonLength(string $column, mixed $operator, mixed $value = null, string $boolean = 'and')

Add a "where JSON length" clause to the query.

from Builder

$this

orWhereJsonLength(string $column, mixed $operator, mixed $value = null)

Add an "or where JSON length" clause to the query.

from Builder

$this

dynamicWhere(string $method, array $parameters)

Handles dynamic "where" clauses to the query.

from Builder

void

addDynamic(string $segment, string $connector, array $parameters, int $index)

Add a single dynamic where clause statement to the query.

from Builder

$this

groupBy(array|string ...$groups)

Add a "group by" clause to the query.

from Builder

$this

groupByRaw(string $sql, array $bindings = [])

Add a raw groupBy clause to the query.

from Builder

$this

having(string $column, string|null $operator = null, string|null $value = null, string $boolean = 'and')

Add a "having" clause to the query.

from Builder

$this

orHaving(string $column, string|null $operator = null, string|null $value = null)

Add an "or having" clause to the query.

from Builder

$this

havingBetween(string $column, array $values, string $boolean = 'and', bool $not = false)

Add a "having between " clause to the query.

from Builder

$this

havingRaw(string $sql, array $bindings = [], string $boolean = 'and')

Add a raw having clause to the query.

from Builder

$this

orHavingRaw(string $sql, array $bindings = [])

Add a raw or having clause to the query.

from Builder

$this

orderBy(Closure|Builder|Expression|string $column, string $direction = 'asc')

Add an "order by" clause to the query.

from Builder

$this

orderByDesc(string $column)

Add a descending "order by" clause to the query.

from Builder

$this

latest(string $column = 'created_at')

Add an "order by" clause for a timestamp to the query.

from Builder

$this

oldest(string $column = 'created_at')

Add an "order by" clause for a timestamp to the query.

from Builder

$this

inRandomOrder(string $seed = '')

Put the query's results in random order.

from Builder

$this

orderByRaw(string $sql, array $bindings = [])

Add a raw "order by" clause to the query.

from Builder

$this

skip(int $value)

Alias to set the "offset" value of the query.

from Builder

$this

offset(int $value)

Set the "offset" value of the query.

from Builder

$this

take(int $value)

Alias to set the "limit" value of the query.

from Builder

$this

limit(int $value)

Set the "limit" value of the query.

from Builder

$this

forPage(int $page, int $perPage = 15)

Set the limit and offset for a given page.

from Builder

$this

forPageBeforeId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')

Constrain the query to the previous "page" of results before a given ID.

from Builder

$this

forPageAfterId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')

Constrain the query to the next "page" of results after a given ID.

from Builder

$this

reorder(string|null $column = null, string $direction = 'asc')

Remove all existing orders and optionally add a new order.

from Builder

array

removeExistingOrdersFor(string $column)

Get an array with all orders with a given column removed.

from Builder

$this

union(Builder|Closure $query, bool $all = false)

Add a union statement to the query.

from Builder

$this

unionAll(Builder|Closure $query)

Add a union all statement to the query.

from Builder

$this

lock(string|bool $value = true)

Lock the selected rows in the table.

from Builder

Builder

lockForUpdate()

Lock the selected rows in the table for updating.

from Builder

Builder

sharedLock()

Share lock the selected rows in the table.

from Builder

string

toSql()

Get the SQL representation of the query.

from Builder

mixed|Builder

find(int|string $id, array $columns = ['*'])

Execute a query for a single record by ID.

from Builder

mixed

value(string $column)

Get a single column's value from the first result of a query.

from Builder

Collection

get(array|string $columns = ['*'])

Execute the query as a "select" statement.

from Builder

array

runSelect()

Run the query as a "select" statement against the connection.

from Builder

LengthAwarePaginator

paginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)

Paginate the given query into a simple paginator.

from Builder

Paginator

simplePaginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)

Get a paginator only supporting simple next and previous links.

from Builder

int

getCountForPagination(array $columns = ['*'])

Get the count of the total records for the paginator.

from Builder

array

runPaginationCountQuery(array $columns = ['*'])

Run a pagination count query.

from Builder

Builder

cloneForPaginationCount()

Clone the existing query instance for usage in a pagination subquery.

from Builder

array

withoutSelectAliases(array $columns)

Remove the column aliases since they will break count queries.

from Builder

LazyCollection

cursor()

Get a lazy collection for the given query.

from Builder

void

enforceOrderBy()

Throw an exception if the query doesn't have an orderBy clause.

from Builder

Collection

pluck(string $column, string|null $key = null)

Get an array with the values of a given column.

from Builder

string|null

stripTableForPluck(string $column)

Strip off the table name or alias from a column identifier.

from Builder

Collection

pluckFromObjectColumn(array $queryResult, string $column, string $key)

Retrieve column values from rows represented as objects.

from Builder

Collection

pluckFromArrayColumn(array $queryResult, string $column, string $key)

Retrieve column values from rows represented as arrays.

from Builder

string

implode(string $column, string $glue = '')

Concatenate values of a given column as a string.

from Builder

bool

exists()

Determine if any rows exist for the current query.

from Builder

bool

doesntExist()

Determine if no rows exist for the current query.

from Builder

mixed

existsOr(Closure $callback)

Execute the given callback if no rows exist for the current query.

from Builder

mixed

doesntExistOr(Closure $callback)

Execute the given callback if rows exist for the current query.

from Builder

int

count(string $columns = '*')

Retrieve the "count" result of the query.

from Builder

mixed

min(string $column)

Retrieve the minimum value of a given column.

from Builder

mixed

max(string $column)

Retrieve the maximum value of a given column.

from Builder

mixed

sum(string $column)

Retrieve the sum of the values of a given column.

from Builder

mixed

avg(string $column)

Retrieve the average of the values of a given column.

from Builder

mixed

average(string $column)

Alias for the "avg" method.

from Builder

mixed

aggregate(string $function, array $columns = ['*'])

Execute an aggregate function on the database.

from Builder

float|int

numericAggregate(string $function, array $columns = ['*'])

Execute a numeric aggregate function on the database.

from Builder

$this

setAggregate(string $function, array $columns)

Set the aggregate property without running the query.

from Builder

mixed

onceWithColumns(array $columns, callable $callback)

Execute the given callback while selecting the given columns.

from Builder

bool

insert(array $values)

Insert a new record into the database.

from Builder

int

insertOrIgnore(array $values)

Insert a new record into the database while ignoring errors.

from Builder

int

insertGetId(array $values, string|null $sequence = null)

Insert a new record and get the value of the primary key.

from Builder

int

insertUsing(array $columns, Closure|Builder|string $query)

Insert new records into the table using a subquery.

from Builder

int

update(array $values)

Update a record in the database.

from Builder

bool

updateOrInsert(array $attributes, array $values = [])

Insert or update a record matching the attributes, and fill it with values.

from Builder

int

increment(string $column, float|int $amount = 1, array $extra = [])

Increment a column's value by a given amount.

from Builder

int

decrement(string $column, float|int $amount = 1, array $extra = [])

Decrement a column's value by a given amount.

from Builder

int

delete(mixed $id = null)

Delete a record from the database.

from Builder

void

truncate()

Run a truncate statement on the table.

from Builder

Builder

newQuery()

Get a new instance of the join clause builder.

Builder

forSubQuery()

Create a new query instance for sub-query.

Expression

raw(mixed $value)

Create a raw database expression.

from Builder

array

getBindings()

Get the current query value bindings in a flattened array.

from Builder

array

getRawBindings()

Get the raw array of bindings.

from Builder

$this

setBindings(array $bindings, string $type = 'where')

Set the bindings on the query builder.

from Builder

$this

addBinding(mixed $value, string $type = 'where')

Add a binding to the query.

from Builder

$this

mergeBindings(Builder $query)

Merge an array of bindings into our bindings.

from Builder

array

cleanBindings(array $bindings)

Remove all of the expressions from a list of bindings.

from Builder

mixed

flattenValue(mixed $value)

Get a scalar type value from an unknown type of input.

from Builder

string

defaultKeyName()

Get the default key name of the table.

from Builder

ConnectionInterface

getConnection()

Get the database connection instance.

from Builder

Processor

getProcessor()

Get the database query processor instance.

from Builder

Grammar

getGrammar()

Get the query grammar instance.

from Builder

$this

useWritePdo()

Use the write pdo for query.

from Builder

bool

isQueryable(mixed $value)

Determine if the value is a query builder instance or a Closure.

from Builder

Builder

cloneWithout(array $properties)

Clone the query without the given properties.

from Builder

Builder

cloneWithoutBindings(array $except)

Clone the query without the given bindings.

from Builder

$this

dump()

Dump the current SQL and bindings.

from Builder

void

dd()

Die and dump the current SQL and bindings.

from Builder

$this

on(Closure|string $first, string|null $operator = null, Expression|string|null $second = null, string $boolean = 'and')

Add an "on" clause to the join.

JoinClause

orOn(Closure|string $first, string|null $operator = null, string|null $second = null)

Add an "or on" clause to the join.

Builder

newParentQuery()

Create a new parent query instance.

Details

in BuildsQueries at line 18
`bool chunk(int $count, callable $callback)`

Chunk the results of the query.

Parameters

int	$count
callable	$callback

Return Value

bool

in BuildsQueries at line 58
`bool each(callable $callback, int $count = 1000)`

Execute a callback over each item while chunking.

Parameters

callable	$callback
int	$count

Return Value

bool

in BuildsQueries at line 78
`bool chunkById(int $count, callable $callback, string|null $column = null, string|null $alias = null)`

Chunk the results of a query by comparing IDs.

Parameters

int	$count
callable	$callback
string\|null	$column
string\|null	$alias

Return Value

bool

in BuildsQueries at line 124
`bool eachById(callable $callback, int $count = 1000, string|null $column = null, string|null $alias = null)`

Execute a callback over each item while chunking by ID.

Parameters

callable	$callback
int	$count
string\|null	$column
string\|null	$alias

Return Value

bool

in BuildsQueries at line 141
`Model|object|BuildsQueries|null first(array|string $columns = ['*'])`

Execute the query and get the first result.

Parameters

array|string

$columns

Return Value

Model|object|BuildsQueries|null

in BuildsQueries at line 154
`mixed|$this when(mixed $value, callable $callback, callable|null $default = null)`

Apply the callback's query changes if the given "value" is true.

Parameters

mixed	$value
callable	$callback
callable\|null	$default

Return Value

mixed|$this

in BuildsQueries at line 171
`$this tap(callable $callback)`

Pass the query to a given callback.

Parameters

callable

$callback

Return Value

$this

in BuildsQueries at line 184
`mixed|$this unless(mixed $value, callable $callback, callable|null $default = null)`

Apply the callback's query changes if the given "value" is false.

Parameters

mixed	$value
callable	$callback
callable\|null	$default

Return Value

mixed|$this

in BuildsQueries at line 205
`protected LengthAwarePaginator paginator(Collection $items, int $total, int $perPage, int $currentPage, array $options)`

Create a new length-aware paginator instance.

Parameters

Collection	$items
int	$total
int	$perPage
int	$currentPage
array	$options

Return Value

LengthAwarePaginator

in BuildsQueries at line 221
`protected Paginator simplePaginator(Collection $items, int $perPage, int $currentPage, array $options)`

Create a new simple paginator instance.

Parameters

Collection	$items
int	$perPage
int	$currentPage
array	$options

Return Value

Paginator

in ForwardsCalls at line 20
`protected mixed forwardCallTo(mixed $object, string $method, array $parameters)`

Forward a method call to the given object.

Parameters

mixed	$object
string	$method
array	$parameters

Return Value

mixed

Exceptions

in ForwardsCalls at line 48
`static protected void throwBadMethodCallException(string $method)`

Throw a bad method call exception for the given method.

Parameters

string

$method

Return Value

void

Exceptions

in Macroable at line 26
`static void macro(string $name, object|callable $macro)`

Parameters

string	$name
object\|callable	$macro

Return Value

void

in Macroable at line 40
`static void mixin(object $mixin, bool $replace = true)`

Mix another object into the class.

Parameters

object	$mixin
bool	$replace

Return Value

void

Exceptions

ReflectionException

in Macroable at line 60
`static bool hasMacro(string $name)`

Checks if macro is registered.

Parameters

string

$name

Return Value

bool

in Macroable at line 74
`static mixed __callStatic(string $method, array $parameters)`

Dynamically handle calls to the class.

Parameters

string	$method
array	$parameters

Return Value

mixed

Exceptions

in Macroable at line 100
`mixed __call(string $method, array $parameters)`

Dynamically handle calls to the class.

Parameters

string	$method
array	$parameters

Return Value

mixed

Exceptions

at line 59
`void __construct(Builder $parentQuery, string $type, string $table)`

Create a new join clause instance.

Parameters

Builder	$parentQuery
string	$type
string	$table

Return Value

void

in Builder at line 226
`$this select(array|mixed $columns = ['*'])`

Set the columns to be selected.

Parameters

array|mixed

$columns

Return Value

$this

in Builder at line 252
`$this selectSub(Closure|$this|string $query, string $as)`

Add a subselect expression to the query.

Parameters

Closure\|$this\|string	$query
string	$as

Return Value

$this

Exceptions

in Builder at line 268
`$this selectRaw(string $expression, array $bindings = [])`

Add a new "raw" select expression to the query.

Parameters

string	$expression
array	$bindings

Return Value

$this

in Builder at line 288
`$this fromSub(Closure|Builder|string $query, string $as)`

Makes "from" fetch from a subquery.

Parameters

Closure\|Builder\|string	$query
string	$as

Return Value

$this

Exceptions

in Builder at line 302
`$this fromRaw(string $expression, mixed $bindings = [])`

Add a raw from clause to the query.

Parameters

string	$expression
mixed	$bindings

Return Value

$this

in Builder at line 317
`protected array createSub(Closure|Builder|string $query)`

Creates a subquery and parse it.

Parameters

Closure|Builder|string

$query

Return Value

array

in Builder at line 339
`protected array parseSub(mixed $query)`

Parse the subquery into SQL and bindings.

Parameters

mixed

$query

Return Value

array

Exceptions

in Builder at line 358
`$this addSelect(array|mixed $column)`

Add a new select column to the query.

Parameters

array|mixed

$column

Return Value

$this

in Builder at line 382
`$this distinct()`

Force the query to only return distinct results.

Return Value

$this

in Builder at line 402
`$this from(Closure|Builder|string $table, string|null $as = null)`

Set the table which the query is targeting.

Parameters

Closure\|Builder\|string	$table
string\|null	$as

Return Value

$this

in Builder at line 424
`$this join(string $table, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false)`

Add a join clause to the query.

Parameters

string	$table
Closure\|string	$first
string\|null	$operator
string\|null	$second
string	$type
bool	$where

Return Value

$this

in Builder at line 463
`$this joinWhere(string $table, Closure|string $first, string $operator, string $second, string $type = 'inner')`

Add a "join where" clause to the query.

Parameters

string	$table
Closure\|string	$first
string	$operator
string	$second
string	$type

Return Value

$this

in Builder at line 482
`$this joinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null, string $type = 'inner', bool $where = false)`

Add a subquery join clause to the query.

Parameters

Closure\|Builder\|string	$query
string	$as
Closure\|string	$first
string\|null	$operator
string\|null	$second
string	$type
bool	$where

Return Value

$this

Exceptions

in Builder at line 502
`$this leftJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)`

Add a left join to the query.

Parameters

string	$table
Closure\|string	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 516
`$this leftJoinWhere(string $table, Closure|string $first, string $operator, string $second)`

Add a "join where" clause to the query.

Parameters

string	$table
Closure\|string	$first
string	$operator
string	$second

Return Value

$this

in Builder at line 531
`$this leftJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null)`

Add a subquery left join to the query.

Parameters

Closure\|Builder\|string	$query
string	$as
Closure\|string	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 545
`$this rightJoin(string $table, Closure|string $first, string|null $operator = null, string|null $second = null)`

Add a right join to the query.

Parameters

string	$table
Closure\|string	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 559
`$this rightJoinWhere(string $table, Closure|string $first, string $operator, string $second)`

Add a "right join where" clause to the query.

Parameters

string	$table
Closure\|string	$first
string	$operator
string	$second

Return Value

$this

in Builder at line 574
`$this rightJoinSub(Closure|Builder|string $query, string $as, Closure|string $first, string|null $operator = null, string|null $second = null)`

Add a subquery right join to the query.

Parameters

Closure\|Builder\|string	$query
string	$as
Closure\|string	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 588
`$this crossJoin(string $table, Closure|string|null $first = null, string|null $operator = null, string|null $second = null)`

Add a "cross join" clause to the query.

Parameters

string	$table
Closure\|string\|null	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 607
`protected JoinClause newJoinClause(Builder $parentQuery, string $type, string $table)`

Get a new join clause.

Parameters

Builder	$parentQuery
string	$type
string	$table

Return Value

JoinClause

in Builder at line 619
`void mergeWheres(array $wheres, array $bindings)`

Merge an array of where clauses and bindings.

Parameters

array	$wheres
array	$bindings

Return Value

void

in Builder at line 637
`$this where(Closure|string|array $column, mixed $operator = null, mixed $value = null, string $boolean = 'and')`

Add a basic where clause to the query.

Parameters

Closure\|string\|array	$column
mixed	$operator
mixed	$value
string	$boolean

Return Value

$this

in Builder at line 726
`protected $this addArrayOfWheres(array $column, string $boolean, string $method = 'where')`

Add an array of where clauses to the query.

Parameters

array	$column
string	$boolean
string	$method

Return Value

$this

in Builder at line 749
`array prepareValueAndOperator(string $value, string $operator, bool $useDefault = false)`

Prepare the value and operator for a where clause.

Parameters

string	$value
string	$operator
bool	$useDefault

Return Value

array

Exceptions

in Builder at line 769
`protected bool invalidOperatorAndValue(string $operator, mixed $value)`

Determine if the given operator and value combination is legal.

Prevents using Null values with invalid operators.

Parameters

string	$operator
mixed	$value

Return Value

bool

in Builder at line 781
`protected bool invalidOperator(string $operator)`

Determine if the given operator is supported.

Parameters

string

$operator

Return Value

bool

in Builder at line 795
`$this orWhere(Closure|string|array $column, mixed $operator = null, mixed $value = null)`

Add an "or where" clause to the query.

Parameters

Closure\|string\|array	$column
mixed	$operator
mixed	$value

Return Value

$this

in Builder at line 813
`$this whereColumn(string|array $first, string|null $operator = null, string|null $second = null, string|null $boolean = 'and')`

Add a "where" clause comparing two columns to the query.

Parameters

string\|array	$first
string\|null	$operator
string\|null	$second
string\|null	$boolean

Return Value

$this

in Builder at line 849
`$this orWhereColumn(string|array $first, string|null $operator = null, string|null $second = null)`

Add an "or where" clause comparing two columns to the query.

Parameters

string\|array	$first
string\|null	$operator
string\|null	$second

Return Value

$this

in Builder at line 862
`$this whereRaw(string $sql, mixed $bindings = [], string $boolean = 'and')`

Add a raw where clause to the query.

Parameters

string	$sql
mixed	$bindings
string	$boolean

Return Value

$this

in Builder at line 878
`$this orWhereRaw(string $sql, mixed $bindings = [])`

Add a raw or where clause to the query.

Parameters

string	$sql
mixed	$bindings

Return Value

$this

in Builder at line 892
`$this whereIn(string $column, mixed $values, string $boolean = 'and', bool $not = false)`

Add a "where in" clause to the query.

Parameters

string	$column
mixed	$values
string	$boolean
bool	$not

Return Value

$this

in Builder at line 931
`$this orWhereIn(string $column, mixed $values)`

Add an "or where in" clause to the query.

Parameters

string	$column
mixed	$values

Return Value

$this

in Builder at line 944
`$this whereNotIn(string $column, mixed $values, string $boolean = 'and')`

Add a "where not in" clause to the query.

Parameters

string	$column
mixed	$values
string	$boolean

Return Value

$this

in Builder at line 956
`$this orWhereNotIn(string $column, mixed $values)`

Add an "or where not in" clause to the query.

Parameters

string	$column
mixed	$values

Return Value

$this

in Builder at line 970
`$this whereIntegerInRaw(string $column, Arrayable|array $values, string $boolean = 'and', bool $not = false)`

Add a "where in raw" clause for integer values to the query.

Parameters

string	$column
Arrayable\|array	$values
string	$boolean
bool	$not

Return Value

$this

in Builder at line 994
`$this orWhereIntegerInRaw(string $column, Arrayable|array $values)`

Add an "or where in raw" clause for integer values to the query.

Parameters

string	$column
Arrayable\|array	$values

Return Value

$this

in Builder at line 1007
`$this whereIntegerNotInRaw(string $column, Arrayable|array $values, string $boolean = 'and')`

Add a "where not in raw" clause for integer values to the query.

Parameters

string	$column
Arrayable\|array	$values
string	$boolean

Return Value

$this

in Builder at line 1019
`$this orWhereIntegerNotInRaw(string $column, Arrayable|array $values)`

Add an "or where not in raw" clause for integer values to the query.

Parameters

string	$column
Arrayable\|array	$values

Return Value

$this

in Builder at line 1032
`$this whereNull(string|array $columns, string $boolean = 'and', bool $not = false)`

Add a "where null" clause to the query.

Parameters

string\|array	$columns
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1049
`$this orWhereNull(string $column)`

Add an "or where null" clause to the query.

Parameters

string

$column

Return Value

$this

in Builder at line 1061
`$this whereNotNull(string|array $columns, string $boolean = 'and')`

Add a "where not null" clause to the query.

Parameters

string\|array	$columns
string	$boolean

Return Value

$this

in Builder at line 1075
`$this whereBetween(string $column, array $values, string $boolean = 'and', bool $not = false)`

Add a where between statement to the query.

Parameters

string	$column
array	$values
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1095
`$this whereBetweenColumns(string $column, array $values, string $boolean = 'and', bool $not = false)`

Add a where between statement using columns to the query.

Parameters

string	$column
array	$values
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1111
`$this orWhereBetween(string $column, array $values)`

Add an or where between statement to the query.

Parameters

string	$column
array	$values

Return Value

$this

in Builder at line 1123
`$this orWhereBetweenColumns(string $column, array $values)`

Add an or where between statement using columns to the query.

Parameters

string	$column
array	$values

Return Value

$this

in Builder at line 1136
`$this whereNotBetween(string $column, array $values, string $boolean = 'and')`

Add a where not between statement to the query.

Parameters

string	$column
array	$values
string	$boolean

Return Value

$this

in Builder at line 1149
`$this whereNotBetweenColumns(string $column, array $values, string $boolean = 'and')`

Add a where not between statement using columns to the query.

Parameters

string	$column
array	$values
string	$boolean

Return Value

$this

in Builder at line 1161
`$this orWhereNotBetween(string $column, array $values)`

Add an or where not between statement to the query.

Parameters

string	$column
array	$values

Return Value

$this

in Builder at line 1173
`$this orWhereNotBetweenColumns(string $column, array $values)`

Add an or where not between statement using columns to the query.

Parameters

string	$column
array	$values

Return Value

$this

in Builder at line 1184
`$this orWhereNotNull(string $column)`

Add an "or where not null" clause to the query.

Parameters

string

$column

Return Value

$this

in Builder at line 1198
`$this whereDate(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')`

Add a "where date" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1221
`$this orWhereDate(string $column, string $operator, DateTimeInterface|string|null $value = null)`

Add an "or where date" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value

Return Value

$this

in Builder at line 1239
`$this whereTime(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')`

Add a "where time" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1262
`$this orWhereTime(string $column, string $operator, DateTimeInterface|string|null $value = null)`

Add an "or where time" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value

Return Value

$this

in Builder at line 1280
`$this whereDay(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')`

Add a "where day" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1307
`$this orWhereDay(string $column, string $operator, DateTimeInterface|string|null $value = null)`

Add an "or where day" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value

Return Value

$this

in Builder at line 1325
`$this whereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null, string $boolean = 'and')`

Add a "where month" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1352
`$this orWhereMonth(string $column, string $operator, DateTimeInterface|string|null $value = null)`

Add an "or where month" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|null	$value

Return Value

$this

in Builder at line 1370
`$this whereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null, string $boolean = 'and')`

Add a "where year" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|int\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1393
`$this orWhereYear(string $column, string $operator, DateTimeInterface|string|int|null $value = null)`

Add an "or where year" statement to the query.

Parameters

string	$column
string	$operator
DateTimeInterface\|string\|int\|null	$value

Return Value

$this

in Builder at line 1412
`protected $this addDateBasedWhere(string $type, string $column, string $operator, mixed $value, string $boolean = 'and')`

Add a date based (year, month, day, time) statement to the query.

Parameters

string	$type
string	$column
string	$operator
mixed	$value
string	$boolean

Return Value

$this

in Builder at line 1430
`$this whereNested(Closure $callback, string $boolean = 'and')`

Add a nested where statement to the query.

Parameters

Closure	$callback
string	$boolean

Return Value

$this

in Builder at line 1442
`Builder forNestedWhere()`

Create a new query instance for nested where condition.

Return Value

in Builder at line 1454
`$this addNestedWhereQuery(Builder $query, string $boolean = 'and')`

Add another query builder as a nested where to the query builder.

Parameters

Builder	$query
string	$boolean

Return Value

$this

in Builder at line 1476
`protected $this whereSub(string $column, string $operator, Closure $callback, string $boolean)`

Add a full sub-select to the query.

Parameters

string	$column
string	$operator
Closure	$callback
string	$boolean

Return Value

$this

in Builder at line 1502
`$this whereExists(Closure $callback, string $boolean = 'and', bool $not = false)`

Add an exists clause to the query.

Parameters

Closure	$callback
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1521
`$this orWhereExists(Closure $callback, bool $not = false)`

Add an or exists clause to the query.

Parameters

Closure	$callback
bool	$not

Return Value

$this

in Builder at line 1533
`$this whereNotExists(Closure $callback, string $boolean = 'and')`

Add a where not exists clause to the query.

Parameters

Closure	$callback
string	$boolean

Return Value

$this

in Builder at line 1544
`$this orWhereNotExists(Closure $callback)`

Add a where not exists clause to the query.

Parameters

Closure

$callback

Return Value

$this

in Builder at line 1557
`$this addWhereExistsQuery(Builder $query, string $boolean = 'and', bool $not = false)`

Add an exists clause to the query.

Parameters

Builder	$query
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1579
`$this whereRowValues(array $columns, string $operator, array $values, string $boolean = 'and')`

Adds a where condition using row values.

Parameters

array	$columns
string	$operator
array	$values
string	$boolean

Return Value

$this

Exceptions

in Builder at line 1602
`$this orWhereRowValues(array $columns, string $operator, array $values)`

Adds an or where condition using row values.

Parameters

array	$columns
string	$operator
array	$values

Return Value

$this

in Builder at line 1616
`$this whereJsonContains(string $column, mixed $value, string $boolean = 'and', bool $not = false)`

Add a "where JSON contains" clause to the query.

Parameters

string	$column
mixed	$value
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1636
`$this orWhereJsonContains(string $column, mixed $value)`

Add an "or where JSON contains" clause to the query.

Parameters

string	$column
mixed	$value

Return Value

$this

in Builder at line 1649
`$this whereJsonDoesntContain(string $column, mixed $value, string $boolean = 'and')`

Add a "where JSON not contains" clause to the query.

Parameters

string	$column
mixed	$value
string	$boolean

Return Value

$this

in Builder at line 1661
`$this orWhereJsonDoesntContain(string $column, mixed $value)`

Add an "or where JSON not contains" clause to the query.

Parameters

string	$column
mixed	$value

Return Value

$this

in Builder at line 1675
`$this whereJsonLength(string $column, mixed $operator, mixed $value = null, string $boolean = 'and')`

Add a "where JSON length" clause to the query.

Parameters

string	$column
mixed	$operator
mixed	$value
string	$boolean

Return Value

$this

in Builder at line 1700
`$this orWhereJsonLength(string $column, mixed $operator, mixed $value = null)`

Add an "or where JSON length" clause to the query.

Parameters

string	$column
mixed	$operator
mixed	$value

Return Value

$this

in Builder at line 1716
`$this dynamicWhere(string $method, array $parameters)`

Handles dynamic "where" clauses to the query.

Parameters

string	$method
array	$parameters

Return Value

$this

in Builder at line 1761
`protected void addDynamic(string $segment, string $connector, array $parameters, int $index)`

Add a single dynamic where clause statement to the query.

Parameters

string	$segment
string	$connector
array	$parameters
int	$index

Return Value

void

in Builder at line 1777
`$this groupBy(array|string ...$groups)`

Add a "group by" clause to the query.

Parameters

array|string

...$groups

Return Value

$this

in Builder at line 1796
`$this groupByRaw(string $sql, array $bindings = [])`

Add a raw groupBy clause to the query.

Parameters

string	$sql
array	$bindings

Return Value

$this

in Builder at line 1814
`$this having(string $column, string|null $operator = null, string|null $value = null, string $boolean = 'and')`

Add a "having" clause to the query.

Parameters

string	$column
string\|null	$operator
string\|null	$value
string	$boolean

Return Value

$this

in Builder at line 1849
`$this orHaving(string $column, string|null $operator = null, string|null $value = null)`

Add an "or having" clause to the query.

Parameters

string	$column
string\|null	$operator
string\|null	$value

Return Value

$this

in Builder at line 1867
`$this havingBetween(string $column, array $values, string $boolean = 'and', bool $not = false)`

Add a "having between " clause to the query.

Parameters

string	$column
array	$values
string	$boolean
bool	$not

Return Value

$this

in Builder at line 1886
`$this havingRaw(string $sql, array $bindings = [], string $boolean = 'and')`

Add a raw having clause to the query.

Parameters

string	$sql
array	$bindings
string	$boolean

Return Value

$this

in Builder at line 1904
`$this orHavingRaw(string $sql, array $bindings = [])`

Add a raw or having clause to the query.

Parameters

string	$sql
array	$bindings

Return Value

$this

in Builder at line 1918
`$this orderBy(Closure|Builder|Expression|string $column, string $direction = 'asc')`

Add an "order by" clause to the query.

Parameters

Closure\|Builder\|Expression\|string	$column
string	$direction

Return Value

$this

Exceptions

in Builder at line 1948
`$this orderByDesc(string $column)`

Add a descending "order by" clause to the query.

Parameters

string

$column

Return Value

$this

in Builder at line 1959
`$this latest(string $column = 'created_at')`

Add an "order by" clause for a timestamp to the query.

Parameters

string

$column

Return Value

$this

in Builder at line 1970
`$this oldest(string $column = 'created_at')`

Add an "order by" clause for a timestamp to the query.

Parameters

string

$column

Return Value

$this

in Builder at line 1981
`$this inRandomOrder(string $seed = '')`

Put the query's results in random order.

Parameters

string

$seed

Return Value

$this

in Builder at line 1993
`$this orderByRaw(string $sql, array $bindings = [])`

Add a raw "order by" clause to the query.

Parameters

string	$sql
array	$bindings

Return Value

$this

in Builder at line 2010
`$this skip(int $value)`

Alias to set the "offset" value of the query.

Parameters

int

$value

Return Value

$this

in Builder at line 2021
`$this offset(int $value)`

Set the "offset" value of the query.

Parameters

int

$value

Return Value

$this

in Builder at line 2036
`$this take(int $value)`

Alias to set the "limit" value of the query.

Parameters

int

$value

Return Value

$this

in Builder at line 2047
`$this limit(int $value)`

Set the "limit" value of the query.

Parameters

int

$value

Return Value

$this

in Builder at line 2065
`$this forPage(int $page, int $perPage = 15)`

Set the limit and offset for a given page.

Parameters

int	$page
int	$perPage

Return Value

$this

in Builder at line 2078
`$this forPageBeforeId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')`

Constrain the query to the previous "page" of results before a given ID.

Parameters

int	$perPage
int\|null	$lastId
string	$column

Return Value

$this

in Builder at line 2098
`$this forPageAfterId(int $perPage = 15, int|null $lastId = 0, string $column = 'id')`

Constrain the query to the next "page" of results after a given ID.

Parameters

int	$perPage
int\|null	$lastId
string	$column

Return Value

$this

in Builder at line 2117
`$this reorder(string|null $column = null, string $direction = 'asc')`

Remove all existing orders and optionally add a new order.

Parameters

string\|null	$column
string	$direction

Return Value

$this

in Builder at line 2137
`protected array removeExistingOrdersFor(string $column)`

Get an array with all orders with a given column removed.

Parameters

string

$column

Return Value

array

in Builder at line 2153
`$this union(Builder|Closure $query, bool $all = false)`

Add a union statement to the query.

Parameters

Builder\|Closure	$query
bool	$all

Return Value

$this

in Builder at line 2172
`$this unionAll(Builder|Closure $query)`

Add a union all statement to the query.

Parameters

Builder|Closure

$query

Return Value

$this

in Builder at line 2183
`$this lock(string|bool $value = true)`

Lock the selected rows in the table.

Parameters

string|bool

$value

Return Value

$this

in Builder at line 2199
`Builder lockForUpdate()`

Lock the selected rows in the table for updating.

Return Value

in Builder at line 2209
`Builder sharedLock()`

Share lock the selected rows in the table.

Return Value

in Builder at line 2219
`string toSql()`

Get the SQL representation of the query.

Return Value

string

in Builder at line 2231
`mixed|Builder find(int|string $id, array $columns = ['*'])`

Execute a query for a single record by ID.

Parameters

int\|string	$id
array	$columns

Return Value

mixed|Builder

in Builder at line 2242
`mixed value(string $column)`

Get a single column's value from the first result of a query.

Parameters

string

$column

Return Value

mixed

in Builder at line 2255
`Collection get(array|string $columns = ['*'])`

Execute the query as a "select" statement.

Parameters

array|string

$columns

Return Value

in Builder at line 2267
`protected array runSelect()`

Run the query as a "select" statement against the connection.

Return Value

array

in Builder at line 2283
`LengthAwarePaginator paginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)`

Paginate the given query into a simple paginator.

Parameters

int	$perPage
array	$columns
string	$pageName
int\|null	$page

Return Value

LengthAwarePaginator

in Builder at line 2308
`Paginator simplePaginate(int $perPage = 15, array $columns = ['*'], string $pageName = 'page', int|null $page = null)`

Get a paginator only supporting simple next and previous links.

This is more efficient on larger data-sets, etc.

Parameters

int	$perPage
array	$columns
string	$pageName
int\|null	$page

Return Value

Paginator

in Builder at line 2326
`int getCountForPagination(array $columns = ['*'])`

Get the count of the total records for the paginator.

Parameters

array

$columns

Return Value

int

in Builder at line 2348
`protected array runPaginationCountQuery(array $columns = ['*'])`

Run a pagination count query.

Parameters

array

$columns

Return Value

array

in Builder at line 2377
`protected Builder cloneForPaginationCount()`

Clone the existing query instance for usage in a pagination subquery.

Return Value

in Builder at line 2389
`protected array withoutSelectAliases(array $columns)`

Remove the column aliases since they will break count queries.

Parameters

array

$columns

Return Value

array

in Builder at line 2402
`LazyCollection cursor()`

Get a lazy collection for the given query.

Return Value

LazyCollection

in Builder at line 2422
`protected void enforceOrderBy()`

Throw an exception if the query doesn't have an orderBy clause.

Return Value

void

Exceptions

RuntimeException

in Builder at line 2436
`Collection pluck(string $column, string|null $key = null)`

Get an array with the values of a given column.

Parameters

string	$column
string\|null	$key

Return Value

in Builder at line 2472
`protected string|null stripTableForPluck(string $column)`

Strip off the table name or alias from a column identifier.

Parameters

string

$column

Return Value

string|null

in Builder at line 2491
`protected Collection pluckFromObjectColumn(array $queryResult, string $column, string $key)`

Retrieve column values from rows represented as objects.

Parameters

array	$queryResult
string	$column
string	$key

Return Value

in Builder at line 2516
`protected Collection pluckFromArrayColumn(array $queryResult, string $column, string $key)`

Retrieve column values from rows represented as arrays.

Parameters

array	$queryResult
string	$column
string	$key

Return Value

in Builder at line 2540
`string implode(string $column, string $glue = '')`

Concatenate values of a given column as a string.

Parameters

string	$column
string	$glue

Return Value

string

in Builder at line 2550
`bool exists()`

Determine if any rows exist for the current query.

Return Value

bool

in Builder at line 2573
`bool doesntExist()`

Determine if no rows exist for the current query.

Return Value

bool

in Builder at line 2584
`mixed existsOr(Closure $callback)`

Execute the given callback if no rows exist for the current query.

Parameters

Closure

$callback

Return Value

mixed

in Builder at line 2595
`mixed doesntExistOr(Closure $callback)`

Execute the given callback if rows exist for the current query.

Parameters

Closure

$callback

Return Value

mixed

in Builder at line 2606
`int count(string $columns = '*')`

Retrieve the "count" result of the query.

Parameters

string

$columns

Return Value

int

in Builder at line 2617
`mixed min(string $column)`

Retrieve the minimum value of a given column.

Parameters

string

$column

Return Value

mixed

in Builder at line 2628
`mixed max(string $column)`

Retrieve the maximum value of a given column.

Parameters

string

$column

Return Value

mixed

in Builder at line 2639
`mixed sum(string $column)`

Retrieve the sum of the values of a given column.

Parameters

string

$column

Return Value

mixed

in Builder at line 2652
`mixed avg(string $column)`

Retrieve the average of the values of a given column.

Parameters

string

$column

Return Value

mixed

in Builder at line 2663
`mixed average(string $column)`

Alias for the "avg" method.

Parameters

string

$column

Return Value

mixed

in Builder at line 2675
`mixed aggregate(string $function, array $columns = ['*'])`

Execute an aggregate function on the database.

Parameters

string	$function
array	$columns

Return Value

mixed

in Builder at line 2694
`float|int numericAggregate(string $function, array $columns = ['*'])`

Execute a numeric aggregate function on the database.

Parameters

string	$function
array	$columns

Return Value

float|int

in Builder at line 2723
`protected $this setAggregate(string $function, array $columns)`

Set the aggregate property without running the query.

Parameters

string	$function
array	$columns

Return Value

$this

in Builder at line 2745
`protected mixed onceWithColumns(array $columns, callable $callback)`

Execute the given callback while selecting the given columns.

After running the callback, the columns are reset to the original value.

Parameters

array	$columns
callable	$callback

Return Value

mixed

in Builder at line 2766
`bool insert(array $values)`

Insert a new record into the database.

Parameters

array

$values

Return Value

bool

in Builder at line 2805
`int insertOrIgnore(array $values)`

Insert a new record into the database while ignoring errors.

Parameters

array

$values

Return Value

int

in Builder at line 2833
`int insertGetId(array $values, string|null $sequence = null)`

Insert a new record and get the value of the primary key.

Parameters

array	$values
string\|null	$sequence

Return Value

int

in Builder at line 2849
`int insertUsing(array $columns, Closure|Builder|string $query)`

Insert new records into the table using a subquery.

Parameters

array	$columns
Closure\|Builder\|string	$query

Return Value

int

in Builder at line 2865
`int update(array $values)`

Update a record in the database.

Parameters

array

$values

Return Value

int

in Builder at line 2881
`bool updateOrInsert(array $attributes, array $values = [])`

Insert or update a record matching the attributes, and fill it with values.

Parameters

array	$attributes
array	$values

Return Value

bool

in Builder at line 2904
`int increment(string $column, float|int $amount = 1, array $extra = [])`

Increment a column's value by a given amount.

Parameters

string	$column
float\|int	$amount
array	$extra

Return Value

int

Exceptions

in Builder at line 2927
`int decrement(string $column, float|int $amount = 1, array $extra = [])`

Decrement a column's value by a given amount.

Parameters

string	$column
float\|int	$amount
array	$extra

Return Value

int

Exceptions

in Builder at line 2946
`int delete(mixed $id = null)`

Delete a record from the database.

Parameters

mixed

$id

Return Value

int

in Builder at line 2967
`void truncate()`

Run a truncate statement on the table.

Return Value

void

at line 120
`Builder newQuery()`

Get a new instance of the join clause builder.

Return Value

at line 130
`protected Builder forSubQuery()`

Create a new query instance for sub-query.

Return Value

in Builder at line 3000
`Expression raw(mixed $value)`

Create a raw database expression.

Parameters

mixed

$value

Return Value

Expression

in Builder at line 3010
`array getBindings()`

Get the current query value bindings in a flattened array.

Return Value

array

in Builder at line 3020
`array getRawBindings()`

Get the raw array of bindings.

Return Value

array

in Builder at line 3034
`$this setBindings(array $bindings, string $type = 'where')`

Set the bindings on the query builder.

Parameters

array	$bindings
string	$type

Return Value

$this

Exceptions

in Builder at line 3054
`$this addBinding(mixed $value, string $type = 'where')`

Add a binding to the query.

Parameters

mixed	$value
string	$type

Return Value

$this

Exceptions

in Builder at line 3075
`$this mergeBindings(Builder $query)`

Merge an array of bindings into our bindings.

Parameters

$query

Return Value

$this

in Builder at line 3088
`protected array cleanBindings(array $bindings)`

Remove all of the expressions from a list of bindings.

Parameters

array

$bindings

Return Value

array

in Builder at line 3101
`protected mixed flattenValue(mixed $value)`

Get a scalar type value from an unknown type of input.

Parameters

mixed

$value

Return Value

mixed

in Builder at line 3111
`protected string defaultKeyName()`

Get the default key name of the table.

Return Value

string

in Builder at line 3121
`ConnectionInterface getConnection()`

Get the database connection instance.

Return Value

ConnectionInterface

in Builder at line 3131
`Processor getProcessor()`

Get the database query processor instance.

Return Value

Processor

in Builder at line 3141
`Grammar getGrammar()`

Get the query grammar instance.

Return Value

Grammar

in Builder at line 3151
`$this useWritePdo()`

Use the write pdo for query.

Return Value

$this

in Builder at line 3164
`protected bool isQueryable(mixed $value)`

Determine if the value is a query builder instance or a Closure.

Parameters

mixed

$value

Return Value

bool

in Builder at line 3178
`Builder cloneWithout(array $properties)`

Clone the query without the given properties.

Parameters

array

$properties

Return Value

in Builder at line 3193
`Builder cloneWithoutBindings(array $except)`

Clone the query without the given bindings.

Parameters

array

$except

Return Value

in Builder at line 3207
`$this dump()`

Dump the current SQL and bindings.

Return Value

$this

in Builder at line 3219
`void dd()`

Die and dump the current SQL and bindings.

Return Value

void

at line 93
`$this on(Closure|string $first, string|null $operator = null, Expression|string|null $second = null, string $boolean = 'and')`

Add an "on" clause to the join.

On clauses can be chained, e.g.

$join->on('contacts.user_id', '=', 'users.id') ->on('contacts.info_id', '=', 'info.id')

will produce the following SQL:

on contacts.user_id = users.id and contacts.info_id = info.id

Parameters

Closure\|string	$first
string\|null	$operator
Expression\|string\|null	$second
string	$boolean

Return Value

$this

Exceptions

at line 110
`JoinClause orOn(Closure|string $first, string|null $operator = null, string|null $second = null)`

Add an "or on" clause to the join.

Parameters

Closure\|string	$first
string\|null	$operator
string\|null	$second

Return Value

JoinClause

at line 140
`protected Builder newParentQuery()`

Create a new parent query instance.

Return Value