Public Member Functions
	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.

	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=array())
	Executes a prepared statement.

	fetch ($style=null, $cursor=null, $offset=null)
	Fetches a row from the result set.

	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.

	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.

	setAttribute ($key, $val)
	Set a statement attribute.

	setFetchMode ($mode)
	Set the default fetch mode for this statement.

Member Function Documentation

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, Zend_Test_DbStatement, and Zend_Db_Statement_Pdo.

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, and Zend_Test_DbStatement.

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, Zend_Test_DbStatement, and Zend_Db_Statement_Pdo.

closeCursor ( )

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

Returns: bool

Exceptions

Zend_Db_Statement_Exception

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

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_Test_DbStatement, Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Mysqli, Zend_Db_Statement_Db2, and Zend_Db_Statement_Sqlsrv.

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_Test_DbStatement, Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Mysqli, Zend_Db_Statement_Db2, and Zend_Db_Statement_Sqlsrv.

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_Test_DbStatement, Zend_Db_Statement_Pdo, Zend_Db_Statement_Oracle, Zend_Db_Statement_Db2, Zend_Db_Statement_Mysqli, and Zend_Db_Statement_Sqlsrv.

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, and Zend_Test_DbStatement.

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.