Class DibiOdbcDriver

The dibi driver interacting with databases via ODBC connections.

Driver options: - dsn => driver specific DSN - username (or user) - password (or pass) - persistent (bool) => try to find a persistent link? - resource (resource) => existing connection resource - lazy, profiler, result, substitutes, ... => see DibiConnection options

DibiObject

DibiOdbcDriver implements IDibiDriver, IDibiResultDriver, IDibiReflector

Package: dibi\drivers
Author: David Grudl
Located at drivers/odbc.php

Methods summary
`public`	# `__construct( )` Throws `DibiNotSupportedException`
`public`	# `connect( array & $config )` Connects to a database. Connects to a database. Parameters `$config` `array` Throws `DibiException` Implementation of `IDibiDriver::connect`
`public`	# `disconnect( )` Disconnects from a database. Disconnects from a database. Throws `DibiException` Implementation of `IDibiDriver::disconnect`
`public IDibiResultDriver\|null`	# `query( string $sql )` Executes the SQL query. Executes the SQL query. Parameters `$sql` `string` SQL statement. Returns `IDibiResultDriver\|null` Throws `DibiDriverException` Implementation of `IDibiDriver::query`
`public integer\|false`	# `getAffectedRows( )` Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Gets the number of affected rows by the last INSERT, UPDATE or DELETE query. Returns `integer\|false` number of rows or FALSE on error Implementation of `IDibiDriver::getAffectedRows`
`public integer\|false`	# `getInsertId( $sequence )` Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query. Returns `integer\|false` int on success or FALSE on failure Implementation of `IDibiDriver::getInsertId`
`public`	# `begin( string $savepoint = NULL )` Begins a transaction (if supported). Begins a transaction (if supported). Parameters `$savepoint` `string` optional savepoint name Throws `DibiDriverException` Implementation of `IDibiDriver::begin`
`public`	# `commit( string $savepoint = NULL )` Commits statements in a transaction. Commits statements in a transaction. Parameters `$savepoint` `string` optional savepoint name Throws `DibiDriverException` Implementation of `IDibiDriver::commit`
`public`	# `rollback( string $savepoint = NULL )` Rollback changes in a transaction. Rollback changes in a transaction. Parameters `$savepoint` `string` optional savepoint name Throws `DibiDriverException` Implementation of `IDibiDriver::rollback`
`public boolean`	# `inTransaction( )` Is in transaction? Is in transaction? Returns `boolean`
`public mixed`	# `getResource( )` Returns the connection resource. Returns the connection resource. Returns `mixed` Implementation of `IDibiDriver::getResource`
`public IDibiReflector`	# `getReflector( )` Returns the connection reflector. Returns the connection reflector. Returns `IDibiReflector` Implementation of `IDibiDriver::getReflector`
`public IDibiResultDriver`	# `createResultDriver( resource $resource )` Result set driver factory. Result set driver factory. Parameters `$resource` `resource` Returns `IDibiResultDriver`
`public string`	# `escape( mixed $value, string $type )` Encodes data for use in a SQL statement. Encodes data for use in a SQL statement. Parameters `$value` `mixed` value `$type` `string` type (dibi::TEXT, dibi::BOOL, ...) Returns `string` encoded value Throws `InvalidArgumentException` Implementation of `IDibiDriver::escape`
`public string`	# `escapeLike( string $value, integer $pos )` Encodes string for use in a LIKE statement. Encodes string for use in a LIKE statement. Parameters `$value` `string` `$pos` `integer` Returns `string` Implementation of `IDibiDriver::escapeLike`
`public string`	# `unescape( string $value, string $type )` Decodes data from result set. Decodes data from result set. Parameters `$value` `string` value `$type` `string` type (dibi::BINARY) Returns `string` decoded value Throws `InvalidArgumentException` Implementation of `IDibiResultDriver::unescape`
`public`	# `applyLimit( string & $sql, integer $limit, integer $offset )` Injects LIMIT/OFFSET to the SQL query. Injects LIMIT/OFFSET to the SQL query. Parameters `$sql` `string` &$sql The SQL query that will be modified. `$limit` `integer` `$offset` `integer` Implementation of `IDibiDriver::applyLimit`
`public`	# `__destruct( )` Automatically frees the resources allocated for this result set. Automatically frees the resources allocated for this result set.
`public integer`	# `getRowCount( )` Returns the number of rows in a result set. Returns the number of rows in a result set. Returns `integer` Implementation of `IDibiResultDriver::getRowCount`
`public array`	# `fetch( boolean $assoc )` Fetches the row at current position and moves the internal cursor to the next position. Fetches the row at current position and moves the internal cursor to the next position. Parameters `$assoc` `boolean` TRUE for associative array, FALSE for numeric Returns `array` array on success, nonarray if no next record
`public boolean`	# `seek( integer $row )` Moves cursor position without fetching row. Moves cursor position without fetching row. Parameters `$row` `integer` the 0-based cursor pos to seek to Returns `boolean` TRUE on success, FALSE if unable to seek to specified record Throws `DibiException` Implementation of `IDibiResultDriver::seek`
`public`	# `free( )` Frees the resources allocated for this result set. Frees the resources allocated for this result set. Implementation of `IDibiResultDriver::free`
`public array`	# `getResultColumns( )` Returns metadata for all columns in a result set. Returns metadata for all columns in a result set. Returns `array` Implementation of `IDibiResultDriver::getResultColumns`
`public mixed`	# `getResultResource( )` Returns the result set resource. Returns the result set resource. Returns `mixed` Implementation of `IDibiResultDriver::getResultResource`
`public array`	# `getTables( )` Returns list of tables. Returns list of tables. Returns `array` Implementation of `IDibiReflector::getTables`
`public array`	# `getColumns( string $table )` Returns metadata for all columns in a table. Returns metadata for all columns in a table. Parameters `$table` `string` Returns `array` Implementation of `IDibiReflector::getColumns`
`public array`	# `getIndexes( string $table )` Returns metadata for all indexes in a table. Returns metadata for all indexes in a table. Parameters `$table` `string` Returns `array` Implementation of `IDibiReflector::getIndexes`
`public array`	# `getForeignKeys( string $table )` Returns metadata for all foreign keys in a table. Returns metadata for all foreign keys in a table. Parameters `$table` `string` Returns `array` Implementation of `IDibiReflector::getForeignKeys`

Methods inherited from DibiObject
`__call(), __callStatic(), __get(), __isset(), __set(), __unset(), extensionMethod(), getClass(), getReflection()`

Packages

Classes

Exceptions

Class DibiOdbcDriver

Throws

Parameters

Throws

Implementation of

Throws

Implementation of

Parameters

Returns

Throws

Implementation of

Returns

Implementation of

Returns

Implementation of

Parameters

Throws

Implementation of

Parameters

Throws

Implementation of

Parameters

Throws

Implementation of

Returns

Returns

Implementation of

Returns

Implementation of

Parameters

Returns

Parameters

Returns

Throws

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Throws

Implementation of

Parameters

Implementation of

Returns

Implementation of

Parameters

Returns

Parameters

Returns

Throws

Implementation of

Implementation of

Returns

Implementation of

Returns

Implementation of

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of