public function DatabaseStatementInterface::fetchAllAssoc

You are here

7 database.inc public DatabaseStatementInterface::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 set for the query will be used.

Return value

An associative array, or an empty array if there is no result set.

3 methods override DatabaseStatementInterface::fetchAllAssoc()
DatabaseStatementBase::fetchAllAssoc in includes/database/database.inc
Returns the result set as an associative array keyed by the given field.
DatabaseStatementEmpty::fetchAllAssoc in includes/database/database.inc
Returns the result set as an associative array keyed by the given field.
DatabaseStatementPrefetch::fetchAllAssoc in includes/database/prefetch.inc
Returns the result set as an associative array keyed by the given field.

File

includes/database/database.inc, line 2123
Core systems for the database layer.

Class

DatabaseStatementInterface
Represents a prepared statement.

Code

public function fetchAllAssoc($key, $fetch = NULL);

Comments

See the other DatabaseStatementInterface methods here:
http://api.drupal.org/api/drupal/includes!database!database.inc/interfac...

For more info on available syntax of the $fetch variable see: http://php.net/manual/en/pdostatement.fetch.php