Namespaces

  • Latte
    • Loaders
    • Macros
    • Runtime
  • Nette
    • Application
      • Responses
      • Routers
      • UI
    • Bridges
      • ApplicationLatte
      • ApplicationTracy
      • CacheLatte
      • DatabaseDI
      • DatabaseTracy
      • DITracy
      • FormsLatte
      • Framework
      • HttpTracy
      • SecurityTracy
    • Caching
      • Storages
    • ComponentModel
    • Database
      • 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

Classes

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

Interfaces

  • IReflection
  • IRow
  • IRowContainer
  • ISupplementalDriver
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated
  • Other releases
  • Nette homepage

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 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 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 array $onConnect
#

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

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

public array $onQuery
#

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

of function (Connection $connection, ResultSet|Exception $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.2 API documentation generated by ApiGen 2.8.0