$table
$table : string
Table
Table gateway class
$sql : \Pop\Db\Sql
Sql object
__construct(\Pop\Db\Sql $sql, string $table = null) : \Pop\Db\Gateway\AbstractGateway
Constructor
Instantiate the AbstractGateway object.
| \Pop\Db\Sql | $sql | |
| string | $table |
setTable(string $table) : \Pop\Db\Gateway\AbstractGateway
Set the table
| string | $table |
setPrimaryKeys(mixed $keys) : \Pop\Db\Gateway\AbstractGateway
Set the primary keys
| mixed | $keys |
getSql() : \Pop\Db\Sql
Get the SQL object
sql() : \Pop\Db\Sql
Get the SQL object (alias method)
select(array $columns = null, mixed $where = null, array $params = null, array $options = null) : \Pop\Db\Gateway\Table
Select rows from the table
| array | $columns | |
| mixed | $where | |
| array | $params | |
| array | $options |
insert(array $columns) : \Pop\Db\Gateway\Table
Insert rows into the table
| array | $columns |
update(array $columns, mixed $where = null, array $pars = null) : \Pop\Db\Gateway\Table
Update rows in the table
| array | $columns | |
| mixed | $where | |
| array | $pars |
delete(mixed $where = null, array $pars = null) : \Pop\Db\Gateway\Table
Delete rows from the table
| mixed | $where | |
| array | $pars |