1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. Connection

Connection

class Connection

Manages database connection and executes SQL queries.

Properties

$onConnect
$onQuery

Methods

__construct(string $dsn, string|null $user = null, string|null $password = null, array $options = [])

No description

void
connect()

No description

void
reconnect()

Disconnects and connects to database again.

void
disconnect()

Disconnects from database.

string
getDsn()

No description

PDO
getPdo()

No description

Driver
getDriver()

No description

Driver
getSupplementalDriver() deprecated

No description

Reflection
getReflection()

No description

Connection
setRowNormalizer(callable|null $normalizer)

Sets callback for row preprocessing.

string
getInsertId(string|null $sequence = null)

Returns last inserted ID.

string
quote(string $string, int $type = PDO::PARAM_STR)

Quotes string for use in SQL.

void
beginTransaction()

Starts a transaction.

void
commit()

Commits current transaction.

void
rollBack()

Rolls back current transaction.

mixed
transaction(callable $callback)

Executes callback inside a transaction.

ResultSet
query(string $sql, ...$params)

Generates and executes SQL query.

ResultSet
queryArgs(string $sql, array $params) deprecated

No description

array
preprocess(string $sql, ...$params)

No description

string|null
getLastQueryString()

No description

Row|null
fetch(string $sql, ...$params)

Shortcut for query()->fetch()

array|null
fetchAssoc(string $sql, ...$params)

Shortcut for query()->fetchAssoc()

mixed
fetchField(string $sql, ...$params)

Shortcut for query()->fetchField()

array|null
fetchList(string $sql, ...$params)

Shortcut for query()->fetchList()

array|null
fetchFields(string $sql, ...$params)

Shortcut for query()->fetchList()

array
fetchPairs(string $sql, ...$params)

Shortcut for query()->fetchPairs()

array
fetchAll(string $sql, ...$params)

Shortcut for query()->fetchAll()

static SqlLiteral
literal(string $value, ...$params)

Creates SQL literal value.

Details

at line 39
__construct(string $dsn, string|null $user = null, string|null $password = null, array $options = [])

No description

Parameters

string $dsn
string|null $user
string|null $password
array $options

at line 59
void connect()

No description

Return Value

void

Exceptions

ConnectionException

at line 84
void reconnect()

Disconnects and connects to database again.

Return Value

void

at line 94
void disconnect()

Disconnects from database.

Return Value

void

at line 100
string getDsn()

No description

Return Value

string

at line 106
PDO getPdo()

No description

Return Value

PDO

at line 113
Driver getDriver()

No description

Return Value

Driver

at line 121
Driver getSupplementalDriver() deprecated

deprecated use getDriver()

No description

Return Value

Driver

at line 128
Reflection getReflection()

No description

Return Value

Reflection

at line 137
Connection setRowNormalizer(callable|null $normalizer)

Sets callback for row preprocessing.

Parameters

callable|null $normalizer

Return Value

Connection

at line 147
string getInsertId(string|null $sequence = null)

Returns last inserted ID.

Parameters

string|null $sequence

Return Value

string

at line 161
string quote(string $string, int $type = PDO::PARAM_STR)

Quotes string for use in SQL.

Parameters

string $string
int $type

Return Value

string

at line 175
void beginTransaction()

Starts a transaction.

Return Value

void

Exceptions

LogicException

at line 189
void commit()

Commits current transaction.

Return Value

void

Exceptions

LogicException

at line 203
void rollBack()

Rolls back current transaction.

Return Value

void

Exceptions

LogicException

at line 216
mixed transaction(callable $callback)

Executes callback inside a transaction.

Parameters

callable $callback

Return Value

mixed

at line 247
ResultSet query(string $sql, ...$params)

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

at line 263
ResultSet queryArgs(string $sql, array $params) deprecated

deprecated use query()

No description

Parameters

string $sql
array $params

Return Value

ResultSet

at line 273
array preprocess(string $sql, ...$params)

No description

Parameters

string $sql
...$params

Return Value

array

at line 282
string|null getLastQueryString()

No description

Return Value

string|null

at line 295
Row|null fetch(string $sql, ...$params)

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

at line 305
array|null fetchAssoc(string $sql, ...$params)

Shortcut for query()->fetchAssoc()

Parameters

string $sql
...$params

Return Value

array|null

at line 315
mixed fetchField(string $sql, ...$params)

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

at line 325
array|null fetchList(string $sql, ...$params)

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

at line 335
array|null fetchFields(string $sql, ...$params)

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

at line 345
array fetchPairs(string $sql, ...$params)

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

at line 355
array fetchAll(string $sql, ...$params)

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

at line 364
static SqlLiteral literal(string $value, ...$params)

Creates SQL literal value.

Parameters

string $value
...$params

Return Value

SqlLiteral