Builder
class Builder extends Builder
TastyIgniter Database Manager Class
Methods
Get an array with the values of a given column.
Get an array with the values of a given column.
Perform a search on this query for term found in columns.
Add an "or search where" clause to the query.
Convenient method for where like clause
Convenient method for or where like clause
Internal method to apply a search constraint to the query.
No description
Get an array with the values of dates.
Paginate the given query.
Paginate the given query into a simple paginator.
Find a model by its primary key or return fresh model instance with filled attributes to use with forms.
Details
at line 22
Collection
lists(string $column, string|null $key = null)
Get an array with the values of a given column.
at line 35
Collection
dropdown(string $column, string|null $key = null)
Get an array with the values of a given column.
at line 51
Builder
search(string $term, array $columns = [], string $mode = 'all')
Perform a search on this query for term found in columns.
at line 65
Builder
orSearch(string $term, array $columns = [], string $mode = 'all')
Add an "or search where" clause to the query.
at line 80
Builder
like(string $column, $value, string $side = 'both', string $boolean = 'and')
Convenient method for where like clause
at line 94
Builder
orLike(string $column, $value, string $side = 'both')
Convenient method for or where like clause
at line 113
protected $this
searchInternal($term, array $columns, $mode, $boolean)
Internal method to apply a search constraint to the query.
Mode can be any of these options:
- all: result must contain all words
- any: result can contain any word
- exact: result must contain the exact phrase
at line 148
protected
likeInternal($column, $value, $side = null, $boolean = 'and')
No description
at line 178
array
pluckDates(string $column, string $keyFormat = 'Y-m', string $valueFormat = 'F Y')
Get an array with the values of dates.
at line 211
LengthAwarePaginator
paginate(int $perPage = null, int|null $page = null, array $columns = ['*'], string $pageName = 'page')
Paginate the given query.
at line 247
Paginator
simplePaginate(int $perPage = null, int|null $page = null, array $columns = ['*'], string $pageName = 'page')
Paginate the given query into a simple paginator.
at line 282
Model
findOrNew(mixed $id, array $columns = ['*'])
Find a model by its primary key or return fresh model instance with filled attributes to use with forms.