PHP Class Zend_Db_Statement_Mysqli

Inheritance: extends Zend_Db_Statement
Exibir arquivo Open project: dbpatch/dbpatch Class Usage Examples

Protected Properties

Property Type Description
$_keys array Column names.
$_meta array
$_values array Fetched result values.

Public Methods

Method Description
_execute ( array $params = null ) : boolean Executes a prepared statement.
_prepare ( string $sql ) : void
close ( ) : boolean Closes the cursor and the statement.
closeCursor ( ) : boolean Closes the cursor, allowing the statement to be executed again.
columnCount ( ) : integer Returns the number of columns in the result set.
errorCode ( ) : string Retrieves the error code, if any, associated with the last operation on the statement handle.
errorInfo ( ) : array Retrieves an array of error information, if any, associated with the last operation on the statement handle.
fetch ( integer $style = null, integer $cursor = null, integer $offset = null ) : mixed Fetches a row from the result set.
nextRowset ( ) : boolean 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.
rowCount ( ) : integer Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

Protected Methods

Method Description
_bindParam ( mixed $parameter, mixed &$variable, mixed $type = null, mixed $length = null, mixed $options = null ) : boolean Binds a parameter to the specified variable name.

Method Details

_bindParam() protected method

Binds a parameter to the specified variable name.
protected _bindParam ( mixed $parameter, mixed &$variable, mixed $type = null, mixed $length = null, mixed $options = null ) : boolean
$parameter mixed Name the parameter, either integer or string.
$variable mixed Reference to PHP variable containing the value.
$type mixed OPTIONAL Datatype of SQL parameter.
$length mixed OPTIONAL Length of SQL parameter.
$options mixed OPTIONAL Other options.
return boolean

_execute() public method

Executes a prepared statement.
public _execute ( array $params = null ) : boolean
$params array OPTIONAL Values to bind to parameter placeholders.
return boolean

_prepare() public method

public _prepare ( string $sql ) : void
$sql string
return void

close() public method

Closes the cursor and the statement.
public close ( ) : boolean
return boolean

closeCursor() public method

Closes the cursor, allowing the statement to be executed again.
public closeCursor ( ) : boolean
return boolean

columnCount() public method

Returns null if the statement has no result set metadata.
public columnCount ( ) : integer
return integer The number of columns.

errorCode() public method

Retrieves the error code, if any, associated with the last operation on the statement handle.
public errorCode ( ) : string
return string error code.

errorInfo() public method

Retrieves an array of error information, if any, associated with the last operation on the statement handle.
public errorInfo ( ) : array
return array

fetch() public method

Fetches a row from the result set.
public fetch ( integer $style = null, integer $cursor = null, integer $offset = null ) : mixed
$style integer OPTIONAL Fetch mode for this fetch operation.
$cursor integer OPTIONAL Absolute, relative, or other.
$offset integer OPTIONAL Number for absolute or relative cursors.
return mixed Array, object, or scalar depending on fetch mode.

nextRowset() public method

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.
public nextRowset ( ) : boolean
return boolean

rowCount() public method

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
public rowCount ( ) : integer
return integer The number of rows affected.

Property Details

$_keys protected_oe property

Column names.
protected array $_keys
return array

$_meta protected_oe property

protected array $_meta
return array

$_values protected_oe property

Fetched result values.
protected array $_values
return array