Connection
class Connection
Represents a connection between PHP and a database server.
Properties
callable[]&(callable(Connection | $onConnect | ||
callable[]&(callable(Connection | $onQuery |
Methods
__construct(string $dsn, string $user = null, string $password = null, array $options = null)
No description
void
connect()
No description
void
reconnect()
No description
void
disconnect()
No description
string
getDsn()
No description
string
getInsertId(string $sequence = null)
No description
string
quote(string $string, int $type = PDO::PARAM_STR)
No description
void
beginTransaction()
No description
void
commit()
No description
void
rollBack()
No description
mixed
transaction(callable $callback)
No description
array
preprocess(string $sql, ...$params)
No description
string|null
getLastQueryString()
No description
Row|null
fetch(string $sql, ...$params)
Shortcut for query()->fetch()
mixed
fetchField(string $sql, ...$params)
Shortcut for query()->fetchField()
array|null
fetchFields(string $sql, ...$params)
Shortcut for query()->fetchFields()
array
fetchPairs(string $sql, ...$params)
Shortcut for query()->fetchPairs()
array
fetchAll(string $sql, ...$params)
Shortcut for query()->fetchAll()
static SqlLiteral
literal(string $value, ...$params)
No description
Details
at line 49
__construct(string $dsn, string $user = null, string $password = null, array $options = null)
at line 60
void
connect()
at line 83
void
reconnect()
at line 90
void
disconnect()
at line 96
string
getDsn()
at line 102
PDO
getPdo()
at line 109
Driver
getDriver()
at line 117
Driver
getSupplementalDriver()
deprecated
deprecated
at line 124
string
getInsertId(string $sequence = null)
at line 135
string
quote(string $string, int $type = PDO::PARAM_STR)
at line 145
void
beginTransaction()
at line 151
void
commit()
at line 157
void
rollBack()
at line 166
mixed
transaction(callable $callback)
at line 183
ResultSet
query(string $sql, ...$params)
Generates and executes SQL query.
at line 197
ResultSet
queryArgs(string $sql, array $params)
at line 206
array
preprocess(string $sql, ...$params)
at line 215
string|null
getLastQueryString()
at line 227
Row|null
fetch(string $sql, ...$params)
Shortcut for query()->fetch()
at line 237
mixed
fetchField(string $sql, ...$params)
Shortcut for query()->fetchField()
at line 246
array|null
fetchFields(string $sql, ...$params)
Shortcut for query()->fetchFields()
at line 255
array
fetchPairs(string $sql, ...$params)
Shortcut for query()->fetchPairs()
at line 264
array
fetchAll(string $sql, ...$params)
Shortcut for query()->fetchAll()
at line 270
static SqlLiteral
literal(string $value, ...$params)
Traits
Strict class for better experience.