Inheritance diagram for Zend_Db_Statement_Interface:

Public Member Functions
	bindColumn ($column, &$param, $type=null)

	bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)

	bindValue ($parameter, $value, $type=null)

	closeCursor ()

	columnCount ()

	errorCode ()

	errorInfo ()

	execute (array $params=array())

	fetch ($style=null, $cursor=null, $offset=null)

	fetchAll ($style=null, $col=null)

	fetchColumn ($col=0)

	fetchObject ($class='stdClass', array $config=array())

	getAttribute ($key)

	nextRowset ()

	rowCount ()

	setAttribute ($key, $val)

	setFetchMode ($mode)

Detailed Description

Definition at line 32 of file Interface.php.

Member Function Documentation

◆ bindColumn()

bindColumn	(		$column,
		&	$param,
			$type = `null`
	)

Bind a column of the statement result set to a PHP variable.

Parameters

string	$column	Name the column in the result set, either by position or by name.
mixed	$param	Reference to the PHP variable containing the value.
mixed	$type	OPTIONAL

Returns: bool

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement, and Zend_Db_Statement_Pdo.

◆ bindParam()

bindParam	(		$parameter,
		&	$variable,
			$type = `null`,
			$length = `null`,
			$options = `null`
	)

Binds a parameter to the specified variable name.

Parameters

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.

Returns: bool

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement.

◆ bindValue()

bindValue	(	$parameter,
		$value,
		$type = `null`
	)

Binds a value to a parameter.

Parameters

mixed	$parameter	Name the parameter, either integer or string.
mixed	$value	Scalar value to bind to the parameter.
mixed	$type	OPTIONAL Datatype of the parameter.

Returns: bool

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement, and Zend_Db_Statement_Pdo.

◆ closeCursor()

closeCursor ( )

Closes the cursor, allowing the statement to be executed again.

Returns: bool

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Db2, Zend_Db_Statement_Mysqli, and Zend_Db_Statement_Sqlsrv.

◆ columnCount()

columnCount ( )

Returns the number of columns in the result set. Returns null if the statement has no result set metadata.

Returns: int The number of columns.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Mysqli, Zend_Db_Statement_Db2, and Zend_Db_Statement_Sqlsrv.

◆ errorCode()

errorCode ( )

Retrieves the error code, if any, associated with the last operation on the statement handle.

Returns: string error code.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Mysqli, Zend_Db_Statement_Db2, and Zend_Db_Statement_Sqlsrv.

◆ errorInfo()

errorInfo ( )

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

Returns: array

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Db2, Zend_Db_Statement_Mysqli, and Zend_Db_Statement_Sqlsrv.

◆ execute()

execute ( array $params = array() )

Executes a prepared statement.

Parameters

array $params OPTIONAL Values to bind to parameter placeholders.

Returns: bool

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement.

◆ fetch()

fetch	(	$style = `null`,
		$cursor = `null`,
		$offset = `null`
	)

Fetches a row from the result set.

Parameters

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.

Returns: mixed Array, object, or scalar depending on fetch mode.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Oracle, Zend_Db_Statement_Mysqli, Zend_Db_Statement_Pdo, Zend_Db_Statement_Db2, Zend_Db_Statement_Sqlsrv, and Zend_Db_Statement_Pdo_Oci.

◆ fetchAll()

fetchAll	(	$style = `null`,
		$col = `null`
	)

Returns an array containing all of the result set rows.

Parameters

int	$style	OPTIONAL Fetch mode.
int	$col	OPTIONAL Column number, if fetch mode is by column.

Returns: array Collection of rows, each in a format by the fetch mode.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Sqlsrv, Zend_Db_Statement_Oracle, Zend_Db_Statement_Db2, Zend_Db_Statement, Zend_Db_Statement_Pdo, Zend_Db_Statement_Pdo_Oci, and Zend_Db_Statement_Pdo_Ibm.

◆ fetchColumn()

fetchColumn ( $col = 0 )

Returns a single column from the next row of a result set.

Parameters

int $col OPTIONAL Position of the column to fetch.

Returns: string

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Oracle, Zend_Db_Statement, Zend_Db_Statement_Pdo, and Zend_Db_Statement_Sqlsrv.

◆ fetchObject()

fetchObject	(		$class = `'stdClass'`,
		array	$config = `array()`
	)

Fetches the next row and returns it as an object.

Parameters

string	$class	OPTIONAL Name of the class to create.
array	$config	OPTIONAL Constructor arguments for the class.

Returns: mixed One object instance of the specified class.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement_Oracle, Zend_Db_Statement, Zend_Db_Statement_Pdo, Zend_Db_Statement_Sqlsrv, and Zend_Db_Statement_Db2.

◆ getAttribute()

getAttribute ( $key )

Retrieve a statement attribute.

Parameters

string $key Attribute name.

Returns: mixed Attribute value.

Exceptions

Zend_Db_Statement_Exception

Implemented in Zend_Db_Statement, and Zend_Db_Statement_Pdo.

◆ nextRowset()

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.