PHP Class Zend_Db_Statement_Mysqli

Inheritance: extends Zend_Db_Statement
Afficher le fichier Open project: dbpatch/dbpatch Class Usage Examples

Protected Properties

Свойство Type Description
$_keys array Column names.
$_meta array
$_values array Fetched result values.

Méthodes publiques

Méthode 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.

Méthodes protégées

Méthode 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 méthode

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.
Résultat boolean

_execute() public méthode

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

_prepare() public méthode

public _prepare ( string $sql ) : void
$sql string
Résultat void

close() public méthode

Closes the cursor and the statement.
public close ( ) : boolean
Résultat boolean

closeCursor() public méthode

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

columnCount() public méthode

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

errorCode() public méthode

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

errorInfo() public méthode

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

fetch() public méthode

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.
Résultat mixed Array, object, or scalar depending on fetch mode.

nextRowset() public méthode

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
Résultat boolean

rowCount() public méthode

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
Résultat integer The number of rows affected.

Property Details

$_keys protected_oe property

Column names.
protected array $_keys
Résultat array

$_meta protected_oe property

protected array $_meta
Résultat array

$_values protected_oe property

Fetched result values.
protected array $_values
Résultat array