class Sqlite3 extends Sqlite3

Sqlite 3 Database Class

Constants

SQLITE3_OPEN_SHAREDCACHE

Sqlite 3 sharedcache value

Properties

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

Methods

connect(array $options = null)

(non-PHPdoc)

from Sqlite3
__destruct()

Destructor

from Sqlite3
close()

(non-PHPdoc)

from Sqlite3
query($query)

(non-PHPdoc)

from Sqlite3
fetchSingle($query)

No description

from Sqlite3
SQLite3Stmt|boolean
prepare(string $query)

Prepares an SQL statement for execution

from Sqlite3
multitype:array
fetch(string $query)

Sqlite Select

from Sqlite3
boolean
_exec(string $query)

Sqlite Update or Delete

from Sqlite3
number|boolean
insert(string $query)

Sqlite Insert

from Sqlite3
exec(string $query)

Executes a result-less query against a given database

from Sqlite3
bool
isConnected()

(non-PHPdoc)

from Sqlite3
setOptions(array $options = null)

Set Options

from Sqlite3
string
escapeString($query)

(non-PHPdoc)

from Sqlite3
getLastInsertRowId()

No description

from Sqlite3
static Sqlite3
getInstance()

Singleton

check()

No description

Details

in Sqlite3 at line 60
connect(array $options = null)

(non-PHPdoc)

Parameters

array $options

Exceptions

DatabaseException

See also

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

in Sqlite3 at line 84
__destruct()

Destructor

in Sqlite3 at line 96
close()

(non-PHPdoc)

See also

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

in Sqlite3 at line 106
query($query)

(non-PHPdoc)

Parameters

$query

See also

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

in Sqlite3 at line 124
fetchSingle($query)

Parameters

$query

in Sqlite3 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.

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

Sqlite Select

Parameters

string $query

Return Value

multitype:array |NULL

in Sqlite3 at line 177
protected boolean _exec(string $query)

Sqlite Update or Delete

Parameters

string $query

Return Value

boolean

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

Sqlite Insert

Parameters

string $query

Return Value

number|boolean

in Sqlite3 at line 202
exec(string $query)

Executes a result-less query against a given database

Parameters

string $query

in Sqlite3 at line 212
bool isConnected()

(non-PHPdoc)

Return Value

bool $this->_isConnected

See also

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

in Sqlite3 at line 222
setOptions(array $options = null)

Set Options

Parameters

array $options

in Sqlite3 at line 241
string escapeString($query)

(non-PHPdoc)

Parameters

$query

Return Value

string

See also

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

in Sqlite3 at line 246
getLastInsertRowId()

at line 31
static Sqlite3 getInstance()

Singleton

Return Value

Sqlite3

at line 43
check()