Connection
interface Connection
Provides methods for executing queries and managing transactions.
Instances are created by a Driver.
Methods
Executes an SQL query with optional parameters and returns a result set.
Executes an SQL command and returns the number of affected rows.
Returns the underlying database connection object.
Starts a new database transaction.
Commits the current database transaction.
Rolls back the current database transaction.
Returns the ID of the last inserted row or sequence value.
Quotes a string for use in an SQL statement.
Returns the version of the database server.
Details
at line 20
Result
query(string $sql, array $params = [])
Executes an SQL query with optional parameters and returns a result set.
at line 23
int
execute(string $sql)
Executes an SQL command and returns the number of affected rows.
at line 26
mixed
getNativeConnection()
Returns the underlying database connection object.
at line 29
void
beginTransaction()
Starts a new database transaction.
at line 32
void
commit()
Commits the current database transaction.
at line 35
void
rollBack()
Rolls back the current database transaction.
at line 38
int|string
getInsertId(string|null $sequence = null)
Returns the ID of the last inserted row or sequence value.
at line 41
string
quote(string $string)
Quotes a string for use in an SQL statement.
at line 44
string
getServerVersion()
Returns the version of the database server.