Methods |
public
|
bindValue(int|string $param, mixed $value, int $type = ParameterType::STRING): bool
Binds a value to a corresponding named (not supported by mysqli driver, see comment below) or positional
placeholder in…
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.
As mentioned above, the named parameters are not natively supported by the mysqli driver, use executeQuery(),
fetchAll(), fetchArray(), fetchColumn(), fetchAssoc() methods to have the named parameter emulated by doctrine.
Parameters
$param |
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 |
The value to bind to the parameter.
|
$type |
Explicit data type for the parameter using the {@link ParameterType}
constants.
|
Returns
TRUE on success or FALSE on failure.
Implemented by
|
#
|
public
|
bindParam(int|string $param, mixed &$variable, int $type = ParameterType::STRING, int|null $length = null): bool
Binds a PHP variable to a corresponding named (not supported by mysqli driver, see comment below) or question
mark…
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 PDOStatement->bindValue(),
the variable is bound as a reference and will only be evaluated at the time
that PDOStatement->execute() is called.
As mentioned above, the named parameters are not natively supported by the mysqli driver, use executeQuery(),
fetchAll(), fetchArray(), fetchColumn(), fetchAssoc() methods to have the named parameter emulated by doctrine.
Most parameters are input parameters, that is, parameters that are
used in a read-only fashion to build up the query. Some drivers support the invocation
of stored procedures that return data as output parameters, and some also as input/output
parameters that both send in data and are updated to receive it.
Parameters
$param |
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.
|
$variable |
Name of the PHP variable to bind to the SQL statement parameter.
|
$type |
Explicit data type for the parameter using the {@link ParameterType}
constants. To return an INOUT parameter from a stored procedure, use the bitwise
OR operator to set the PDO::PARAM_INPUT_OUTPUT bits for the data_type parameter.
|
$length |
You must specify maxlength when using an OUT bind
so that PHP allocates enough memory to hold the returned value.
|
Returns
TRUE on success or FALSE on failure.
Implemented by
|
#
|
public
|
errorCode(): string|int|bool
Fetches the SQLSTATE associated with the last operation on the statement handle.
Fetches the SQLSTATE associated with the last operation on the statement handle.
Deprecated
The error information is available via exceptions.
Returns
Implemented by
|
#
|
public
|
errorInfo(): mixed[]
Fetches extended error information associated with the last operation on the statement handle.
Fetches extended error information associated with the last operation on the statement handle.
Deprecated
The error information is available via exceptions.
Returns
Implemented by
|
#
|
public
|
execute(mixed[]|null $params = null): bool
Executes a prepared statement
Executes a prepared statement
If the prepared statement included parameter markers, you must either:
call PDOStatement->bindParam() to bind PHP variables to the parameter markers:
bound variables pass their value as input and receive the output value,
if any, of their associated parameter markers or pass an array of input-only
parameter values.
Parameters
$params |
An array of values with as many elements as there are
bound parameters in the SQL statement being executed.
|
Returns
TRUE on success or FALSE on failure.
Implemented by
|
#
|
public
|
rowCount(): int|string
Returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement
executed by the corresponding…
Returns the number of rows affected by the last DELETE, INSERT, or UPDATE statement
executed by the corresponding object.
If the last SQL statement executed by the associated Statement object was a SELECT statement,
some databases may return the number of rows returned by that statement. However,
this behaviour is not guaranteed for all databases and should not be
relied on for portable applications.
Returns
Implemented by
|
#
|