SYSTEM - PHP Framework
Back to top  

ConnectionAbstr

Abstract Connection Class provided by System as a PDO Controller.

package

SYSTEM\DB

Methods

Connect to the DB upon Construction.

__construct(\SYSTEM\DB\DBINFO $dbinfo)
abstract

Arguments

$dbinfo

\SYSTEM\DB\DBINFO

Database Information Object

Destruct the Database Connection upon Destruction.

__destruct()
abstract

Close the Database Connection.

close() : boolean
abstract

Response

boolean

Returns true or false depending on success

Commit a Transaction on the Database Connection

commit() : boolean
abstract

Response

boolean

Returns true or false depending on success.

Exec Query on Database

exec(string $query) : \SYSTEM\DB\Result
abstract

Arguments

$query

string

SQL string of the Statement

Response

\SYSTEM\DB\Result

Returns Database Query Result.

Helperfunction to convert Prepared Values to SQL Type identifiers

getPrepareValueType(string $value) : string
static

Arguments

$value

string

Value to be examined regarding Type

Response

string

Returns d,i,s or b depending on the values type.

Query the Connection using Prepare Statement

prepare(string $stmtName, string $stmt, array $values, string $types = null) : \SYSTEM\DB\Result
abstract

Arguments

$stmtName

string

Name of the Statement - espec for PostgreSQL important

$stmt

string

SQL string of the Statement

$values

array

Array of Prepare Values

$types

string

types sql prepare string

Response

\SYSTEM\DB\Result

Returns Database Query Result.

Query the Connection using normal Query Statement

query(string $query) : \SYSTEM\DB\Result
abstract

Arguments

$query

string

SQL string of the Statement

Response

\SYSTEM\DB\Result

Returns Database Query Result.

Open a Transaction on the Database Connection

trans() : boolean
abstract

Response

boolean

Returns true or false depending on success.