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 ?

If you are getting **Zend\Db\ResultSet** then just do `$res->toArray();`. — Indrasinh Bihola, May 17 '16 at 15:43
I am having this error : Call to undefined method Zend\Db\Adapter\Driver\Pdo\Result::toArray() — Franck, May 17 '16 at 15:51
ok I managed to use ResultSet and I can use toArray. Thanks. — Franck, May 17 '16 at 15:54
Here is the url if anyone need it : http://framework.zend.com/manual/current/en/modules/zend.db.result-set.html — Franck, May 17 '16 at 15:55

score 1 · Answer 1 · answered Jan 10 '17 at 20:44

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) {
    // ...
}

answered Jan 10 '17 at 20:44

Edson Horacio Junior

3,033
2
29
50

How to fetch results in an array with ZF2

1 Answers1