$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 |