Public Member Functions | Protected Member Functions | Protected Attributes

Zend_Db_Statement_Pdo Class Reference

Inheritance diagram for Zend_Db_Statement_Pdo:
Zend_Db_Statement Zend_Db_Statement_Interface Zend_Db_Statement_Pdo_Ibm Zend_Db_Statement_Pdo_Oci

Public Member Functions

 bindColumn ($column, &$param, $type=null)
 bindValue ($parameter, $value, $type=null)
 closeCursor ()
 columnCount ()
 errorCode ()
 errorInfo ()
 _execute (array $params=null)
 fetch ($style=null, $cursor=null, $offset=null)
 getIterator ()
 fetchAll ($style=null, $col=null)
 fetchColumn ($col=0)
 fetchObject ($class= 'stdClass', array $config=array())
 getAttribute ($key)
 getColumnMeta ($column)
 nextRowset ()
 rowCount ()
 setAttribute ($key, $val)
 setFetchMode ($mode)

Protected Member Functions

 _prepare ($sql)
 _bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)

Protected Attributes

 $_fetchMode = PDO::FETCH_ASSOC

Detailed Description

Definition at line 40 of file Pdo.php.


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

Reimplemented in Zend_Db_Statement_Pdo_Ibm.

Definition at line 100 of file Pdo.php.

_execute ( array $  params = null )

Executes a prepared statement.

Parameters:
array$paramsOPTIONAL Values to bind to parameter placeholders.
Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Definition at line 224 of file Pdo.php.

_prepare ( sql ) [protected]

Prepare a string SQL statement and create a statement object.

Parameters:
string$sql
Returns:
void
Exceptions:
Zend_Db_Statement_Exception

Reimplemented from Zend_Db_Statement.

Definition at line 55 of file Pdo.php.

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

Reimplemented from Zend_Db_Statement.

Definition at line 75 of file Pdo.php.

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

Reimplemented from Zend_Db_Statement.

Definition at line 130 of file Pdo.php.

closeCursor (  )

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

Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 156 of file Pdo.php.

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.

Definition at line 173 of file Pdo.php.

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.

Definition at line 190 of file Pdo.php.

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.

Definition at line 207 of file Pdo.php.

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.

Definition at line 247 of file Pdo.php.

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

Reimplemented from Zend_Db_Statement.

Reimplemented in Zend_Db_Statement_Pdo_Ibm, and Zend_Db_Statement_Pdo_Oci.

Definition at line 278 of file Pdo.php.

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

Reimplemented from Zend_Db_Statement.

Definition at line 305 of file Pdo.php.

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

Reimplemented from Zend_Db_Statement.

Definition at line 323 of file Pdo.php.

getAttribute ( key )

Retrieve a statement attribute.

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

Reimplemented from Zend_Db_Statement.

Definition at line 340 of file Pdo.php.

getColumnMeta ( column )

Returns metadata for a column in a result set.

Parameters:
int$column
Returns:
mixed
Exceptions:
Zend_Db_Statement_Exception

Definition at line 357 of file Pdo.php.

getIterator (  )

Required by IteratorAggregate interface

Returns:
IteratorIterator

Definition at line 265 of file Pdo.php.

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.

Definition at line 375 of file Pdo.php.

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.

Definition at line 393 of file Pdo.php.

setAttribute ( key,
val 
)

Set a statement attribute.

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

Reimplemented from Zend_Db_Statement.

Definition at line 411 of file Pdo.php.

setFetchMode ( mode )

Set the default fetch mode for this statement.

Parameters:
int$modeThe fetch mode.
Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Reimplemented from Zend_Db_Statement.

Definition at line 428 of file Pdo.php.


The documentation for this class was generated from the following file: