PHP Class Zend_Db_Statement_Mysqli

Inheritance: extends Zend_Db_Statement

Show file 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 property

Column names.

protected array $_keys
return	array

$_meta protected property

protected array $_meta
return	array

$_values protected property

Fetched result values.

protected array $_values
return	array