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 50
__construct(string $dsn, string $user = null, string $password = null, array $options = null)
at line 61
void
connect()
at line 84
void
reconnect()
at line 91
void
disconnect()
at line 97
string
getDsn()
at line 103
PDO
getPdo()
at line 110
Driver
getDriver()
at line 118
Driver
getSupplementalDriver()
deprecated
deprecated
at line 125
string
getInsertId(string $sequence = null)
at line 136
string
quote(string $string, int $type = PDO::PARAM_STR)
at line 146
void
beginTransaction()
at line 152
void
commit()
at line 158
void
rollBack()
at line 167
mixed
transaction(callable $callback)
at line 184
ResultSet
query(string $sql, ...$params)
Generates and executes SQL query.
at line 198
ResultSet
queryArgs(string $sql, array $params)
at line 207
array
preprocess(string $sql, ...$params)
at line 216
string|null
getLastQueryString()
at line 228
Row|null
fetch(string $sql, ...$params)
Shortcut for query()->fetch()
at line 238
mixed
fetchField(string $sql, ...$params)
Shortcut for query()->fetchField()
at line 247
array|null
fetchFields(string $sql, ...$params)
Shortcut for query()->fetchFields()
at line 256
array
fetchPairs(string $sql, ...$params)
Shortcut for query()->fetchPairs()
at line 265
array
fetchAll(string $sql, ...$params)
Shortcut for query()->fetchAll()
at line 271
static SqlLiteral
literal(string $value, ...$params)
Traits
SmartObject