sqlConnection

sqlConnection implements Connection

Methods

__construct

Construct

sqlConnection::__construct( $message = null ): Object

Return Value: Object PDO Connection


getConnection

Get connection. Required for backwards compatibilty in Gibbon.

sqlConnection::getConnection( ): Object

Return Value: Object PDO COnnection


getSuccess

Get Connection Success

sqlConnection::getSuccess( ): Object

Return Value: Object PDO COnnection


getQuerySuccess

Get Query Success

sqlConnection::getQuerySuccess( ): Object

Return Value: Object PDO COnnection


executeQuery

Execute Query

sqlConnection::executeQuery( $data, string $query, $error = NULL ): Object

Return Value: Object PDO Result


selectOne

Run a select statement and return a single result.

sqlConnection::selectOne( string $query, array $bindings = array() ): mixed

Return Value: mixed


select

Run a select statement against the database.

sqlConnection::select( string $query, array $bindings = array() ): array

Return Value: array


insert

Run an insert statement and return the last insert ID.

sqlConnection::insert( string $query, array $bindings = array() ): integer

Return Value: integer


update

Run an update statement against the database.

sqlConnection::update( string $query, array $bindings = array() ): integer

Return Value: integer


delete

Run a delete statement against the database.

sqlConnection::delete( string $query, array $bindings = array() ): integer

Return Value: integer


statement

Execute an SQL statement and return the boolean result.

sqlConnection::statement( string $query, array $bindings = array() ): boolean

Return Value: boolean


affectingStatement

Run an SQL statement and get the number of rows affected.

sqlConnection::affectingStatement( string $query, array $bindings = array() ): integer

Return Value: integer


getResult

Get Result

sqlConnection::getResult( ): Object

Return Value: Object PDOStatement


getVersion

Get Version

sqlConnection::getVersion( ): string

Return Value: string Version


getCollation

Get Collation

sqlConnection::getCollation( ): string

Return Value: string Collation


installBypass

Install Bypass

sqlConnection::installBypass( $databaseServer, $databaseName, $databaseUsername, $databasePassword, $message = null ): Object

Return Value: Object PDO Connection


escIdentifier

Escape an SQL identifier such as a table or database name with backticks.

sqlConnection::escIdentifier( string $value ): string

Return Value: string