Class Connection
SQLite Database Connection implementation.
-
ManiaLive\Database\Connection
-
ManiaLive\Database\SQLite\Connection
Methods summary
public
|
#
__construct( mixed $host, mixed $username, mixed $password, mixed $database, mixed $port )
|
public
resource
|
#
getHandle( )
Return the current Connection Link
Return the current Connection Link
Returns
resource
|
public
|
#
setCharset( string $charset )
Set the charset used to communicate with the database
Set the charset used to communicate with the database
Parameters
|
public
boolean
|
#
isConnected( )
Return true if the connection to the database is open, false in the other
cases
Return true if the connection to the database is open, false in the other
cases
Returns
boolean
|
public
string
|
#
getDatabase( )
Get the selected database
Get the selected database
Returns
string
|
public
integer
|
#
affectedRows( )
Return the number of rows affected by the previous query
Return the number of rows affected by the previous query
Returns
integer
|
public
integer
|
#
insertID( )
Return the id of the last insert query
Return the id of the last insert query
Returns
integer
|
public
ManiaLive\Database\RecordSet
|
#
execute( string $query )
Execute a query and return the result
Execute a query and return the result
Parameters
Returns
|
public
|
#
disconnect( )
Close the current connection to the database
Close the current connection to the database
|
public
string
|
#
quote( string $string )
Escape and add quotes around the given string
Escape and add quotes around the given string
Parameters
Returns
string
|
public
|
#
select( string $database )
select the given database
select the given database
Parameters
- $database
string $database
|
public
boolean
|
#
tableExists( string $tableName )
Check if the given table exists
Check if the given table exists
Parameters
Returns
boolean
|