PHP Class Nette\Database\Connection

Inheritance: use trait Nette\SmartObject
Show file Open project: nette/database Class Usage Examples

Public Properties

Property Type Description
$onConnect function (Connection $connection); Occurs after connection is established
$onQuery function (Connection $connection, ResultSet|DriverException $result); Occurs after query is executed

Public Methods

Method Description
__construct ( $dsn, $user = NULL, $password = NULL, array $options = NULL )
beginTransaction ( ) : void
commit ( ) : void
connect ( ) : void
disconnect ( ) : void
fetch ( $sql, $params ) : Nette\Database\Row Shortcut for query()->fetch()
fetchAll ( $sql, $params ) : array Shortcut for query()->fetchAll()
fetchField ( $sql, $params ) : mixed Shortcut for query()->fetchField()
fetchPairs ( $sql, $params ) : array Shortcut for query()->fetchPairs()
getDsn ( ) : string
getInsertId ( $name = NULL ) : string
getPdo ( ) : PDO
getSupplementalDriver ( ) : Nette\Database\ISupplementalDriver
literal ( $value, $params ) : SqlLiteral
preprocess ( $sql, $params ) : [string,
query ( $sql, $params ) : ResultSet Generates and executes SQL query.
queryArgs ( $sql, array $params ) : ResultSet
quote ( $string, $type = PDO::PARAM_STR ) : string
reconnect ( ) : void
rollBack ( ) : void

Method Details

__construct() public method

public __construct ( $dsn, $user = NULL, $password = NULL, array $options = NULL )
$options array

beginTransaction() public method

public beginTransaction ( ) : void
return void

commit() public method

public commit ( ) : void
return void

connect() public method

public connect ( ) : void
return void

disconnect() public method

public disconnect ( ) : void
return void

fetch() public method

Shortcut for query()->fetch()
public fetch ( $sql, $params ) : Nette\Database\Row
return Nette\Database\Row

fetchAll() public method

Shortcut for query()->fetchAll()
public fetchAll ( $sql, $params ) : array
return array

fetchField() public method

Shortcut for query()->fetchField()
public fetchField ( $sql, $params ) : mixed
return mixed

fetchPairs() public method

Shortcut for query()->fetchPairs()
public fetchPairs ( $sql, $params ) : array
return array

getDsn() public method

public getDsn ( ) : string
return string

getInsertId() public method

public getInsertId ( $name = NULL ) : string
return string

getPdo() public method

public getPdo ( ) : PDO
return PDO

getSupplementalDriver() public method

public getSupplementalDriver ( ) : Nette\Database\ISupplementalDriver
return Nette\Database\ISupplementalDriver

literal() public static method

public static literal ( $value, $params ) : SqlLiteral
return SqlLiteral

preprocess() public method

public preprocess ( $sql, $params ) : [string,
return [string,

query() public method

Generates and executes SQL query.
public query ( $sql, $params ) : ResultSet
return ResultSet

queryArgs() public method

public queryArgs ( $sql, array $params ) : ResultSet
$params array
return ResultSet

quote() public method

public quote ( $string, $type = PDO::PARAM_STR ) : string
return string

reconnect() public method

public reconnect ( ) : void
return void

rollBack() public method

public rollBack ( ) : void
return void

Property Details

$onConnect public property

function (Connection $connection); Occurs after connection is established
public $onConnect

$onQuery public property

function (Connection $connection, ResultSet|DriverException $result); Occurs after query is executed
public $onQuery