Public Member Functions
	setQueryProfile (Zend_Db_Profiler_Query $qp)

	setRowCount ($rowCount)

	append ($row)
	Append a new row to the fetch stack.

	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.

Static Public Member Functions
static	createSelectStatement (array $rows=array())
	Create a Select statement which returns the given array of rows.

static	createInsertStatement ($affectedRows=0)
	Create an Insert Statement.

static	createDeleteStatement ($affectedRows=0)
	Create an Delete Statement.

static	createUpdateStatement ($affectedRows=0)
	Create an Update Statement.

Static Protected Member Functions
static	_createRowCountStatement ($affectedRows)
	Create a Row Count Statement.

Protected Attributes
	$_fetchStack = array()

	$_columnCount = 0

	$_rowCount = 0

	$_queryProfile = null

Member Function Documentation

static _createRowCountStatement ( $affectedRows )

staticprotected

Create a Row Count Statement.

Parameters

int $affectedRows

Returns: Zend_Test_DbStatement

append ( $row )

Append a new row to the fetch stack.

Parameters

array $row

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

Implements Zend_Db_Statement_Interface.

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

Implements Zend_Db_Statement_Interface.

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

Implements Zend_Db_Statement_Interface.

closeCursor ( )

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

Returns: bool

Exceptions

Zend_Db_Statement_Exception

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.

Returns: int The number of columns.

Exceptions

Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

static createDeleteStatement ( $affectedRows = 0 )

static

Create an Delete Statement.

Parameters

int $affectedRows

Returns: Zend_Test_DbStatement

static createInsertStatement ( $affectedRows = 0 )

static

Create an Insert Statement.

Parameters

int $affectedRows

Returns: Zend_Test_DbStatement

static createSelectStatement ( array $rows = array() )

static

Create a Select statement which returns the given array of rows.

Parameters

array $rows

Returns: Zend_Test_DbStatement

static createUpdateStatement ( $affectedRows = 0 )

static

Create an Update Statement.

Parameters

int $affectedRows

Returns: Zend_Test_DbStatement

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

Implements Zend_Db_Statement_Interface.

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

Implements Zend_Db_Statement_Interface.

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

Implements Zend_Db_Statement_Interface.

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.