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 38
 __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 58
 void connect()

No description

Return Value

void

Exceptions

ConnectionException

at line 83
 void reconnect()

Disconnects and connects to database again.

Return Value

void

at line 93
 void disconnect()

Disconnects from database.

Return Value

void

at line 99
 string getDsn()

No description

Return Value

string

at line 105
 PDO getPdo()

No description

Return Value

PDO

at line 112
 Driver getDriver()

No description

Return Value

Driver

at line 120
 Driver getSupplementalDriver() deprecated

deprecated use getDriver()

No description

Return Value

Driver

at line 127
 Reflection getReflection()

No description

Return Value

Reflection

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

Sets callback for row preprocessing.

Parameters

callable|null $normalizer

Return Value

Connection

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

Returns last inserted ID.

Parameters

string|null $sequence

Return Value

string

at line 160
 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 174
 void beginTransaction()

Starts a transaction.

Return Value

void

Exceptions

LogicException

at line 188
 void commit()

Commits current transaction.

Return Value

void

Exceptions

LogicException

at line 202
 void rollBack()

Rolls back current transaction.

Return Value

void

Exceptions

LogicException

at line 215
 mixed transaction(callable $callback)

Executes callback inside a transaction.

Parameters

callable $callback

Return Value

mixed

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

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

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

deprecated use query()

No description

Parameters

string $sql
array $params

Return Value

ResultSet

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

No description

Parameters

string $sql
...$params

Return Value

array

at line 281
 string|null getLastQueryString()

No description

Return Value

string|null

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

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

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

Shortcut for query()->fetchAssoc()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

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

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchList()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

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

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

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

Creates SQL literal value.

Parameters

string $value
...$params

Return Value

SqlLiteral