Statement
in package
implements
Statement
Interfaces, Classes, Traits and Enums
- Statement
- Driver-level statement
Table of Contents
- PARAM_TYPE_MAP = [\Doctrine\DBAL\ParameterType::NULL => \PDO::PARAM_NULL, \Doctrine\DBAL\ParameterType::INTEGER => \PDO::PARAM_INT, \Doctrine\DBAL\ParameterType::STRING => \PDO::PARAM_STR, \Doctrine\DBAL\ParameterType::ASCII => \PDO::PARAM_STR, \Doctrine\DBAL\ParameterType::BINARY => \PDO::PARAM_LOB, \Doctrine\DBAL\ParameterType::LARGE_OBJECT => \PDO::PARAM_LOB, \Doctrine\DBAL\ParameterType::BOOLEAN => \PDO::PARAM_BOOL]
- $stmt : PDOStatement
- bindParam() : bool
- Binds a PHP variable to a corresponding named (not supported by mysqli driver, see comment below) or question mark placeholder in the SQL statement that was use to prepare the statement. Unlike {@link bindValue()}, the variable is bound as a reference and will only be evaluated at the time that PDOStatement->execute() is called.
- bindValue() : bool
- Binds a value to a corresponding named (not supported by mysqli driver, see comment below) or positional placeholder in the SQL statement that was used to prepare the statement.
- execute() : Result
- Executes a prepared statement
- convertParamType() : int
- Converts DBAL parameter type to PDO parameter type
Constants
PARAM_TYPE_MAP
private
mixed
PARAM_TYPE_MAP
= [\Doctrine\DBAL\ParameterType::NULL => \PDO::PARAM_NULL, \Doctrine\DBAL\ParameterType::INTEGER => \PDO::PARAM_INT, \Doctrine\DBAL\ParameterType::STRING => \PDO::PARAM_STR, \Doctrine\DBAL\ParameterType::ASCII => \PDO::PARAM_STR, \Doctrine\DBAL\ParameterType::BINARY => \PDO::PARAM_LOB, \Doctrine\DBAL\ParameterType::LARGE_OBJECT => \PDO::PARAM_LOB, \Doctrine\DBAL\ParameterType::BOOLEAN => \PDO::PARAM_BOOL]
Properties
$stmt
private
PDOStatement
$stmt
Methods
bindParam()
Binds a PHP variable to a corresponding named (not supported by mysqli driver, see comment below) or question mark placeholder in the SQL statement that was use to prepare the statement. Unlike {@link bindValue()}, the variable is bound as a reference and will only be evaluated at the time that PDOStatement->execute() is called.
public
bindParam(mixed $param, mixed &$variable[, int $type = ParameterType::STRING ][, int|null $length = null ][, mixed $driverOptions = null ]) : bool
Parameters
- $param : mixed
- $variable : mixed
- $type : int = ParameterType::STRING
- $length : int|null = null
- $driverOptions : mixed = null
-
The usage of the argument is deprecated.
Return values
bool —TRUE on success or FALSE on failure.
bindValue()
Binds a value to a corresponding named (not supported by mysqli driver, see comment below) or positional placeholder in the SQL statement that was used to prepare the statement.
public
bindValue(mixed $param, mixed $value[, mixed $type = ParameterType::STRING ]) : bool
Parameters
- $param : mixed
-
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.
- $value : mixed
-
The value to bind to the parameter.
- $type : mixed = ParameterType::STRING
-
Return values
bool —TRUE on success or FALSE on failure.
execute()
Executes a prepared statement
public
execute([mixed $params = null ]) : Result
Parameters
- $params : mixed = null
-
A numeric array of values with as many elements as there are bound parameters in the SQL statement being executed.
Return values
Result —convertParamType()
Converts DBAL parameter type to PDO parameter type
private
convertParamType(int $type) : int
Parameters
- $type : int
-
Parameter type