class Sqlite3 implements IDatabase

Sqlite 3 Database Class

Constants

SQLITE3_OPEN_SHAREDCACHE

Sqlite 3 sharedcache value

Properties

protected bool $isConnected Database connection state
protected Sqlite3 $db Sqlite 3 Database object
string $location Path to the SQLite database, or :memory: to use in-memory database.
integer $mode Optional flags used to determine how to open the SQLite database.

Methods

connect(array $options = null)

(non-PHPdoc)

__destruct()

Destructor

close()

(non-PHPdoc)

query($query)

(non-PHPdoc)

fetchSingle($query)

No description

SQLite3Stmt|boolean
prepare(string $query)

Prepares an SQL statement for execution

multitype:array
fetch(string $query)

Sqlite Select

boolean
_exec(string $query)

Sqlite Update or Delete

number|boolean
insert(string $query)

Sqlite Insert

exec(string $query)

Executes a result-less query against a given database

bool
isConnected()

(non-PHPdoc)

setOptions(array $options = null)

Set Options

string
escapeString($query)

(non-PHPdoc)

getLastInsertRowId()

No description

Details

at line 60
connect(array $options = null)

(non-PHPdoc)

Parameters

array $options

Exceptions

DatabaseException

See also

\jtl\Connector\Core\Database\IDatabase::connect()

at line 84
__destruct()

Destructor

at line 96
close()

(non-PHPdoc)

See also

\jtl\Connector\Core\Database\IDatabase::close()

at line 106
query($query)

(non-PHPdoc)

Parameters

$query

See also

\jtl\Connector\Core\Database\IDatabase::query()

at line 124
fetchSingle($query)

Parameters

$query

at line 135
SQLite3Stmt|boolean prepare(string $query)

Prepares an SQL statement for execution

Parameters

string $query

Return Value

SQLite3Stmt|boolean Returns an SQLite3Stmt object on success or FALSE on failure.

at line 146
multitype:array fetch(string $query)

Sqlite Select

Parameters

string $query

Return Value

multitype:array |NULL

at line 177
protected boolean _exec(string $query)

Sqlite Update or Delete

Parameters

string $query

Return Value

boolean

at line 188
number|boolean insert(string $query)

Sqlite Insert

Parameters

string $query

Return Value

number|boolean

at line 202
exec(string $query)

Executes a result-less query against a given database

Parameters

string $query

at line 212
bool isConnected()

(non-PHPdoc)

Return Value

bool $this->_isConnected

See also

\jtl\Connector\Core\Database\IDatabase::isConnected()

at line 222
setOptions(array $options = null)

Set Options

Parameters

array $options

at line 241
string escapeString($query)

(non-PHPdoc)

Parameters

$query

Return Value

string

See also

\jtl\Connector\Core\Database\IDatabase::escapeString()

at line 246
getLastInsertRowId()