How to fetch results in an array with ZF2

Question

I am trying to get some distinct values from DB with ZF2 using Tablegateway.

    $select = $this->sql->select($tableGateway->getTable());

    $select->columns(array('city'));
    $select->quantifier('DISTINCT');

    $stm = $this->sql->prepareStatementForSqlObject($select);
    $res = $stm->execute();
    return $res;

This is returning an Iterate object, and I would like to have all the cities in an array. How can I do this ?

Answer 1

// whatever $select

$stm = $this->sql->prepareStatementForSqlObject($select);
$res = $stm->execute();

$resultSet = new \Zend\Db\ResultSet\ResultSet;
$resultSet->initialize($res);

foreach ($resultSet->toArray() as $row) {
    // ...
}