Source API for the «PorteDrivers_Sqlite3_Connection» class

Sqlite connection implementation

PHP magic methods

__construct

Construct the connection from a configuration array.

return
null
$config
array
__get

Retrieve connection properties.

Public methods

connect

Create a new connection object or resource with the databasse. Note, a new connection will only be create if it does not yet exist or if the configuration used to create the existing connection has changed since its creation. The method also deals with connection encoding.

exec

Mysql implementation of the "exec" method.

query

Mysql implementation of the "query" method.

prepare

Mysql implementation of the "prepare" method.

quote

Mysql implementation of the "quote" method.

lastInsertId

Mysql implementation of the "lastInsertId" method.

databaseCreate

Create a database of it does not already exists. This function does not check if the database already exists.

tableClear

Empty a table completely and reset its internal counter.

tableCreate

Create a table of it does not already exists. This function does not check if the table

already exists, in which case an error is thrown.
tableDrop

Drop a table of it exists.

tableDropColumn

This method is not yet documented.

tableExists

This method is not yet documented.

tableShowColumns

This method is not yet documented.

tableShowIndexes

This method is not yet documented.

supportUnsigned

This method is not yet documented.

filterColumnAlter

This method is not yet documented.

writeTable

This method is not yet documented.

makeColumnTypeInt

This method is not yet documented.

makeColumnTypeBoolean

This method is not yet documented.

makeColumnTypeDouble

This method is not yet documented.

makeColumnTypeFloat

This method is not yet documented.

file

Set or get the database file name.

If no argument is provided, it returns the host name.
If one argument is provided, it create a new connection with the provided host name, or throw an exception on failure.

return
string
Host name
getFile

Return the host name of the current connection.

setFile

Create a new connection with the provided file name, or throw an exception on failure

file_mode

Set or get the port of the database connection.

If no argument is provided, it returns the current port.
If one argument is provided, it create a new connection with the provided port or throw an exception on failure.

return
string
Port name
getFileMode

Return the port used by the current connection.

setFileMode

Create a new connection with the provided server port, or throw an exception on failure.

encoding

Set or get the current encoding use by the connection.

If no argument is provided, it returns the current encoding.
If one argument is provided, it set the provided encoding as the current encoding used by the connection.

return
string
Server name
getEncoding

Return the current encoding use by the connection.

setEncoding

Set the provided encoding as the current encoding used by the connection.