class SQLAnywhereConnection implements Connection, ServerInfoAwareConnection (View source)

SAP Sybase SQL Anywhere implementation of the Connection interface.

Methods

__construct(string $dsn, boolean $persistent = false)

Constructor.

boolean
beginTransaction()

Initiates a transaction.

boolean
commit()

Commits a transaction.

string|null
errorCode()

Returns the error code associated with the last operation on the database handle.

array
errorInfo()

Returns extended error information associated with the last operation on the database handle.

integer
exec(string $statement)

Executes an SQL statement and return the number of affected rows.

string
getServerVersion()

Returns the version number of the database server connected to.

string
lastInsertId(string|null $name = null)

Returns the ID of the last inserted row or sequence value.

prepare(string $prepareString)

Prepares a statement for execution and returns a Statement object.

query()

Executes an SQL statement, returning a result set as a Statement object.

string
quote(string $input, integer $type = \PDO::PARAM_STR)

Quotes a string for use in a query.

boolean
requiresQueryForServerVersion()

Checks whether a query is required to retrieve the database server version.

boolean
rollBack()

Rolls back the current transaction, as initiated by beginTransaction().

Details

__construct(string $dsn, boolean $persistent = false)

Constructor.

Connects to database with given connection string.

Parameters

string $dsn The connection string.
boolean $persistent Whether or not to establish a persistent connection.

Exceptions

SQLAnywhereException

boolean beginTransaction()

Initiates a transaction.

Return Value

boolean TRUE on success or FALSE on failure.

boolean commit()

Commits a transaction.

Return Value

boolean TRUE on success or FALSE on failure.

string|null errorCode()

Returns the error code associated with the last operation on the database handle.

Return Value

string|null The error code, or null if no operation has been run on the database handle.

array errorInfo()

Returns extended error information associated with the last operation on the database handle.

Return Value

array

integer exec(string $statement)

Executes an SQL statement and return the number of affected rows.

Parameters

string $statement

Return Value

integer

string getServerVersion()

Returns the version number of the database server connected to.

Return Value

string

string lastInsertId(string|null $name = null)

Returns the ID of the last inserted row or sequence value.

Parameters

string|null $name

Return Value

string

Statement prepare(string $prepareString)

Prepares a statement for execution and returns a Statement object.

Parameters

string $prepareString

Return Value

Statement

Statement query()

Executes an SQL statement, returning a result set as a Statement object.

Return Value

Statement

string quote(string $input, integer $type = \PDO::PARAM_STR)

Quotes a string for use in a query.

Parameters

string $input
integer $type

Return Value

string

boolean requiresQueryForServerVersion()

Checks whether a query is required to retrieve the database server version.

Return Value

boolean True if a query is required to retrieve the database server version, false otherwise.

boolean rollBack()

Rolls back the current transaction, as initiated by beginTransaction().

Return Value

boolean TRUE on success or FALSE on failure.