Db/Statement/Pdo/Oci.php
LICENSE
This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to license@zend.com so we can send you a copy immediately.
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
- Package
- Zend_Db
- Subpackage
- Statement
- Version
- $Id: Oci.php 24593 2012-01-05 20:35:02Z matthew $
\Zend_Db_Statement_Pdo_Oci
Matches the interface of PDOStatement. All methods simply proxy to the matching method in PDOStatement. PDOExceptions thrown by PDOStatement are re-thrown as Zend_Db_Statement_Exception.
- Parent(s)
- \Zend_Db_Statement_Pdo < \Zend_Db_Statement
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
Properties


\Zend_Db_Adapter_Abstract $_adapter = null
null
Details- Type
- \Zend_Db_Adapter_Abstract
- Inherited_from
- \Zend_Db_Statement::$$_adapter
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_adapter


array $_attribute = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_attribute
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_attribute


array $_bindColumn = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_bindColumn
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_bindColumn


array $_bindParam = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_bindParam
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_bindParam


int $_fetchMode = \PDO::FETCH_ASSOC
\PDO::FETCH_ASSOC
Details- Type
- int
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_fetchMode


\Zend_Db_Profiler_Query $_queryId = null
null
Details- Type
- \Zend_Db_Profiler_Query
- Inherited_from
- \Zend_Db_Statement::$$_queryId
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_queryId


array $_sqlParam = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_sqlParam
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_sqlParam


array $_sqlSplit = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_sqlSplit
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_sqlSplit


resource|object $_stmt = null
The driver level statement object/resource
null
Details- Type
- resource | object
- Inherited_from
- \Zend_Db_Statement::$$_stmt
- Inherited_from
- \Zend_Db_Statement_Pdo::$$_stmt
Methods


__construct(\Zend_Db_Adapter_Abstract $adapter, mixed $sql) : void
Constructor for a statement.
Inherited from: \Zend_Db_Statement::__construct()\Zend_Db_Statement_Pdo::__construct()Name | Type | Description |
---|---|---|
$adapter | \Zend_Db_Adapter_Abstract | |
$sql | mixed | Either a string or Zend_Db_Select. |


_bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
Binds a parameter to the specified variable name.
Inherited from: \Zend_Db_Statement_Pdo::_bindParam()Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$variable | mixed | Reference to PHP variable containing the value. |
$type | mixed | OPTIONAL Datatype of SQL parameter. |
$length | mixed | OPTIONAL Length of SQL parameter. |
$options | mixed | OPTIONAL Other options. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


_execute(array $params = null) : bool
Name | Type | Description |
---|---|---|
$params | array | OPTIONAL Values to bind to parameter placeholders. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


_fetchBound(array $row) : bool
Helper function to map retrieved row to bound column variables
Inherited from: \Zend_Db_Statement::_fetchBound()\Zend_Db_Statement_Pdo::_fetchBound()Name | Type | Description |
---|---|---|
$row | array |
Type | Description |
---|---|
bool | True |


_parseParameters(string $sql) : void
Name | Type | Description |
---|---|---|
$sql | string |


_prepare(string $sql) : void
Prepare a string SQL statement and create a statement object.
Inherited from: \Zend_Db_Statement_Pdo::_prepare()Name | Type | Description |
---|---|---|
$sql | string |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


_stripQuoted(string $sql) : string
Remove parts of a SQL string that contain quoted strings of values or identifiers.
Inherited from: \Zend_Db_Statement::_stripQuoted()\Zend_Db_Statement_Pdo::_stripQuoted()Name | Type | Description |
---|---|---|
$sql | string |
Type | Description |
---|---|
string |


bindColumn(string $column, mixed $param, mixed $type = null) : bool
Bind a column of the statement result set to a PHP variable.
Inherited from: \Zend_Db_Statement_Pdo::bindColumn()Name | Type | Description |
---|---|---|
$column | string | Name the column in the result set, either by position or by name. |
$param | mixed | Reference to the PHP variable containing the value. |
$type | mixed | OPTIONAL |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
Binds a parameter to the specified variable name.
Inherited from: \Zend_Db_Statement::bindParam()\Zend_Db_Statement_Pdo::bindParam()Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$variable | mixed | Reference to PHP variable containing the value. |
$type | mixed | OPTIONAL Datatype of SQL parameter. |
$length | mixed | OPTIONAL Length of SQL parameter. |
$options | mixed | OPTIONAL Other options. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


bindValue(mixed $parameter, mixed $value, mixed $type = null) : bool
Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$value | mixed | Scalar value to bind to the parameter. |
$type | mixed | OPTIONAL Datatype of the parameter. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


closeCursor() : bool
Closes the cursor, allowing the statement to be executed again.
Inherited from: \Zend_Db_Statement_Pdo::closeCursor()Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


columnCount() : int
Returns the number of columns in the result set.
Inherited from: \Zend_Db_Statement_Pdo::columnCount()Returns null if the statement has no result set metadata.
Type | Description |
---|---|
int | The number of columns. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


errorCode() : string
Retrieves the error code, if any, associated with the last operation on the statement handle.
Inherited from: \Zend_Db_Statement_Pdo::errorCode()Type | Description |
---|---|
string | error code. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


errorInfo() : array
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Inherited from: \Zend_Db_Statement_Pdo::errorInfo()Type | Description |
---|---|
array |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


execute(array $params = null) : bool
Executes a prepared statement.
Inherited from: \Zend_Db_Statement::execute()\Zend_Db_Statement_Pdo::execute()Name | Type | Description |
---|---|---|
$params | array | OPTIONAL Values to bind to parameter placeholders. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetch(int $style = null, int $cursor = null, int $offset = null) : mixed
Fetches a row from the result set.
Name | Type | Description |
---|---|---|
$style | int | OPTIONAL Fetch mode for this fetch operation. |
$cursor | int | OPTIONAL Absolute, relative, or other. |
$offset | int | OPTIONAL Number for absolute or relative cursors. |
Type | Description |
---|---|
mixed | Array, object, or scalar depending on fetch mode. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetchAll(int $style = null, int $col = null) : array
Returns an array containing all of the result set rows.
Behaves like parent, but if limit() is used, the final result removes the extra column 'zend_db_rownum'
Name | Type | Description |
---|---|---|
$style | int | OPTIONAL Fetch mode. |
$col | int | OPTIONAL Column number, if fetch mode is by column. |
Type | Description |
---|---|
array | Collection of rows, each in a format by the fetch mode. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetchColumn(int $col = 0) : string
Returns a single column from the next row of a result set.
Inherited from: \Zend_Db_Statement_Pdo::fetchColumn()Name | Type | Description |
---|---|---|
$col | int | OPTIONAL Position of the column to fetch. |
Type | Description |
---|---|
string |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetchObject(string $class = 'stdClass', array $config = array()) : mixed
Fetches the next row and returns it as an object.
Inherited from: \Zend_Db_Statement_Pdo::fetchObject()Name | Type | Description |
---|---|---|
$class | string | OPTIONAL Name of the class to create. |
$config | array | OPTIONAL Constructor arguments for the class. |
Type | Description |
---|---|
mixed | One object instance of the specified class. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


getAdapter() : \Zend_Db_Adapter_Abstract
Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Statement object.
Inherited from: \Zend_Db_Statement::getAdapter()\Zend_Db_Statement_Pdo::getAdapter()Type | Description |
---|---|
\Zend_Db_Adapter_Abstract |


getAttribute(integer $key) : mixed
Name | Type | Description |
---|---|---|
$key | integer | Attribute name. |
Type | Description |
---|---|
mixed | Attribute value. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


getColumnMeta(int $column) : mixed
Returns metadata for a column in a result set.
Inherited from: \Zend_Db_Statement_Pdo::getColumnMeta()Name | Type | Description |
---|---|---|
$column | int |
Type | Description |
---|---|
mixed |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


getDriverStatement() : \unknown_type
Gets the resource or object setup by the _parse
Inherited from: \Zend_Db_Statement::getDriverStatement()\Zend_Db_Statement_Pdo::getDriverStatement()Type | Description |
---|---|
\unknown_type |


getIterator() : \IteratorIterator
Required by IteratorAggregate interface
Inherited from: \Zend_Db_Statement_Pdo::getIterator()Type | Description |
---|---|
\IteratorIterator |


nextRowset() : bool
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets.
Inherited from: \Zend_Db_Statement_Pdo::nextRowset()An example is a stored procedure that returns the results of multiple queries.
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


rowCount() : int
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Inherited from: \Zend_Db_Statement_Pdo::rowCount()Type | Description |
---|---|
int | The number of rows affected. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


setAttribute(string $key, mixed $val) : bool
Name | Type | Description |
---|---|---|
$key | string | Attribute name. |
$val | mixed | Attribute value. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


setFetchMode(int $mode) : bool
Set the default fetch mode for this statement.
Inherited from: \Zend_Db_Statement_Pdo::setFetchMode()Name | Type | Description |
---|---|---|
$mode | int | The fetch mode. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |