$columns
$columns : array
SQL columns
Select SQL class
$sql : \Pop\Db\Sql
SQL object
$where : \Pop\Db\Sql\Where
WHERE predicate object
$having : \Pop\Db\Sql\Having
HAVING predicate 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 |
join(string $foreignTable, array $columns, string $typeOfJoin = 'LEFT JOIN') : \Pop\Db\Sql\Select
Set the JOIN clause
| string | $foreignTable | |
| array | $columns | |
| string | $typeOfJoin |
distinct() : \Pop\Db\Sql\Select
Set the DISTINCT keyword
where(mixed $where = null) : \Pop\Db\Sql\Select
Set the WHERE clause
| mixed | $where |
groupBy(mixed $by) : \Pop\Db\Sql\Select
Set the GROUP BY value
| mixed | $by |
having(mixed $having = null) : \Pop\Db\Sql\Having
Set the HAVING clause
| mixed | $having |