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

int $keyIndex: (Optional) The numeric index of the field to use as the array key. Defaults to 0.

int $valueIndex: (optional) The numeric index of the field to use as the array value. Defaults to 1.

Return value

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

1 method overrides ResultBase::fetchAllKeyed()

PrefetchedResult::fetchAllKeyed in core/lib/Drupal/Core/Database/Statement/PrefetchedResult.php

Returns the entire result set as a single associative array.

File

core/lib/Drupal/Core/Database/Statement/ResultBase.php, line 107

Class

ResultBase

Base class for results of a data query language (DQL) statement.

Namespace

Drupal\Core\Database\Statement

Code

public function fetchAllKeyed(int $keyIndex = 0, int $valueIndex = 1) : array {
    $result = [];
    while ($record = $this->fetch(FetchAs::List, [])) {
        $result[$record[$keyIndex]] = $record[$valueIndex];
    }
    return $result;
}

---