Sqlite3
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)
at line 84
__destruct()
Destructor
at line 96
close()
(non-PHPdoc)
at line 106
query($query)
(non-PHPdoc)
at line 124
fetchSingle($query)
at line 135
SQLite3Stmt|boolean
prepare(string $query)
Prepares an SQL statement for execution
at line 146
multitype:array
fetch(string $query)
Sqlite Select
at line 177
protected boolean
_exec(string $query)
Sqlite Update or Delete
at line 188
number|boolean
insert(string $query)
Sqlite Insert
at line 202
exec(string $query)
Executes a result-less query against a given database
at line 212
bool
isConnected()
(non-PHPdoc)
at line 222
setOptions(array $options = null)
Set Options
at line 241
string
escapeString($query)
(non-PHPdoc)