Namespaces

  • Latte
    • Loaders
    • Macros
    • Runtime
  • Nette
    • Application
      • Responses
      • Routers
      • UI
    • Bridges
      • ApplicationDI
      • ApplicationLatte
      • ApplicationTracy
      • CacheDI
      • CacheLatte
      • DatabaseDI
      • DatabaseTracy
      • DITracy
      • FormsDI
      • FormsLatte
      • Framework
      • HttpDI
      • HttpTracy
      • MailDI
      • ReflectionDI
      • SecurityDI
      • SecurityTracy
    • Caching
      • Storages
    • ComponentModel
    • Database
      • Conventions
      • Drivers
      • Reflection
      • Table
    • DI
      • Config
        • Adapters
      • Extensions
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
    • Iterators
    • Latte
    • Loaders
    • Localization
    • Mail
    • Neon
    • PhpGenerator
    • Reflection
    • Security
    • Templating
    • Utils
  • NetteModule
  • none
  • Tracy
    • Bridges
      • Nette

Classes

  • Connection
  • Context
  • Helpers
  • ResultSet
  • Row
  • SqlLiteral
  • SqlPreprocessor
  • Structure

Interfaces

  • IConventions
  • IReflection
  • IRow
  • IRowContainer
  • IStructure
  • ISupplementalDriver

Exceptions

  • ConnectionException
  • ConstraintViolationException
  • DriverException
  • ForeignKeyConstraintViolationException
  • NotNullConstraintViolationException
  • UniqueConstraintViolationException
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated

Class Connection

Represents a connection between PHP and a database server.

Nette\Object
Extended by Nette\Database\Connection
Namespace: Nette\Database
Author: David Grudl
Located at Database/Connection.php
Methods summary
public
# __construct( $dsn, $user = NULL, $password = NULL, array $options = NULL )
public
# connect( )
public
# reconnect( )
public
# disconnect( )
public string
# getDsn( )

Returns

string
public PDO
# getPdo( )

Returns

PDO
public Nette\Database\ISupplementalDriver
# getSupplementalDriver( )

Returns

Nette\Database\ISupplementalDriver
public string
# getInsertId( string $name = NULL )

Parameters

$name
string
sequence object

Returns

string
public string
# quote( string $string, integer $type = Nette\Database\PDO::PARAM_STR )

Parameters

$string
string
string to be quoted
$type
integer
data type hint

Returns

string
public
# beginTransaction( )
public
# commit( )
public
# rollBack( )
public Nette\Database\ResultSet
# query( string $statement )

Generates and executes SQL query.

Generates and executes SQL query.

Parameters

$statement
string
statement

Returns

Nette\Database\ResultSet
public Nette\Database\ResultSet
# queryArgs( string $statement, array $params )

Parameters

$statement
string
statement
$params
array

Returns

Nette\Database\ResultSet
public [string,
# preprocess( $statement )

Returns

[string,
array]
public Nette\Database\Row
# fetch( string $args )

Shortcut for query()->fetch()

Shortcut for query()->fetch()

Parameters

$args
string
statement

Returns

Nette\Database\Row
public mixed
# fetchField( string $args )

Shortcut for query()->fetchField()

Shortcut for query()->fetchField()

Parameters

$args
string
statement

Returns

mixed
public array
# fetchPairs( string $args )

Shortcut for query()->fetchPairs()

Shortcut for query()->fetchPairs()

Parameters

$args
string
statement

Returns

array
public array
# fetchAll( string $args )

Shortcut for query()->fetchAll()

Shortcut for query()->fetchAll()

Parameters

$args
string
statement

Returns

array
public static Nette\Database\SqlLiteral
# literal( $value )

Returns

Nette\Database\SqlLiteral
Methods inherited from Nette\Object
__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getReflection()
Properties summary
public callable[] $onConnect
#

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

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

public callable[] $onQuery
#

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

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

Magic properties summary
public read-only Nette\Database\ISupplementalDriver $supplementalDriver
#
public read-only string $dsn
#
public read-only PDO $pdo
#
Magic properties inherited from Nette\Object
$reflection
Nette 2.3.1 API API documentation generated by ApiGen 2.8.0