PHP Class BaseQuery, fluentpdo

Inheritance: implements IteratorAggregate
Afficher le fichier Open project: fpdo/fluentpdo Class Usage Examples

Protected Properties

Свойство Type Description
$clauses - definition clauses
$parameters array
$statements array

Méthodes publiques

Méthode Description
asObject ( boolean | object $object = true ) : BaseQuery Select an item as object
execute ( ) : PDOStatement Execute query with earlier added parameters
getIterator ( ) : PDOStatement Implements method from IteratorAggregate
getParameters ( ) : array Get query parameters
getQuery ( boolean $formatted = true ) : string Get query string
getResult ( ) : PDOStatement Get PDOStatement result
getTime ( ) : float Get time of execution

Méthodes protégées

Méthode Description
__construct ( FluentPDO $fpdo, $clauses ) BaseQuery constructor.
addStatement ( $clause, $statement, array $parameters = [] ) Add statement for all kind of clauses
buildParameters ( ) : array
buildQuery ( ) : string Generate query
getPDO ( ) : PDO
getStructure ( ) : FluentStructure
quote ( $value ) : string
resetClause ( $clause ) Remove all prev defined statements

Private Methods

Méthode Description
clauseNotEmpty ( $clause ) : boolean
debugger ( ) Echo/pass a debug string
formatValue ( DateTime $val ) : string
initClauses ( ) Initialize statement and parameter clauses.

Method Details

__construct() protected méthode

BaseQuery constructor.
protected __construct ( FluentPDO $fpdo, $clauses )
$fpdo FluentPDO
$clauses

addStatement() protected méthode

Add statement for all kind of clauses
protected addStatement ( $clause, $statement, array $parameters = [] )
$clause
$statement
$parameters array

asObject() public méthode

Select an item as object
public asObject ( boolean | object $object = true ) : BaseQuery
$object boolean | object If set to true, items are returned as stdClass, otherwise a class name can be passed and a new instance of this class is return. Can be set to false to return items as an associative array.
Résultat BaseQuery

buildParameters() protected méthode

protected buildParameters ( ) : array
Résultat array

buildQuery() protected méthode

Generate query
protected buildQuery ( ) : string
Résultat string

execute() public méthode

Execute query with earlier added parameters
public execute ( ) : PDOStatement
Résultat PDOStatement

getIterator() public méthode

Implements method from IteratorAggregate
public getIterator ( ) : PDOStatement
Résultat PDOStatement

getPDO() protected méthode

protected getPDO ( ) : PDO
Résultat PDO

getParameters() public méthode

Get query parameters
public getParameters ( ) : array
Résultat array

getQuery() public méthode

Get query string
public getQuery ( boolean $formatted = true ) : string
$formatted boolean - Return formatted query
Résultat string

getResult() public méthode

Get PDOStatement result
public getResult ( ) : PDOStatement
Résultat PDOStatement

getStructure() protected méthode

protected getStructure ( ) : FluentStructure
Résultat FluentStructure

getTime() public méthode

Get time of execution
public getTime ( ) : float
Résultat float

quote() protected méthode

protected quote ( $value ) : string
$value
Résultat string

resetClause() protected méthode

Remove all prev defined statements
protected resetClause ( $clause )
$clause

Property Details

$clauses protected_oe property

- definition clauses
protected $clauses

$parameters protected_oe property

protected array $parameters
Résultat array

$statements protected_oe property

protected array $statements
Résultat array