sqlConnection

sqlConnection implements Connection

• Full name: \Gibbon\sqlConnection

• This class implements: Warning: strrchr() expects parameter 1 to be string, object given in /Users/sankuipe/Desktop/Localhost/documentor/src/Extension/TwigMarkdownAnchorLink.php on line 108

• Warning: this class is deprecated. This means that this class will likely be removed in a future version.

Methods

• __construct — Construct
• getConnection — Get connection. Required for backwards compatibilty in Gibbon.
• getSuccess — Get Connection Success
• getQuerySuccess — Get Query Success
• executeQuery — Execute Query
• selectOne — Run a select statement and return a single result.
• select — Run a select statement against the database.
• insert — Run an insert statement and return the last insert ID.
• update — Run an update statement against the database.
• delete — Run a delete statement against the database.
• statement — Execute an SQL statement and return the boolean result.
• affectingStatement — Run an SQL statement and get the number of rows affected.
• getResult — Get Result
• getVersion — Get Version
• getCollation — Get Collation
• installBypass — Install Bypass
• escIdentifier — Escape an SQL identifier such as a table or database name with backticks.

__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