Namespaces

  • Nette
    • Application
      • Diagnostics
      • Responses
      • Routers
      • UI
    • Caching
      • Storages
    • ComponentModel
    • Config
      • Adapters
      • Extensions
    • Database
      • Diagnostics
      • Drivers
      • Reflection
      • Table
    • DI
      • Diagnostics
    • Diagnostics
    • Forms
      • Controls
      • Rendering
    • Http
    • Iterators
    • Latte
      • Macros
    • Loaders
    • Localization
    • Mail
    • Reflection
    • Security
      • Diagnostics
    • Templating
    • Utils
      • PhpGenerator
  • NetteModule
  • none

Classes

  • Connection
  • Helpers
  • Row
  • SqlLiteral
  • SqlPreprocessor
  • Statement

Interfaces

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

Class Connection

Represents a connection between PHP and a database server.

PDO
Extended by Nette\Database\Connection
Namespace: Nette\Database
Author: David Grudl
Located at Database/Connection.php
Methods summary
public
# __construct( $dsn, $username = NULL, $password = NULL, array $options = NULL, $driverClass = NULL )

Overrides

PDO::__construct()
public
# getDsn( )
public Nette\Database\ISupplementalDriver
# getSupplementalDriver( )

Returns

Nette\Database\ISupplementalDriver
public Nette\Database\Connection
# setDatabaseReflection( Nette\Database\IReflection $databaseReflection )

Sets database reflection.

Sets database reflection.

Returns

Nette\Database\Connection
public Nette\Database\IReflection
# getDatabaseReflection( )

Returns

Nette\Database\IReflection
public Nette\Database\Connection
# setCacheStorage( Nette\Caching\IStorage $storage = NULL )

Sets cache storage engine.

Sets cache storage engine.

Returns

Nette\Database\Connection
public
# getCache( )
public Nette\Database\Statement
# query( string $statement )

Generates and executes SQL query.

Generates and executes SQL query.

Parameters

$statement
string
statement

Returns

Nette\Database\Statement

Overrides

PDO::query()
public integer
# exec( string $statement )

Generates and executes SQL query.

Generates and executes SQL query.

Parameters

$statement
string
statement

Returns

integer
number of affected rows

Overrides

PDO::exec()
public Nette\Database\Statement
# queryArgs( string $statement, array $params )

Parameters

$statement
string
statement
$params
array

Returns

Nette\Database\Statement
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 mixed
# fetchColumn( string $args )

Shortcut for query()->fetchColumn()

Shortcut for query()->fetchColumn()

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 Nette\Database\Table\Selection
# table( string $table )

Creates selector for table.

Creates selector for table.

Parameters

$table
string

Returns

Nette\Database\Table\Selection
public static Nette\Reflection\ClassType
# getReflection( )

Returns

Nette\Reflection\ClassType
public
# __call( $name, $args )
public &
# __get( $name )
public
# __set( $name, $value )
public
# __isset( $name )
public
# __unset( $name )
Methods inherited from PDO
__sleep(), __wakeup(), beginTransaction(), commit(), errorCode(), errorInfo(), getAttribute(), getAvailableDrivers(), inTransaction(), lastInsertId(), prepare(), quote(), rollBack(), setAttribute()
Constants inherited from PDO
ATTR_AUTOCOMMIT, ATTR_CASE, ATTR_CLIENT_VERSION, ATTR_CONNECTION_STATUS, ATTR_CURSOR, ATTR_CURSOR_NAME, ATTR_DEFAULT_FETCH_MODE, ATTR_DRIVER_NAME, ATTR_EMULATE_PREPARES, ATTR_ERRMODE, ATTR_FETCH_CATALOG_NAMES, ATTR_FETCH_TABLE_NAMES, ATTR_MAX_COLUMN_LEN, ATTR_ORACLE_NULLS, ATTR_PERSISTENT, ATTR_PREFETCH, ATTR_SERVER_INFO, ATTR_SERVER_VERSION, ATTR_STATEMENT_CLASS, ATTR_STRINGIFY_FETCHES, ATTR_TIMEOUT, CASE_LOWER, CASE_NATURAL, CASE_UPPER, CURSOR_FWDONLY, CURSOR_SCROLL, ERRMODE_EXCEPTION, ERRMODE_SILENT, ERRMODE_WARNING, ERR_NONE, FETCH_ASSOC, FETCH_BOTH, FETCH_BOUND, FETCH_CLASS, FETCH_CLASSTYPE, FETCH_COLUMN, FETCH_FUNC, FETCH_GROUP, FETCH_INTO, FETCH_KEY_PAIR, FETCH_LAZY, FETCH_NAMED, FETCH_NUM, FETCH_OBJ, FETCH_ORI_ABS, FETCH_ORI_FIRST, FETCH_ORI_LAST, FETCH_ORI_NEXT, FETCH_ORI_PRIOR, FETCH_ORI_REL, FETCH_PROPS_LATE, FETCH_SERIALIZE, FETCH_UNIQUE, NULL_EMPTY_STRING, NULL_NATURAL, NULL_TO_STRING, PARAM_BOOL, PARAM_EVT_ALLOC, PARAM_EVT_EXEC_POST, PARAM_EVT_EXEC_PRE, PARAM_EVT_FETCH_POST, PARAM_EVT_FETCH_PRE, PARAM_EVT_FREE, PARAM_EVT_NORMALIZE, PARAM_INPUT_OUTPUT, PARAM_INT, PARAM_LOB, PARAM_NULL, PARAM_STMT, PARAM_STR
Properties summary
public array $onQuery
#

of function(Statement $result, $params); Occurs after query is executed

of function(Statement $result, $params); Occurs after query is executed

Magic properties summary
public Nette\Database\IReflection $databaseReflection
#
public read-only Nette\Database\ISupplementalDriver $supplementalDriver
#
public read-only string $dsn
#
Nette 2.0 API documentation generated by ApiGen 2.8.0