Packages

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

Classes

  • Connection
  • Row
  • SqlLiteral
  • SqlPreprocessor
  • Statement

Interfaces

  • ISupplementalDriver
  • Overview
  • Package
  • Class
  • Tree

Class Connection

Represents a connection between PHP and a database server.

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

Returns

ISupplementalDriver
public
# setCacheStorage( ICacheStorage $storage = NULL )
public
# getCache( )
public Statement
# query( string $statement )

Generates and executes SQL query.

Generates and executes SQL query.

Parameters

$statement
string
statement

Returns

Statement
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
public Statement
# queryArgs( string $statement, array $params )

Parameters

$statement
string
statement
$params
array

Returns

Statement
public Row
# fetch( string $args )

Shortcut for query()->fetch()

Shortcut for query()->fetch()

Parameters

$args
string
statement

Returns

Row
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 TableSelection
# table( string $table )

Creates selector for table.

Creates selector for table.

Parameters

$table
string

Returns

TableSelection
public integer
# loadFile( string $file )

Import SQL dump from file - extreme fast.

Import SQL dump from file - extreme fast.

Parameters

$file
string
filename

Returns

integer
count of commands
public static string
# highlightSql( string $sql )

Returns syntax highlighted SQL command.

Returns syntax highlighted SQL command.

Parameters

$sql
string

Returns

string
public ClassReflection
# getReflection( )

Returns

ClassReflection
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 DatabaseReflection $databaseReflection
#
public array $substitutions array()
#
public array $onQuery
#

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

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

Nette Framework 2.0beta1 (for PHP 5.2) API API documentation generated by ApiGen 2.3.0