\Pop\Db\AdapterSqlite

__construct()

__construct(array  $options = array()) 

Constructor

Instantiate the SQLite database connection object using SQLite3

Parameters

connect()

connect(array  $options = array()) : \Pop\Db\Adapter\Sqlite

Connect to the database

Parameters

Returns

setOptions()

setOptions(array  $options) : \Pop\Db\Adapter\Sqlite

Set database connection options

Parameters

Returns

getOptions()

getOptions() : array

Get database connection options

Returns

hasOptions()

hasOptions() : boolean

Has database connection options

Returns

beginTransaction()

beginTransaction() : \Pop\Db\Adapter\Sqlite

Begin a transaction

Returns

commit()

commit() : \Pop\Db\Adapter\Sqlite

Commit a transaction

Returns

rollback()

rollback() : \Pop\Db\Adapter\Sqlite

Rollback a transaction

Returns

query()

query(mixed  $sql) : \Pop\Db\Adapter\Sqlite

Execute a SQL query directly

Parameters

Returns

prepare()

prepare(mixed  $sql) : \Pop\Db\Adapter\Sqlite

Prepare a SQL query

Parameters

Returns

bindParams()

bindParams(array  $params) : \Pop\Db\Adapter\Sqlite

Bind parameters to a prepared SQL query

Parameters

Returns

execute()

execute() : \Pop\Db\Adapter\Sqlite

Execute a prepared SQL query

Returns

fetch()

fetch() : array

Fetch and return a row from the result

Returns

fetchAll()

fetchAll() : array

Fetch and return all rows from the result

Returns

createSql()

createSql() : \Pop\Db\Sql

Create SQL builder

Returns

createSchema()

createSchema() : \Pop\Db\Sql\Schema

Create Schema builder

Returns

isConnected()

isConnected() : boolean

Determine whether or not connected

Returns

getConnection()

getConnection() : mixed

Get the connection object/resource

Returns

hasStatement()

hasStatement() : boolean

Determine whether or not a statement resource exists

Returns

getStatement()

getStatement() : mixed

Get the statement object/resource

Returns

hasResult()

hasResult() : boolean

Determine whether or not a result resource exists

Returns

getResult()

getResult() : mixed

Get the result object/resource

Returns

listen()

listen(mixed  $listener, mixed  $params = null, \Pop\Db\Adapter\Profiler\Profiler  $profiler = null) : mixed

Add query listener to the adapter

Parameters

Returns

getListener()

getListener() : \Pop\Utils\CallableObject

Get query listener

Returns

setProfiler()

setProfiler(\Pop\Db\Adapter\Profiler\Profiler  $profiler) : \Pop\Db\Adapter\AbstractAdapter

Set query profiler

Parameters

Returns

getProfiler()

getProfiler() : \Pop\Db\Adapter\Profiler\Profiler

Get query profiler

Returns

clearProfiler()

clearProfiler() : \Pop\Db\Adapter\AbstractAdapter

Clear query profiler

Returns

hasError()

hasError() : boolean

Determine whether or not there is an error

Returns

setError()

setError(string  $error) : \Pop\Db\Adapter\AbstractAdapter

Set the error

Parameters

Returns

getError()

getError() : mixed

Get the error

Returns

throwError()

throwError(string  $error = null) : void

Throw a database error exception

Parameters

Throws

\Pop\Db\Adapter\Exception

clearError()

clearError() : \Pop\Db\Adapter\AbstractAdapter

Clear the error

Returns

disconnect()

disconnect() : void

Disconnect from the database

escape()

escape(string  $value) : string

Escape the value

Parameters

Returns

getLastId()

getLastId() : integer

Return the last ID of the last query

Returns

getNumberOfRows()

getNumberOfRows() : integer

Return the number of rows from the last query

Returns

getVersion()

getVersion() : string

Return the database version

Returns

getTables()

getTables() : array

Return the tables in the database

Returns

hasTable()

hasTable(string  $table) : boolean

Return if the database has a table

Parameters

Returns

dbFileExists()

dbFileExists() : boolean

Does the database file exist

Returns

bindParam()

bindParam(mixed  $param, mixed  $value, integer  $type = SQLITE3_BLOB) : \Pop\Db\Adapter\Sqlite

Bind a parameter for a prepared SQL query

Parameters

Returns

bindValue()

bindValue(mixed  $param, mixed  $value, integer  $type = SQLITE3_BLOB) : \Pop\Db\Adapter\Sqlite

Bind a value for a prepared SQL query

Parameters

Returns