Membros públicos | |
| bindValue ($param, $value, $type=null) | |
| bindParam ($column, &$variable, $type=null) | |
| closeCursor () | |
| columnCount () | |
| errorCode () | |
| errorInfo () | |
| execute ($params=null) | |
| fetch ($fetchStyle=PDO::FETCH_BOTH) | |
| fetchAll ($fetchStyle=PDO::FETCH_BOTH) | |
| fetchColumn ($columnIndex=0) | |
| rowCount () | |
Descrição detalhada
Statement interface. Drivers must implement this interface.
This resembles (a subset of) the PDOStatement interface.
Definido na linha 39 do ficheiro Statement.php.
Documentação das funções
◆ bindParam()
| bindParam | ( | $column, | |
| & | $variable, | ||
| $type = null ) |
Binds a PHP variable to a corresponding named 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.
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.
- Parâmetros
-
mixed $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 mixed $variable Name of the PHP variable to bind to the SQL statement parameter. integer $type Explicit data type for the parameter using the PDO::PARAM_* 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.
- Retorna
- boolean Returns TRUE on success or FALSE on failure.
Implementado em DB2Statement, OCI8Statement e Statement.
◆ bindValue()
| bindValue | ( | $param, | |
| $value, | |||
| $type = null ) |
Binds a value to a corresponding named or positional placeholder in the SQL statement that was used to prepare the statement.
- Parâmetros
-
mixed $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 mixed $value The value to bind to the parameter. integer $type Explicit data type for the parameter using the PDO::PARAM_* constants.
- Retorna
- boolean Returns TRUE on success or FALSE on failure.
Implementado em Statement, DB2Statement e OCI8Statement.
◆ closeCursor()
| closeCursor | ( | ) |
Closes the cursor, enabling the statement to be executed again.
- Retorna
- boolean Returns TRUE on success or FALSE on failure.
Implementado em DB2Statement, OCI8Statement e Statement.
◆ columnCount()
| columnCount | ( | ) |
columnCount Returns the number of columns in the result set
- Retorna
- integer Returns the number of columns in the result set represented by the PDOStatement object. If there is no result set, this method should return 0.
Implementado em DB2Statement, OCI8Statement e Statement.
◆ errorCode()
| errorCode | ( | ) |
errorCode Fetch the SQLSTATE associated with the last operation on the statement handle
- Veja também
- Doctrine_Adapter_Interface::errorCode()
- Retorna
- string error code string
Implementado em DB2Statement, OCI8Statement e Statement.
◆ errorInfo()
| errorInfo | ( | ) |
errorInfo Fetch extended error information associated with the last operation on the statement handle
- Veja também
- Doctrine_Adapter_Interface::errorInfo()
- Retorna
- array error info array
Implementado em DB2Statement, OCI8Statement e Statement.
◆ execute()
| execute | ( | $params = null | ) |
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
- Parâmetros
-
array $params An array of values with as many elements as there are bound parameters in the SQL statement being executed.
- Retorna
- boolean Returns TRUE on success or FALSE on failure.
Implementado em DB2Statement, OCI8Statement e Statement.
◆ fetch()
| fetch | ( | $fetchStyle = PDO::FETCH_BOTH | ) |
fetch
- Veja também
- Query::HYDRATE_* constants
- Parâmetros
-
integer $fetchStyle Controls how the next row will be returned to the caller. This value must be one of the Query::HYDRATE_* constants, defaulting to Query::HYDRATE_BOTH integer $cursorOrientation For a PDOStatement object representing a scrollable cursor, this value determines which row will be returned to the caller. This value must be one of the Query::HYDRATE_ORI_* constants, defaulting to Query::HYDRATE_ORI_NEXT. To request a scrollable cursor for your PDOStatement object, you must set the PDO::ATTR_CURSOR attribute to Doctrine::CURSOR_SCROLL when you prepare the SQL statement with Doctrine_Adapter_Interface->prepare(). integer $cursorOffset For a PDOStatement object representing a scrollable cursor for which the $cursorOrientation parameter is set to Query::HYDRATE_ORI_ABS, this value specifies the absolute number of the row in the result set that shall be fetched.
For a PDOStatement object representing a scrollable cursor for which the $cursorOrientation parameter is set to Query::HYDRATE_ORI_REL, this value specifies the row to fetch relative to the cursor position before PDOStatement->fetch() was called.
- Retorna
- mixed
Implementado em DB2Statement, OCI8Statement e Statement.
◆ fetchAll()
| fetchAll | ( | $fetchStyle = PDO::FETCH_BOTH | ) |
Returns an array containing all of the result set rows
- Parâmetros
-
integer $fetchStyle Controls how the next row will be returned to the caller. This value must be one of the Query::HYDRATE_* constants, defaulting to Query::HYDRATE_BOTH integer $columnIndex Returns the indicated 0-indexed column when the value of $fetchStyle is Query::HYDRATE_COLUMN. Defaults to 0.
- Retorna
- array
Implementado em DB2Statement e OCI8Statement.
◆ fetchColumn()
| fetchColumn | ( | $columnIndex = 0 | ) |
fetchColumn Returns a single column from the next row of a result set or FALSE if there are no more rows.
- Parâmetros
-
integer $columnIndex 0-indexed number of the column you wish to retrieve from the row. If no value is supplied, PDOStatement->fetchColumn() fetches the first column.
- Retorna
- string returns a single column in the next row of a result set.
Implementado em DB2Statement, OCI8Statement e Statement.
◆ rowCount()
| rowCount | ( | ) |
rowCount rowCount() 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.
- Retorna
- integer Returns the number of rows.
Implementado em DB2Statement, OCI8Statement e Statement.
A documentação para este interface foi gerada a partir do seguinte ficheiro:
- /var/docker/solisge-devel/www/solisge/miolo20/classes/extensions/doctrine-dbal/Doctrine/DBAL/Driver/Statement.php
