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

Connection

class Connection

Represents a connection between PHP and a database server.

Properties

$onConnect
$onQuery

Methods

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

No description

void
connect()

No description

void
reconnect()

No description

void
disconnect()

No description

string
getDsn()

No description

PDO
getPdo()

No description

Driver
getDriver()

No description

Driver
getSupplementalDriver() deprecated

No description

Connection
setRowNormalizer(callable|null $normalizer)

No description

string
getInsertId(string|null $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

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()

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 57
 __construct(string $dsn, string|null $user = null, string|null $password = null, array|null $options = null)

No description

Parameters

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

at line 74
 void connect()

No description

Return Value

void

at line 97
 void reconnect()

No description

Return Value

void

at line 104
 void disconnect()

No description

Return Value

void

at line 110
 string getDsn()

No description

Return Value

string

at line 116
 PDO getPdo()

No description

Return Value

PDO

at line 123
 Driver getDriver()

No description

Return Value

Driver

at line 131
 Driver getSupplementalDriver() deprecated

deprecated use getDriver()

No description

Return Value

Driver

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

No description

Parameters

callable|null $normalizer

Return Value

Connection

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

No description

Parameters

string|null $sequence

Return Value

string

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

No description

Parameters

string $string
int $type

Return Value

string

at line 166
 void beginTransaction()

No description

Return Value

void

at line 176
 void commit()

No description

Return Value

void

at line 186
 void rollBack()

No description

Return Value

void

at line 199
 mixed transaction(callable $callback)

No description

Parameters

callable $callback

Return Value

mixed

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

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

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

deprecated use query()

No description

Parameters

string $sql
array $params

Return Value

ResultSet

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

No description

Parameters

string $sql
...$params

Return Value

array

at line 270
 string|null getLastQueryString()

No description

Return Value

string|null

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

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

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

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

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

Shortcut for query()->fetchFields()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

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

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

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

No description

Parameters

string $value
...$params

Return Value

SqlLiteral

Traits

SmartObject