Référence de la classe MysqliStatement

Graphe d'héritage de MysqliStatement:

Fonctions membres publiques
	__construct (\mysqli $connection, string $query)
	prepareParameterKeyMapping ($sql)
	bindParam ($parameter, &$variable, string $dataType=ParameterType::STRING, ?int $length=null, ?array $driverOptions=null)
	closeCursor ()
	errorCode ()
	errorInfo ()
	execute (?array $parameters=null)
	fetch (?int $fetchStyle=null, int $cursorOrientation=FetchOrientation::NEXT, int $cursorOffset=0)
	fetchColumn ($columnIndex=0)
	rowCount ()
	setFetchMode (int $fetchMode,... $args)

Attributs protégés
	$bindedValues
	$parameterKeyMapping
	$parameterTypeMapping
	$columnNames
	$connection
	$defaultFetchStyle = FetchMode::MIXED
	$query
	$rowBindedValues
	$statement
	$typesKeyMapping

Fonctions membres privées
	bindValues (array $values)
	fetchData ()

Attributs privés
	$result = false

Description détaillée

MySQLi Database Statement.

This class is modeled on

Depuis

2.0.0

Documentation des constructeurs et destructeur

__construct()

__construct	(	\mysqli	$connection,
		string	$query
	)

Constructor.

Paramètres

\mysqli	$connection	The database connection resource
string	$query	The query this statement will process

Depuis

2.0.0

Exceptions

PrepareStatementFailureException

Références MysqliStatement\$connection, MysqliStatement\$query, $this, et MysqliStatement\prepareParameterKeyMapping().

Documentation des fonctions membres

bindParam()

bindParam	(		$parameter,
		&	$variable,
		string	$dataType = ParameterType::STRING,
		?int	$length = null,
		?array	$driverOptions = null
	)

Binds a parameter to the specified variable name.

Paramètres

string | integer	$parameter	Parameter identifier. For a prepared statement using named placeholders, this will be a parameter name of the form :name. For a prepared statement using question mark placeholders, this will be the 1-indexed position of the parameter.
mixed	$variable	Name of the PHP variable to bind to the SQL statement parameter.
integer	$dataType	Constant corresponding to a SQL datatype, this should be the processed type from the QueryInterface.
integer	$length	The length of the variable. Usually required for OUTPUT parameters.
array	$driverOptions	Optional driver options to be used.

Renvoie

boolean

Depuis

2.0.0

Implémente StatementInterface.

bindValues()

bindValues ( array  $values )

private

Binds a array of values to bound parameters.

Paramètres

array

$values

The values to bind to the statement

Renvoie

boolean

Depuis

2.0.0

Références $key, $params, et $value.

Référencé par MysqliStatement\execute().

closeCursor()

closeCursor

(

)

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

Renvoie

void

Depuis

2.0.0

Implémente StatementInterface.

errorCode()

errorCode

(

)

Fetches the SQLSTATE associated with the last operation on the statement handle.

Renvoie

string

Depuis

2.0.0

Implémente StatementInterface.

errorInfo()

errorInfo

(

)

Fetches extended error information associated with the last operation on the statement handle.

Renvoie

array

Depuis

2.0.0

Implémente StatementInterface.

execute()

execute

(

?array

$parameters = null

)

Executes a prepared statement

Paramètres

array | null

$parameters

An array of values with as many elements as there are bound parameters in the SQL statement being executed.

Renvoie

boolean

Depuis

2.0.0

Implémente StatementInterface.

Références MysqliStatement\$columnNames, $key, $parameters, $params, $this, $value, MysqliStatement\bindValues(), elseif, et null.

fetch()

fetch	(	?int	$fetchStyle = null,
		int	$cursorOrientation = FetchOrientation::NEXT,
		int	$cursorOffset = 0
	)

Fetches the next row from a result set

Paramètres

integer | null	$fetchStyle	Controls how the next row will be returned to the caller. This value must be one of the FetchMode constants, defaulting to value of FetchMode::MIXED.
integer	$cursorOrientation	For a StatementInterface object representing a scrollable cursor, this value determines which row will be returned to the caller. This value must be one of the FetchOrientation constants, defaulting to FetchOrientation::NEXT.
integer	$cursorOffset	For a StatementInterface object representing a scrollable cursor for which the cursorOrientation parameter is set to FetchOrientation::ABS, this value specifies the absolute number of the row in the result set that shall be fetched. For a StatementInterface object representing a scrollable cursor for which the cursorOrientation parameter is set to FetchOrientation::REL, this value specifies the row to fetch relative to the cursor position before fetch() was called.

Renvoie

mixed The return value of this function on success depends on the fetch type. In all cases, boolean false is returned on failure.

Depuis

2.0.0

Implémente StatementInterface.

Références MysqliStatement\$defaultFetchStyle, $this, FetchMode\ASSOCIATIVE, FetchMode\COLUMN, MysqliStatement\fetchColumn(), MysqliStatement\fetchData(), FetchMode\MIXED, null, FetchMode\NUMERIC, et FetchMode\STANDARD_OBJECT.

Référencé par MysqliStatement\fetchColumn().

fetchColumn()

fetchColumn

(

$columnIndex = 0

)

Returns a single column from the next row of a result set

Paramètres

integer

$columnIndex

0-indexed number of the column you wish to retrieve from the row. If no value is supplied, the first column is retrieved.

Renvoie

mixed Returns a single column from the next row of a result set or boolean false if there are no more rows.

Depuis

2.0.0

Références MysqliStatement\fetch(), null, et FetchMode\NUMERIC.

Référencé par MysqliStatement\fetch().

fetchData()

fetchData ( )

private

Fetch the data from the statement.

Renvoie

array|boolean

Depuis

2.0.0

Références $return.

Référencé par MysqliStatement\fetch().

prepareParameterKeyMapping()

prepareParameterKeyMapping

(

$sql

)

Replace named parameters with numbered parameters

Paramètres

string

$sql

The SQL statement to prepare.

Renvoie

string The processed SQL statement.

Depuis

2.0.0

Références $i, $n, et $sql.

Référencé par MysqliStatement\__construct().

rowCount()

rowCount

(

)

Returns the number of rows affected by the last SQL statement.

Renvoie

integer

Depuis

2.0.0

Implémente StatementInterface.

setFetchMode()

setFetchMode	(	int	$fetchMode,
			$args
	)

Sets the fetch mode to use while iterating this statement.

Paramètres

integer	$fetchMode	The fetch mode, must be one of the FetchMode constants.
	mixed	...$args Optional mode-specific arguments.

Renvoie

void

Depuis

2.0.0

Implémente StatementInterface.

Documentation des champs

$bindedValues

$bindedValues

protected

$columnNames

$columnNames

protected

Référencé par MysqliStatement\execute().

$connection

$connection

protected

Référencé par MysqliStatement\__construct().

$defaultFetchStyle

$defaultFetchStyle = FetchMode::MIXED

protected

Référencé par MysqliStatement\fetch().

$parameterKeyMapping

$parameterKeyMapping

protected

$parameterTypeMapping

$parameterTypeMapping

protected

Valeur initiale :

= [
                ParameterType::BOOLEAN      => 'i'

$query

$query

protected

Référencé par MysqliStatement\__construct().

$result

$result = false

private

$rowBindedValues

$rowBindedValues

protected

$statement

$statement

protected

$typesKeyMapping

$typesKeyMapping

protected

---

La documentation de cette classe a été générée à partir du fichier suivant :

• MysqliStatement.php