$columns
$columns : array
SQL columns
Insert SQL class
$sql : \Pop\Db\Sql
SQL object
__construct(\Pop\Db\Sql $sql, mixed $columns = null) : \Pop\Db\Sql\AbstractSql
Constructor
Instantiate the SQL object.
| \Pop\Db\Sql | $sql | |
| mixed | $columns |
setSql(\Pop\Db\Sql $sql) : \Pop\Db\Sql\AbstractSql
Get the SQL object
| \Pop\Db\Sql | $sql |
getSql() : \Pop\Db\Sql
Set the SQL object
orderBy(mixed $by, string $order = 'ASC') : \Pop\Db\Sql\AbstractSql
Set the ORDER BY value
| mixed | $by | |
| string | $order |
limit(mixed $limit) : \Pop\Db\Sql\AbstractSql
Set the LIMIT value
| mixed | $limit |
offset(integer $offset) : \Pop\Db\Sql\AbstractSql
Set the OFFSET value
| integer | $offset |