SYSTEM - PHP Framework
Back to top  

ConnectionSQLite

Extends \SYSTEM\DB\ConnectionAbstr

SQLite Connection Class provided by System to connect to SQLite Databasefile.

package

SYSTEM\DB

Methods

Connect to the DB upon Construction.

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

Arguments

$dbinfo

\SYSTEM\DB\DBINFO

Database Information Object

Destruct the Database Connection upon Destruction.

__destruct()
inherited abstract

Close the Database Connection.

close() : boolean
inherited abstract

Response

boolean

Returns true or false depending on success

Commit a Transaction on the Database Connection

commit() : boolean
inherited abstract

Response

boolean

Returns true or false depending on success.

Exec Query on Database

exec(string $query) : \SYSTEM\DB\Result
inherited 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
inherited 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
inherited 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
inherited 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
inherited abstract

Response

boolean

Returns true or false depending on success.

Properties

ressource Variable to store the open Connection

connection :

Type(s)