Zend Framework  1.12
Public Member Functions | Protected Member Functions | Protected Attributes | List of all members
Zend_Db_Statement_Pdo Class Reference

Public Member Functions

 bindColumn ($column, &$param, $type=null)
 Bind a column of the statement result set to a PHP variable.
 
 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=null)
 Executes a prepared statement.
 
 fetch ($style=null, $cursor=null, $offset=null)
 Fetches a row from the result set.
 
 getIterator ()
 Required by IteratorAggregate interface.
 
 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.
 
 getColumnMeta ($column)
 Returns metadata for a column in a result set.
 
 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.
 
- Public Member Functions inherited from Zend_Db_Statement
 __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)
 Prepare a string SQL statement and create a statement object.
 
 _bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)
 Binds a parameter to the specified variable name.
 
- Protected Member Functions inherited from Zend_Db_Statement
 _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

 $_fetchMode = PDO::FETCH_ASSOC
 
- Protected Attributes inherited from Zend_Db_Statement
 $_stmt = null
 
 $_adapter = null
 
 $_fetchMode = Zend_Db::FETCH_ASSOC
 
 $_attribute = array()
 
 $_bindColumn = array()
 
 $_bindParam = array()
 
 $_sqlSplit = array()
 
 $_sqlParam = array()
 
 $_queryId = null
 

Member Function Documentation

_bindParam (   $parameter,
$variable,
  $type = null,
  $length = null,
  $options = null 
)
protected

Binds a parameter to the specified variable name.

Parameters
mixed$parameterName the parameter, either integer or string.
mixed$variableReference to PHP variable containing the value.
mixed$typeOPTIONAL Datatype of SQL parameter.
mixed$lengthOPTIONAL Length of SQL parameter.
mixed$optionsOPTIONAL Other options.
Returns
bool
Exceptions
Zend_Db_Statement_Exception
_execute ( array  $params = null)

Executes a prepared statement.

Parameters
array$paramsOPTIONAL Values to bind to parameter placeholders.
Returns
bool
Exceptions
Zend_Db_Statement_Exception
_prepare (   $sql)
protected

Prepare a string SQL statement and create a statement object.

Parameters
string$sql
Returns
void
Exceptions
Zend_Db_Statement_Exception
bindColumn (   $column,
$param,
  $type = null 
)

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

Parameters
string$columnName the column in the result set, either by position or by name.
mixed$paramReference to the PHP variable containing the value.
mixed$typeOPTIONAL
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$parameterName the parameter, either integer or string.
mixed$valueScalar value to bind to the parameter.
mixed$typeOPTIONAL 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.

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.

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

Fetches a row from the result set.

Parameters
int$styleOPTIONAL Fetch mode for this fetch operation.
int$cursorOPTIONAL Absolute, relative, or other.
int$offsetOPTIONAL Number for absolute or relative cursors.
Returns
mixed Array, object, or scalar depending on fetch mode.
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

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

Returns an array containing all of the result set rows.

Parameters
int$styleOPTIONAL Fetch mode.
int$colOPTIONAL 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

Implements Zend_Db_Statement_Interface.

fetchColumn (   $col = 0)

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

Parameters
int$colOPTIONAL Position of the column to fetch.
Returns
string
Exceptions
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.

Parameters
string$classOPTIONAL Name of the class to create.
array$configOPTIONAL Constructor arguments for the class.
Returns
mixed One object instance of the specified class.
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

getAttribute (   $key)

Retrieve a statement attribute.

Parameters
integer$keyAttribute name.
Returns
mixed Attribute value.
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

getColumnMeta (   $column)

Returns metadata for a column in a result set.

Parameters
int$column
Returns
mixed
Exceptions
Zend_Db_Statement_Exception
getIterator ( )

Required by IteratorAggregate interface.

Returns
IteratorIterator
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.

Returns
bool
Exceptions
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.

Returns
int The number of rows affected.
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

setAttribute (   $key,
  $val 
)

Set a statement attribute.

Parameters
string$keyAttribute name.
mixed$valAttribute value.
Returns
bool
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

setFetchMode (   $mode)

Set the default fetch mode for this statement.

Parameters
int$modeThe fetch mode.
Returns
bool
Exceptions
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

Member Data Documentation

$_fetchMode = PDO::FETCH_ASSOC
protected