public Statement::setFetchMode($mode, $a1 = NULL, $a2 = array()) Sets the default fetch mode for this statement. See http://php.net/manual/pdo.constants.php for the definition of the constants used. Parameters $mode: One of the PDO::FETCH_* constants. $a1: An option depending of the fetch mode specified by $mode: for PDO::FETCH_COLUMN, the index of the column to fetch for PDO::FETCH_CLASS, the name of the class to create for PDO::FETCH_INTO, the object to add the data to $a2: If $mode is PDO

public Statement::fetchField($index = 0) Returns a single field from the next record of a result set. Parameters $index: The numeric index of the field to return. Defaults to the first field. Return value A single field from the next record, or FALSE if there is no next record. Overrides StatementInterface::fetchField File core/lib/Drupal/Core/Database/Statement.php, line 120 Class Statement Default implementation of StatementInterface. Namespace Drupal\Core\Database Code public func

protected Statement::getStatement($query, &$args = array()) The PDO SQLite layer doesn't replace numeric placeholders in queries correctly, and this makes numeric expressions (such as COUNT(*) >= :count) fail. We replace numeric placeholders in the query ourselves to work around this bug. See http://bugs.php.net/bug.php?id=45259 for more details. Overrides StatementPrefetch::getStatement File core/lib/Drupal/Core/Database/Driver/sqlite/Statement.php, line 29 Class Statement SQLite

public Statement::rowCount() Returns the number of rows affected by the last SQL statement. Return value The number of rows affected by the last DELETE, INSERT, or UPDATE statement executed or throws \Drupal\Core\Database\RowCountException if the last executed statement was SELECT. Throws \Drupal\Core\Database\RowCountException Overrides StatementInterface::rowCount File core/lib/Drupal/Core/Database/Statement.php, line 136 Class Statement Default implementation of StatementInterface.

public Statement::fetchAssoc() Fetches the next row and returns it as an associative array. This method corresponds to PDOStatement::fetchObject(), but for associative arrays. For some reason PDOStatement does not have a corresponding array helper method, so one is added. Return value An associative array, or FALSE if there is no next row. Overrides StatementInterface::fetchAssoc File core/lib/Drupal/Core/Database/Statement.php, line 128 Class Statement Default implementation of Statement

public Statement::fetchAll($mode = NULL, $column_index = NULL, $constructor_arguments = NULL) Returns an array containing all of the result set rows. Parameters $mode: One of the PDO::FETCH_* constants. $column_index: If $mode is PDO::FETCH_COLUMN, the index of the column to fetch. $constructor_arguments: If $mode is PDO::FETCH_CLASS, the arguments to pass to the constructor. Return value An array of results. Overrides StatementInterface::fetchAll File core/lib/Drupal/Core/Database/Statement.

public Statement::fetchCol($index = 0) Returns an entire single column of a result set as an indexed array. Note that this method will run the result set to the end. Parameters $index: The index of the column number to fetch. Return value An indexed array, or an empty array if there is no result set. Overrides StatementInterface::fetchCol File core/lib/Drupal/Core/Database/Statement.php, line 79 Class Statement Default implementation of StatementInterface. Namespace Drupal\Core\Databa

public Statement::execute($args = array(), $options = array()) Executes a prepared statement Parameters $args: An array of values with as many elements as there are bound parameters in the SQL statement being executed. $options: An array of options for this query. Return value TRUE on success, or FALSE on failure. Overrides StatementPrefetch::execute File core/lib/Drupal/Core/Database/Driver/sqlite/Statement.php, line 88 Class Statement SQLite implementation of \Drupal\Core\Database\Stat

public Statement::fetchAllAssoc($key, $fetch = NULL) Returns the result set as an associative array keyed by the given field. If the given key appears multiple times, later records will overwrite earlier ones. Parameters $key: The name of the field on which to index the array. $fetch: The fetchmode to use. If set to PDO::FETCH_ASSOC, PDO::FETCH_NUM, or PDO::FETCH_BOTH the returned value with be an array of arrays. For any other value it will be an array of objects. By default, the fetch mode s

public Statement::fetchAllKeyed($key_index = 0, $value_index = 1) Returns the entire result set as a single associative array. This method is only useful for two-column result sets. It will return an associative array where the key is one column from the result set and the value is another field. In most cases, the default of the first two columns is appropriate. Note that this method will run the result set to the end. Parameters $key_index: The numeric index of the field to use as the array