public function DatabaseStatementPrefetch::fetchCol in Drupal 7

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 DatabaseStatementInterface::fetchCol

File

includes/database/prefetch.inc, line 449

Database interface code for engines that need complete control over their result sets. For example, SQLite will prefix some column names by the name of the table. We post-process the data, by renaming the column names using the same convention as…

Class

DatabaseStatementPrefetch

An implementation of DatabaseStatementInterface that prefetches all data.

Code

public function fetchCol($index = 0) {
  if (isset($this->columnNames[$index])) {
    $column = $this->columnNames[$index];
    $result = array();

    // Traverse the array as PHP would have done.
    while (isset($this->currentRow)) {
      $result[] = $this->currentRow[$this->columnNames[$index]];
      $this
        ->next();
    }
    return $result;
  }
  else {
    return array();
  }
}