Sql
Cria comandos SQL
Table of Contents
- $columns : array<string|int, mixed>|null
- $join : array<string|int, mixed>
- $joinValues : array<string|int, mixed>
- $limit : string
- $orderBy : array<string|int, mixed>
- $table : string
- $values : array<string|int, mixed>
- $where : array<string|int, mixed>
- $whereValues : array<string|int, mixed>
- __construct() : mixed
- Prepara a query
- addJoin() : mixed
- JOIN, LEFT JOIN .
- addOrderBy() : mixed
- Adiciona uma ordenação
- addWhere() : mixed
- WHERE .
- delete() : string
- DELETE FROM .
- insert() : string
- INSERT INTO ... VALUES
- select() : string
- SELECT * FROM .
- selectCount() : string
- SELECT COUNT(*) FROM
- setLimit() : mixed
- Define o limit
- setOrderBy() : mixed
- Define a ordenação principal
- setValues() : mixed
- update() : string
- UPDATE ... SET
- values() : array<string|int, mixed>
- join() : mixed
- limit() : string
- LIMIT .
- orderBy() : string
- ORDER BY.
- where() : string
- Retorna o SQL
Properties
$columns
public
array<string|int, mixed>|null
$columns
= null
$join
private
array<string|int, mixed>
$join
$joinValues
private
array<string|int, mixed>
$joinValues
$limit
private
string
$limit
$orderBy
private
array<string|int, mixed>
$orderBy
$table
private
string
$table
$values
private
array<string|int, mixed>
$values
$where
private
array<string|int, mixed>
$where
$whereValues
private
array<string|int, mixed>
$whereValues
Methods
__construct()
Prepara a query
public
__construct(string &$table) : mixed
Parameters
- $table : string
Return values
mixed —addJoin()
JOIN, LEFT JOIN .
public
addJoin(string $join, array<string|int, mixed> $values) : mixed
..
Parameters
- $join : string
- $values : array<string|int, mixed>
Return values
mixed —addOrderBy()
Adiciona uma ordenação
public
addOrderBy(string $orderBy, int $priority) : mixed
Parameters
- $orderBy : string
- $priority : int
Return values
mixed —addWhere()
WHERE .
public
addWhere(string $comparator, mixed $values) : mixed
..
Parameters
- $comparator : string
- $values : mixed
Return values
mixed —delete()
DELETE FROM .
public
delete() : string
..
Return values
string —insert()
INSERT INTO ... VALUES
public
insert() : string
Return values
string —select()
SELECT * FROM .
public
select() : string
..
Return values
string —selectCount()
SELECT COUNT(*) FROM
public
selectCount() : string
Return values
string —setLimit()
Define o limit
public
setLimit(int $offset, int $limit) : mixed
Parameters
- $offset : int
- $limit : int
Return values
mixed —setOrderBy()
Define a ordenação principal
public
setOrderBy(string $orderBy) : mixed
Parameters
- $orderBy : string
Return values
mixed —setValues()
public
setValues(mixed $values) : mixed
Parameters
- $values : mixed
Return values
mixed —update()
UPDATE ... SET
public
update() : string
Return values
string —values()
public
values() : array<string|int, mixed>
Return values
array<string|int, mixed> —join()
private
join() : mixed
Return values
mixed —limit()
LIMIT .
private
limit() : string
..
Return values
string —orderBy()
ORDER BY.
private
orderBy() : string
..
Return values
string —where()
Retorna o SQL
private
where() : string