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

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

PDO
getPdo()

No description

Driver
getDriver()

No description

Driver
getSupplementalDriver() deprecated

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

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

Generates and executes SQL query.

ResultSet
queryArgs(string $sql, array $params)

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)

Parameters

string $dsn
string $user
string $password
array $options

at line 60
void connect()

Return Value

void

at line 83
void reconnect()

Return Value

void

at line 90
void disconnect()

Return Value

void

at line 96
string getDsn()

Return Value

string

at line 102
PDO getPdo()

Return Value

PDO

at line 109
Driver getDriver()

Return Value

Driver

at line 117
Driver getSupplementalDriver() deprecated

deprecated use getDriver()

Return Value

Driver

at line 124
string getInsertId(string $sequence = null)

Parameters

string $sequence

Return Value

string

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

Parameters

string $string
int $type

Return Value

string

at line 145
void beginTransaction()

Return Value

void

at line 151
void commit()

Return Value

void

at line 157
void rollBack()

Return Value

void

at line 166
mixed transaction(callable $callback)

Parameters

callable $callback

Return Value

mixed

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

Generates and executes SQL query.

Parameters

string $sql
...$params

Return Value

ResultSet

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

Parameters

string $sql
array $params

Return Value

ResultSet

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

Parameters

string $sql
...$params

Return Value

array [string, array]

at line 215
string|null getLastQueryString()

Return Value

string|null

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

Shortcut for query()->fetch()

Parameters

string $sql
...$params

Return Value

Row|null

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

Shortcut for query()->fetchField()

Parameters

string $sql
...$params

Return Value

mixed

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

Shortcut for query()->fetchFields()

Parameters

string $sql
...$params

Return Value

array|null

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

Shortcut for query()->fetchPairs()

Parameters

string $sql
...$params

Return Value

array

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

Shortcut for query()->fetchAll()

Parameters

string $sql
...$params

Return Value

array

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

Parameters

string $value
...$params

Return Value

SqlLiteral

Traits

SmartObject
Strict class for better experience.