Paginator simplePaginate(int $perPage = null, array $columns = array('*'), 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 Paginator

Builder sharedLock() Share lock the selected rows in the table. Return Value Builder

$this setQuery(Builder $query) Set the underlying query builder instance. Parameters Builder $query Return Value $this

$this setModel(Model $model) Set a model instance for the model being queried. Parameters Model $model Return Value $this

$this setEagerLoads(array $eagerLoad) Set the relationships being eagerly loaded. Parameters array $eagerLoad Return Value $this

$this setConnection(Connection $connection) Set the database connection instance. Parameters Connection $connection Return Value $this

$this setBindings(array $bindings, string $type = 'where') Set the bindings on the query builder. Parameters array $bindings string $type Return Value $this Exceptions InvalidArgumentException

Builder|Builder selectSub(Closure|Builder|string $query, string $as) Add a subselect expression to the query. Parameters Closure|Builder|string $query string $as Return Value Builder|Builder Exceptions InvalidArgumentException

Builder|Builder selectRaw(string $expression, array $bindings = array()) Add a new "raw" select expression to the query. Parameters string $expression array $bindings Return Value Builder|Builder

$this select(array|mixed $columns = array('*')) Set the columns to be selected. Parameters array|mixed $columns Return Value $this