PHP 클래스 Zend_Db_Statement_Mysqli

상속: extends Zend_Db_Statement

보호된 프로퍼티들

프로퍼티	타입	설명
$_keys	array	Column names.
$_meta	array
$_values	array	Fetched result values.

공개 메소드들

메소드	설명
_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.

보호된 메소드들

메소드	설명
_bindParam ( mixed $parameter, mixed &$variable, mixed $type = null, mixed $length = null, mixed $options = null ) : boolean	Binds a parameter to the specified variable name.

메소드 상세

_bindParam() 보호된 메소드

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.
리턴	boolean

_execute() 공개 메소드

Executes a prepared statement.

public _execute ( array $params = null ) : boolean
$params	array	OPTIONAL Values to bind to parameter placeholders.
리턴	boolean

_prepare() 공개 메소드

public _prepare ( string $sql ) : void
$sql	string
리턴	void

close() 공개 메소드

Closes the cursor and the statement.

public close ( ) : boolean
리턴	boolean

closeCursor() 공개 메소드

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

public closeCursor ( ) : boolean
리턴	boolean

columnCount() 공개 메소드

Returns null if the statement has no result set metadata.

public columnCount ( ) : integer
리턴	integer	The number of columns.

errorCode() 공개 메소드

Retrieves the error code, if any, associated with the last operation on the statement handle.

public errorCode ( ) : string
리턴	string	error code.

errorInfo() 공개 메소드

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

public errorInfo ( ) : array
리턴	array

fetch() 공개 메소드

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.
리턴	mixed	Array, object, or scalar depending on fetch mode.

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.

public nextRowset ( ) : boolean
리턴	boolean

rowCount() 공개 메소드

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
리턴	integer	The number of rows affected.

프로퍼티 상세

$_keys 보호되어 있는 프로퍼티

Column names.

protected array $_keys
리턴	array

$_meta 보호되어 있는 프로퍼티

protected array $_meta
리턴	array

$_values 보호되어 있는 프로퍼티

Fetched result values.

protected array $_values
리턴	array