Zend Framework
1.12
|
Public Member Functions | |
setLobAsString ($lob_as_string) | |
Activate/deactivate return of LOB as string. | |
getLobAsString () | |
Return whether or not LOB are returned as string. | |
closeCursor () | |
Closes the cursor, allowing the statement to be executed again. | |
columnCount () | |
Returns the number of columns in the result set. | |
errorCode () | |
Retrieves the error code, if any, associated with the last operation on the statement handle. | |
errorInfo () | |
Retrieves an array of error information, if any, associated with the last operation on the statement handle. | |
_execute (array $params=null) | |
Executes a prepared statement. | |
fetch ($style=null, $cursor=null, $offset=null) | |
Fetches a row from the result set. | |
fetchAll ($style=null, $col=0) | |
Returns an array containing all of the result set rows. | |
fetchColumn ($col=0) | |
Returns a single column from the next row of a result set. | |
fetchObject ($class= 'stdClass', array $config=array()) | |
Fetches the next row and returns it as an object. | |
nextRowset () | |
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. | |
rowCount () | |
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object. | |
![]() | |
__construct ($adapter, $sql) | |
Constructor for a statement. | |
bindColumn ($column, &$param, $type=null) | |
Bind a column of the statement result set to a PHP variable. | |
bindParam ($parameter, &$variable, $type=null, $length=null, $options=null) | |
Binds a parameter to the specified variable name. | |
bindValue ($parameter, $value, $type=null) | |
Binds a value to a parameter. | |
execute (array $params=null) | |
Executes a prepared statement. | |
fetchAll ($style=null, $col=null) | |
Returns an array containing all of the result set rows. | |
fetchColumn ($col=0) | |
Returns a single column from the next row of a result set. | |
fetchObject ($class= 'stdClass', array $config=array()) | |
Fetches the next row and returns it as an object. | |
getAttribute ($key) | |
Retrieve a statement attribute. | |
setAttribute ($key, $val) | |
Set a statement attribute. | |
setFetchMode ($mode) | |
Set the default fetch mode for this statement. | |
_fetchBound ($row) | |
Helper function to map retrieved row to bound column variables. | |
getAdapter () | |
Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Statement object. | |
getDriverStatement () | |
Gets the resource or object setup by the _parse. | |
Protected Member Functions | |
_prepare ($sql) | |
Prepares statement handle. | |
_bindParam ($parameter, &$variable, $type=null, $length=null, $options=null) | |
Binds a parameter to the specified variable name. | |
![]() | |
_prepare ($sql) | |
Internal method called by abstract statment constructor to setup the driver level statement. | |
_parseParameters ($sql) | |
_stripQuoted ($sql) | |
Remove parts of a SQL string that contain quoted strings of values or identifiers. | |
Protected Attributes | |
$_keys | |
Column names. | |
$_values | |
Fetched result values. | |
$_lobAsString = false | |
![]() | |
$_stmt = null | |
$_adapter = null | |
$_fetchMode = Zend_Db::FETCH_ASSOC | |
$_attribute = array() | |
$_bindColumn = array() | |
$_bindParam = array() | |
$_sqlSplit = array() | |
$_sqlParam = array() | |
$_queryId = null | |
|
protected |
Binds a parameter to the specified variable name.
mixed | $parameter | Name the parameter, either integer or string. |
mixed | $variable | Reference to PHP variable containing the value. |
mixed | $type | OPTIONAL Datatype of SQL parameter. |
mixed | $length | OPTIONAL Length of SQL parameter. |
mixed | $options | OPTIONAL Other options. |
Zend_Db_Statement_Exception |
_execute | ( | array | $params = null | ) |
Executes a prepared statement.
array | $params | OPTIONAL Values to bind to parameter placeholders. |
Zend_Db_Statement_Exception |
|
protected |
Prepares statement handle.
string | $sql |
Zend_Db_Statement_Oracle_Exception |
closeCursor | ( | ) |
Closes the cursor, allowing the statement to be executed again.
Implements Zend_Db_Statement_Interface.
columnCount | ( | ) |
Returns the number of columns in the result set.
Returns null if the statement has no result set metadata.
Implements Zend_Db_Statement_Interface.
errorCode | ( | ) |
Retrieves the error code, if any, associated with the last operation on the statement handle.
Implements Zend_Db_Statement_Interface.
errorInfo | ( | ) |
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Implements Zend_Db_Statement_Interface.
fetch | ( | $style = null , |
|
$cursor = null , |
|||
$offset = null |
|||
) |
Fetches a row from the result set.
int | $style | OPTIONAL Fetch mode for this fetch operation. |
int | $cursor | OPTIONAL Absolute, relative, or other. |
int | $offset | OPTIONAL Number for absolute or relative cursors. |
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
fetchAll | ( | $style = null , |
|
$col = 0 |
|||
) |
Returns an array containing all of the result set rows.
int | $style | OPTIONAL Fetch mode. |
int | $col | OPTIONAL Column number, if fetch mode is by column. |
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
fetchColumn | ( | $col = 0 | ) |
Returns a single column from the next row of a result set.
int | $col | OPTIONAL Position of the column to fetch. |
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
fetchObject | ( | $class = 'stdClass' , |
|
array | $config = array() |
||
) |
Fetches the next row and returns it as an object.
string | $class | OPTIONAL Name of the class to create. |
array | $config | OPTIONAL Constructor arguments for the class. |
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
getLobAsString | ( | ) |
Return whether or not LOB are returned as string.
nextRowset | ( | ) |
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets.
An example is a stored procedure that returns the results of multiple queries.
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
rowCount | ( | ) |
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Zend_Db_Statement_Exception |
Implements Zend_Db_Statement_Interface.
setLobAsString | ( | $lob_as_string | ) |
Activate/deactivate return of LOB as string.
string | $lob_as_string |
|
protected |
Column names.
|
protected |
|
protected |
Fetched result values.