QueryBuilder
classe QueryBuilder implémente JsonSerializable (Voir la source)
Propriétés
| protected string | $table | The table name |
|
| protected string | $select | Select statement collector |
|
| protected string | $where | Where statement collector |
|
| protected array | $where_data_binding | The data binding information |
|
| protected string | $join | Join statement collector |
|
| protected string | $limit | Limit statement collector |
|
| protected string | $group | Group statement collector |
|
| protected string | $having | Having statement collector |
|
| protected string | $order | Order By statement collector |
|
| protected string | $as | Define the table as |
|
| protected PDO | $connection | The PDO instance |
|
| protected bool | $first | Define whether to retrieve information from the list |
|
| protected string | $prefix | The table prefix |
Méthodes
Add select column.
Create the table as
Add where clause into the request
Add where clause into the request
orWhere, add a condition of type:
Where clause with comparison in << is null >>
Where clause with comparison in <
Where clause with comparison <
WHERE column NOT BETWEEN '' AND ''
Where clause with <
Where clause with <
Join clause
Left Join clause
Right Join clause
On, if chained with itself must add an << and >> before, otherwise if chained with "orOn" who add a "before"
Clause On, followed by a combination by a comparator <
Clause Group By
clause having, is used with a groupBy
Clause Order By
Jump = Offset
Take = Limit
Max
Min
Avg
Sum
Count
Get make, only on the select request If the first selection mode is not active
Get the first record
Get the last record
Update action
Delete Action
Remove simplified stream from delete.
Action increment, add 1 by default to the specified field
Decrement action, subtracts 1 by default from the specified field
Allows a query with the DISTINCT clause
Truncate Action, empty the table
Insert Action
InsertAndGetLastId action launches the insert and lastInsertId actions
Drop Action, remove the table
Paginate, make pagination system
Check if a value already exists in the DB
Turn back the id of the last insertion
JsonSerialize implementation
Transformation automatically the result to JSON
Formats the select request
Returns the name of the table.
Returns the prefix.
Modify the prefix
Change the table's name
Define the data to associate
__toString
Détails
__construct(string $table, PDO $connection)
QueryBuilder Constructor
QueryBuilder
select(array $select = ['*'])
Add select column.
SELECT $column | SELECT column1, column2, ...
QueryBuilder
as(string $as)
Create the table as
QueryBuilder
where(string $column, mixed $comparator = '=', mixed $value = null, string $boolean = 'and')
Add where clause into the request
WHERE column1 $comparator $value|column
QueryBuilder
whereRaw(string $where)
Add where clause into the request
WHERE column1 $comparator $value|column
QueryBuilder
orWhere(string $column, mixed $comparator = '=', mixed $value = null)
orWhere, add a condition of type:
[where column = value or column = value]
QueryBuilder
whereNull(string $column, string $boolean = 'and')
Where clause with comparison in << is null >>
WHERE column IS NULL
QueryBuilder
whereNotNull($column, string $boolean = 'and')
Where clause with comparison in <
WHERE column NOT NULL
QueryBuilder
whereBetween(string $column, array $range, string $boolean = 'and')
Where clause with comparison <
WHERE column BETWEEN '' AND ''
QueryBuilder
whereNotBetween(string $column, array $range)
WHERE column NOT BETWEEN '' AND ''
QueryBuilder
whereIn(string $column, array $range, string $boolean = 'and')
Where clause with <
QueryBuilder
whereNotIn(string $column, array $range)
Where clause with <
QueryBuilder
join(string $table, string $first, mixed $comparator = '=', string|null $second = null)
Join clause
QueryBuilder
leftJoin(string $table, string $first, mixed $comparator = '=', string|null $second = null)
Left Join clause
QueryBuilder
rightJoin(string $table, string $first, mixed $comparator = '=', string|null $second = null)
Right Join clause
QueryBuilder
andOn(string $first, mixed $comparator = '=', string $second = null)
On, if chained with itself must add an << and >> before, otherwise if chained with "orOn" who add a "before"
QueryBuilder
orOn(string $first, mixed $comparator = '=', string $second = null)
Clause On, followed by a combination by a comparator <
QueryBuilder
groupBy(string $column)
Clause Group By
QueryBuilder
group(string $column)
déprécié
déprécié
Clause Group By
QueryBuilder
having(string $column, mixed $comparator = '=', mixed $value = null, string $boolean = 'and')
clause having, is used with a groupBy
QueryBuilder
orderBy(string $column, string $type = 'asc')
Clause Order By
QueryBuilder
jump(int $offset = 0)
Jump = Offset
QueryBuilder
take(int $limit)
Take = Limit
int|float
max(string $column)
Max
int|float
min(string $column)
Min
int|float
avg(string $column)
Avg
int|float
sum(string $column)
Sum
int
count(string $column = '*')
Count
array|object|null
get(array $columns = [])
Get make, only on the select request If the first selection mode is not active
object|null
first()
Get the first record
object|null
last()
Get the last record
int
update(array $data = [])
Update action
int
delete()
Delete Action
int
remove(string $column, mixed $comparator = '=', string $value = null)
Remove simplified stream from delete.
int
increment(string $column, int $step = 1)
Action increment, add 1 by default to the specified field
int
decrement(string $column, int $step = 1)
Decrement action, subtracts 1 by default from the specified field
QueryBuilder
distinct(string $column)
Allows a query with the DISTINCT clause
bool
truncate()
Truncate Action, empty the table
int
insert(array $values)
Insert Action
The data to be inserted into the database.
string|int|bool
insertAndGetLastId(array $values)
InsertAndGetLastId action launches the insert and lastInsertId actions
bool
drop()
Drop Action, remove the table
array
paginate(int $number_of_page, int $current = 0, int $chunk = null)
Paginate, make pagination system
bool
exists(string|null $column = null, mixed $value = null)
Check if a value already exists in the DB
string
getLastInsertId(string|null $name = null)
Turn back the id of the last insertion
string
jsonSerialize()
JsonSerialize implementation
string
toJson(int $option = 0)
Transformation automatically the result to JSON
string
toSql()
Formats the select request
string
getTable()
Returns the name of the table.
string
getPrefix()
Returns the prefix.
QueryBuilder
setPrefix(string $prefix)
Modify the prefix
QueryBuilder
setTable(string $table)
Change the table's name
void
setWhereDataBinding(array $data_binding)
Define the data to associate
string
__toString()
__toString