You are currently viewing the 1.0 branch api documentation. Switch to 1.1

1.0 Doctrine_Connection_Statement

Doctrine Connection Statement

Method Summary

Returns Name Description
boolean bindColumn
boolean bindParam Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was use to prepare the statement. Unlike Doctrine_Adapter_Statement_Interface->bindValue(), the variable is bound as a reference and will only be eva
boolean bindValue
boolean closeCursor
integer columnCount
string errorCode
array errorInfo
boolean execute 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
mixed fetch
array fetchAll
string fetchColumn
mixed fetchObject Fetches the next row and returns it as an object. This function is an alternative to Doctrine_Adapter_Statement_Interface->fetch() with Doctrine::FETCH_CLASS or Doctrine::FETCH_OBJ style.
mixed getAttribute
array getColumnMeta
getConnection
getQuery
getStatement
boolean nextRowset Some database servers support stored procedures that return more than one rowset (also known as a result set). The nextRowset() method enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a
integer rowCount 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
boolean setAttribute
boolean setFetchMode
__construct

Method Details

  • $column Number of the column (1-indexed) or name of the column in the result set. If using the column name, be aware that the name should match the case of the column, as returned by the driver.
    $param Name of the PHP variable to which the column will be bound.
    $type Data type of the parameter, specified by the Doctrine::PARAM_* constants.

    (boolean) bindColumn($column, $param, $type = null)

    bindColumn Bind a column to a PHP variable

    Doctrine_Connection_Statement


  • $type Explicit data type for the parameter using the Doctrine::PARAM_* constants. To return an INOUT parameter from a stored procedure, use the bitwise OR operator to set the Doctrine::PARAM_INPUT_OUTPUT bits f
    $length Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly set the length.
    $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-inde
    $variable Name of the PHP variable to bind to the SQL statement parameter.

    (boolean) bindParam($column, [[[amp]]]$variable, $type = null, $length = null, $driverOptions = array(), $param, $variable)

    Binds a PHP variable to a corresponding named or question mark placeholder in the SQL statement that was use to prepare the statement. Unlike Doctrine_Adapter_Statement_Interface->bindValue(), the variable is bound as a reference and will only be eva

    Doctrine_Connection_Statement


  • $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-inde
    $value The value to bind to the parameter.
    $type Explicit data type for the parameter using the Doctrine::PARAM_* constants.

    (boolean) bindValue($param, $value, $type = null)

    bindValue Binds a value to a corresponding named or question mark placeholder in the SQL statement that was use to prepare the statement.

    Doctrine_Connection_Statement


  • (boolean) closeCursor()

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

    Doctrine_Connection_Statement


  • (integer) columnCount()

    columnCount Returns the number of columns in the result set

    Doctrine_Connection_Statement


  • (string) errorCode()

    errorCode Fetch the SQLSTATE associated with the last operation on the statement handle

    Doctrine_Connection_Statement


  • (array) errorInfo()

    errorInfo Fetch extended error information associated with the last operation on the statement handle

    Doctrine_Connection_Statement


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

    (boolean) execute($params = null)

    execute 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

    Doctrine_Connection_Statement


  • $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 Doctrine::FETCH_ORI_* constants, defaultin
    $cursorOffset

    For a Doctrine_Adapter_Statement_Interface object representing a scrollable cursor for which the $cursorOrientation parameter is set to Doctrine::FETCH_ORI_ABS, this value specifies

    $fetchStyle Controls how the next row will be returned to the caller. This value must be one of the Doctrine::FETCH_* constants, defaulting to Doctrine::FETCH_BOTH

    (mixed) fetch($fetchMode = Doctrine::FETCH_BOTH, $cursorOrientation = Doctrine::FETCH_ORI_NEXT, $cursorOffset = null, $fetchStyle)


  • $fetchMode Controls how the next row will be returned to the caller. This value must be one of the Doctrine::FETCH_* constants, defaulting to Doctrine::FETCH_BOTH
    $columnIndex Returns the indicated 0-indexed column when the value of $fetchStyle is Doctrine::FETCH_COLUMN. Defaults to 0.

    (array) fetchAll($fetchMode = Doctrine::FETCH_BOTH, $columnIndex = null)

    fetchAll Returns an array containing all of the result set rows


  • $columnIndex 0-indexed number of the column you wish to retrieve from the row. If no value is supplied, Doctrine_Adapter_Statement_Interface->fetchColumn() fetches the first column.

    (string) fetchColumn($columnIndex)

    fetchColumn Returns a single column from the next row of a result set or FALSE if there are no more rows.

    Doctrine_Connection_Statement


  • $className Name of the created class, defaults to stdClass.
    $args Elements of this array are passed to the constructor.

    (mixed) fetchObject($className = 'stdClass', $args = array())

    fetchObject Fetches the next row and returns it as an object.

    Fetches the next row and returns it as an object. This function is an alternative to Doctrine_Adapter_Statement_Interface->fetch() with Doctrine::FETCH_CLASS or Doctrine::FETCH_OBJ style.

    Doctrine_Connection_Statement


  • (mixed) getAttribute($attribute)

    getAttribute Retrieve a statement attribute

    Doctrine_Connection_Statement


  • $column The 0-indexed column in the result set.

    (array) getColumnMeta($column)

    getColumnMeta Returns metadata for a column in a result set

    Doctrine_Connection_Statement


  • getConnection()

    getConnection returns the connection object this statement uses


  • getQuery()


  • getStatement()


  • (boolean) nextRowset()

    nextRowset Advances to the next rowset in a multi-rowset statement handle

    Some database servers support stored procedures that return more than one rowset (also known as a result set). The nextRowset() method enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a

    Doctrine_Connection_Statement


  • (integer) 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

    Doctrine_Connection_Statement


  • $value the value of given attribute

    (boolean) setAttribute($attribute, $value)

    setAttribute Set a statement attribute

    Doctrine_Connection_Statement


  • $mode The fetch mode must be one of the Doctrine::FETCH_* constants.

    (boolean) setFetchMode($mode, $arg1 = null, $arg2 = null)

    setFetchMode Set the default fetch mode for this statement

    Doctrine_Connection_Statement


  • $conn Doctrine_Connection object, every connection statement holds an instance of Doctrine_Connection

    __construct(( ) $conn, $stmt)

    constructor