Builder (Database\Eloquent)
Builder
class Builder (View source)
Traits
BuildsQueries |
QueriesRelationships |
Methods
bool | chunk(int $count, callable $callback) Chunk the results of the query. | from BuildsQueries |
bool | each(callable $callback, int $count = 1000) Execute a callback over each item while chunking. | from BuildsQueries |
mixed | first(array $columns = array('*')) Execute the query and get the first result. | from BuildsQueries |
mixed | when(mixed $value, callable $callback, callable $default = null) Apply the callback's query changes if the given "value" is true. | from BuildsQueries |
mixed | unless(mixed $value, callable $callback, callable $default = null) Apply the callback's query changes if the given "value" is false. | from BuildsQueries |
Builder|QueriesRelationships | has(string $relation, string $operator = '>=', int $count = 1, string $boolean = 'and', Closure $callback = null) Add a relationship count / exists condition to the query. | from QueriesRelationships |
Builder|QueriesRelationships | orHas(string $relation, string $operator = '>=', int $count = 1) Add a relationship count / exists condition to the query with an "or". | from QueriesRelationships |
Builder|QueriesRelationships | doesntHave(string $relation, string $boolean = 'and', Closure $callback = null) Add a relationship count / exists condition to the query. | from QueriesRelationships |
Builder|QueriesRelationships | whereHas(string $relation, Closure $callback = null, string $operator = '>=', int $count = 1) Add a relationship count / exists condition to the query with where clauses. | from QueriesRelationships |
Builder|QueriesRelationships | orWhereHas(string $relation, Closure $callback = null, string $operator = '>=', int $count = 1) Add a relationship count / exists condition to the query with where clauses and an "or". | from QueriesRelationships |
Builder|QueriesRelationships | whereDoesntHave(string $relation, Closure $callback = null) Add a relationship count / exists condition to the query with where clauses. | from QueriesRelationships |
$this | withCount(mixed $relations) Add subselect queries to count the relations. | from QueriesRelationships |
Builder|QueriesRelationships | mergeConstraintsFrom(Builder $from) Merge the where constraints from another query to the current query. | from QueriesRelationships |
void | __construct(Builder $query) Create a new Eloquent query builder instance. | |
Model | make(array $attributes = array()) Create and return an un-saved model instance. | |
$this | withGlobalScope(string $identifier, Scope|Closure $scope) Register a new global scope. | |
$this | withoutGlobalScope(Scope|string $scope) Remove a registered global scope. | |
$this | withoutGlobalScopes(array $scopes = null) Remove all or passed registered global scopes. | |
array | removedScopes() Get an array of global scopes that were removed from the query. | |
$this | whereKey(mixed $id) Add a where clause on the primary key to the query. | |
$this | where(string|array|Closure $column, string $operator = null, mixed $value = null, string $boolean = 'and') Add a basic where clause to the query. | |
Builder|Builder | orWhere(string|Closure $column, string $operator = null, mixed $value = null) Add an "or where" clause to the query. | |
Collection | hydrate(array $items) Create a collection of models from plain arrays. | |
Collection | fromQuery(string $query, array $bindings = array()) Create a collection of models from a raw query. | |
Model|Collection|Builder[]|Builder|null | find(mixed $id, array $columns = array('*')) Find a model by its primary key. | |
Collection | findMany(array $ids, array $columns = array('*')) Find multiple models by their primary keys. | |
Model|Collection | findOrFail(mixed $id, array $columns = array('*')) Find a model by its primary key or throw an exception. | |
Model | findOrNew(mixed $id, array $columns = array('*')) Find a model by its primary key or return fresh model instance. | |
Model | firstOrNew(array $attributes, array $values = array()) Get the first record matching the attributes or instantiate it. | |
Model | firstOrCreate(array $attributes, array $values = array()) Get the first record matching the attributes or create it. | |
Model | updateOrCreate(array $attributes, array $values = array()) Create or update a record matching the attributes, and fill it with values. | |
Model|Builder | firstOrFail(array $columns = array('*')) Execute the query and get the first result or throw an exception. | |
Model|Builder|mixed | firstOr(Closure|array $columns = array('*'), Closure $callback = null) Execute the query and get the first result or call a callback. | |
mixed | value(string $column) Get a single column's value from the first result of a query. | |
Collection|Builder[] | get(array $columns = array('*')) Execute the query as a "select" statement. | |
Model[] | getModels(array $columns = array('*')) Get the hydrated models without eager loading. | |
array | eagerLoadRelations(array $models) Eager load the relationships for the models. | |
Relation | getRelation(string $name) Get the relation instance for the given relation name. | |
Generator | cursor() Get a generator for the given query. | |
bool | chunkById(int $count, callable $callback, string $column = null, string|null $alias = null) Chunk the results of a query by comparing numeric IDs. | |
Collection | pluck(string $column, string|null $key = null) Get an array with the values of a given column. | |
LengthAwarePaginator | paginate(int $perPage = null, array $columns = array('*'), string $pageName = 'page', int|null $page = null) Paginate the given query. | |
Paginator | simplePaginate(int $perPage = null, array $columns = array('*'), string $pageName = 'page', int|null $page = null) Paginate the given query into a simple paginator. | |
Model | create(array $attributes = array()) Save a new model and return the instance. | |
Model | forceCreate(array $attributes) Save a new model and return the instance. Allow mass-assignment. | |
int | update(array $values) Update a record in the database. | |
int | increment(string $column, int $amount = 1, array $extra = array()) Increment a column's value by a given amount. | |
int | decrement(string $column, int $amount = 1, array $extra = array()) Decrement a column's value by a given amount. | |
mixed | delete() Delete a record from the database. | |
mixed | forceDelete() Run the default delete function on the builder. | |
void | onDelete(Closure $callback) Register a replacement for the default delete function. | |
mixed | scopes(array $scopes) Call the given local model scopes. | |
Builder|Builder | applyScopes() Apply the scopes to the Eloquent builder instance and return it. | |
$this | with(mixed $relations) Set the relationships that should be eager loaded. | |
$this | without(mixed $relations) Prevent the specified relations from being eager loaded. | |
Model | newModelInstance(array $attributes = array()) Create a new instance of the model being queried. | |
Builder | getQuery() Get the underlying query builder instance. | |
$this | setQuery(Builder $query) Set the underlying query builder instance. | |
Builder | toBase() Get a base query builder instance. | |
array | getEagerLoads() Get the relationships being eagerly loaded. | |
$this | setEagerLoads(array $eagerLoad) Set the relationships being eagerly loaded. | |
Model | getModel() Get the model instance being queried. | |
$this | setModel(Model $model) Set a model instance for the model being queried. | |
Closure | getMacro(string $name) Get the given macro by name. | |
mixed | __call(string $method, array $parameters) Dynamically handle calls into the query instance. | |
static mixed | __callStatic(string $method, array $parameters) Dynamically handle calls into the query instance. | |
void | __clone() Force a clone of the underlying query builder when cloning. |
Details
bool chunk(int $count, callable $callback)
Chunk the results of the query.
bool each(callable $callback, int $count = 1000)
Execute a callback over each item while chunking.
mixed first(array $columns = array('*'))
Execute the query and get the first result.
mixed when(mixed $value, callable $callback, callable $default = null)
Apply the callback's query changes if the given "value" is true.
mixed unless(mixed $value, callable $callback, callable $default = null)
Apply the callback's query changes if the given "value" is false.
Builder|QueriesRelationships has(string $relation, string $operator = '>=', int $count = 1, string $boolean = 'and', Closure $callback = null)
Add a relationship count / exists condition to the query.
Builder|QueriesRelationships orHas(string $relation, string $operator = '>=', int $count = 1)
Add a relationship count / exists condition to the query with an "or".
Builder|QueriesRelationships doesntHave(string $relation, string $boolean = 'and', Closure $callback = null)
Add a relationship count / exists condition to the query.
Builder|QueriesRelationships whereHas(string $relation, Closure $callback = null, string $operator = '>=', int $count = 1)
Add a relationship count / exists condition to the query with where clauses.
Builder|QueriesRelationships orWhereHas(string $relation, Closure $callback = null, string $operator = '>=', int $count = 1)
Add a relationship count / exists condition to the query with where clauses and an "or".
Builder|QueriesRelationships whereDoesntHave(string $relation, Closure $callback = null)
Add a relationship count / exists condition to the query with where clauses.
$this withCount(mixed $relations)
Add subselect queries to count the relations.
Builder|QueriesRelationships mergeConstraintsFrom(Builder $from)
Merge the where constraints from another query to the current query.
void __construct(Builder $query)
Create a new Eloquent query builder instance.
Model make(array $attributes = array())
Create and return an un-saved model instance.
$this withoutGlobalScope(Scope|string $scope)
Remove a registered global scope.
$this withoutGlobalScopes(array $scopes = null)
Remove all or passed registered global scopes.
array removedScopes()
Get an array of global scopes that were removed from the query.
$this whereKey(mixed $id)
Add a where clause on the primary key to the query.
$this where(string|array|Closure $column, string $operator = null, mixed $value = null, string $boolean = 'and')
Add a basic where clause to the query.
Builder|Builder orWhere(string|Closure $column, string $operator = null, mixed $value = null)
Add an "or where" clause to the query.
Collection hydrate(array $items)
Create a collection of models from plain arrays.
Collection fromQuery(string $query, array $bindings = array())
Create a collection of models from a raw query.
Model|Collection|Builder[]|Builder|null find(mixed $id, array $columns = array('*'))
Find a model by its primary key.
Collection findMany(array $ids, array $columns = array('*'))
Find multiple models by their primary keys.
Model|Collection findOrFail(mixed $id, array $columns = array('*'))
Find a model by its primary key or throw an exception.
Model findOrNew(mixed $id, array $columns = array('*'))
Find a model by its primary key or return fresh model instance.
Model firstOrNew(array $attributes, array $values = array())
Get the first record matching the attributes or instantiate it.
Model firstOrCreate(array $attributes, array $values = array())
Get the first record matching the attributes or create it.
Model updateOrCreate(array $attributes, array $values = array())
Create or update a record matching the attributes, and fill it with values.
Model|Builder firstOrFail(array $columns = array('*'))
Execute the query and get the first result or throw an exception.
Model|Builder|mixed firstOr(Closure|array $columns = array('*'), Closure $callback = null)
Execute the query and get the first result or call a callback.
mixed value(string $column)
Get a single column's value from the first result of a query.
Collection|Builder[] get(array $columns = array('*'))
Execute the query as a "select" statement.
Model[] getModels(array $columns = array('*'))
Get the hydrated models without eager loading.
array eagerLoadRelations(array $models)
Eager load the relationships for the models.
Relation getRelation(string $name)
Get the relation instance for the given relation name.
Generator cursor()
Get a generator for the given query.
bool chunkById(int $count, callable $callback, string $column = null, string|null $alias = null)
Chunk the results of a query by comparing numeric IDs.
Collection pluck(string $column, string|null $key = null)
Get an array with the values of a given column.
LengthAwarePaginator paginate(int $perPage = null, array $columns = array('*'), string $pageName = 'page', int|null $page = null)
Paginate the given query.
Paginator simplePaginate(int $perPage = null, array $columns = array('*'), string $pageName = 'page', int|null $page = null)
Paginate the given query into a simple paginator.
Model create(array $attributes = array())
Save a new model and return the instance.
Model forceCreate(array $attributes)
Save a new model and return the instance. Allow mass-assignment.
int update(array $values)
Update a record in the database.
int increment(string $column, int $amount = 1, array $extra = array())
Increment a column's value by a given amount.
int decrement(string $column, int $amount = 1, array $extra = array())
Decrement a column's value by a given amount.
mixed delete()
Delete a record from the database.
mixed forceDelete()
Run the default delete function on the builder.
Since we do not apply scopes here, the row will actually be deleted.
void onDelete(Closure $callback)
Register a replacement for the default delete function.
mixed scopes(array $scopes)
Call the given local model scopes.
$this with(mixed $relations)
Set the relationships that should be eager loaded.
$this without(mixed $relations)
Prevent the specified relations from being eager loaded.
Model newModelInstance(array $attributes = array())
Create a new instance of the model being queried.
Builder getQuery()
Get the underlying query builder instance.
$this setQuery(Builder $query)
Set the underlying query builder instance.
Builder toBase()
Get a base query builder instance.
array getEagerLoads()
Get the relationships being eagerly loaded.
$this setEagerLoads(array $eagerLoad)
Set the relationships being eagerly loaded.
Model getModel()
Get the model instance being queried.
$this setModel(Model $model)
Set a model instance for the model being queried.
Closure getMacro(string $name)
Get the given macro by name.
mixed __call(string $method, array $parameters)
Dynamically handle calls into the query instance.
static mixed __callStatic(string $method, array $parameters)
Dynamically handle calls into the query instance.
void __clone()
Force a clone of the underlying query builder when cloning.
© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.4/Illuminate/Database/Eloquent/Builder.html