PHP Class Pop\Db\Sql\AbstractSql

Author: Nick Sagona, III ([email protected])
Exibir arquivo Open project: nicksagona/PopPHP

Protected Properties

Property Type Description
$columns array SQL columns
$limit mixed LIMIT value
$offset integer OFFSET value
$orderBy string ORDER BY value
$sql Pop\Db\Sql SQL object

Public Methods

Method Description
__construct ( Sql $sql, mixed $columns = null ) : AbstractSql Constructor
limit ( mixed $limit ) : AbstractSql Set the LIMIT value
offset ( integer $offset ) : AbstractSql Set the OFFSET value
orderBy ( mixed $by, string $order = 'ASC' ) : AbstractSql Set the ORDER BY value
render ( ) : string Abstract render method

Method Details

__construct() public method

Instantiate the SQL object.
public __construct ( Sql $sql, mixed $columns = null ) : AbstractSql
$sql Pop\Db\Sql
$columns mixed
return AbstractSql

limit() public method

Set the LIMIT value
public limit ( mixed $limit ) : AbstractSql
$limit mixed
return AbstractSql

offset() public method

Set the OFFSET value
public offset ( integer $offset ) : AbstractSql
$offset integer
return AbstractSql

orderBy() public method

Set the ORDER BY value
public orderBy ( mixed $by, string $order = 'ASC' ) : AbstractSql
$by mixed
$order string
return AbstractSql

render() abstract public method

Abstract render method
abstract public render ( ) : string
return string

Property Details

$columns protected_oe property

SQL columns
protected array $columns
return array

$limit protected_oe property

LIMIT value
protected mixed $limit
return mixed

$offset protected_oe property

OFFSET value
protected int $offset
return integer

$orderBy protected_oe property

ORDER BY value
protected string $orderBy
return string

$sql protected_oe property

SQL object
protected Sql,Pop\Db $sql
return Pop\Db\Sql