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

Public Member Functions

 _prepare ($sql)
 
 close ()
 Closes the cursor and the statement.
 
 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.
 
 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.
 
- 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

 _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

 $_keys
 
 $_values
 
 $_meta = null
 
- 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_Mysqli_Exception
_execute ( array  $params = null)

Executes a prepared statement.

Parameters
array$paramsOPTIONAL Values to bind to parameter placeholders.
Returns
bool
Exceptions
Zend_Db_Statement_Mysqli_Exception
See Also
Zend_Db_Statement_Mysqli_Exception
Zend_Db_Statement_Mysqli_Exception
_prepare (   $sql)
Parameters
string$sql
Returns
void
Exceptions
Zend_Db_Statement_Mysqli_Exception
See Also
Zend_Db_Statement_Mysqli_Exception
close ( )

Closes the cursor and the statement.

Returns
bool
closeCursor ( )

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

Returns
bool

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.

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.

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

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_Mysqli_Exception
See Also
Zend_Db_Statement_Mysqli_Exception

Implements Zend_Db_Statement_Interface.

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_Mysqli_Exception
See Also
Zend_Db_Statement_Mysqli_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.

Implements Zend_Db_Statement_Interface.

Member Data Documentation

$_keys
protected
$_meta = null
protected
$_values
protected