ZF2：TableGateway ResultSet到JSON

Question

I am trying to return data from my database to JSON in Zend Framework 2. I am using a TableGateway right now and it returns a ResultSet. But the JsonModel cannot show the resultset. So is there a way to convert it, or is there an other way to access my database?

The IndexAction in the HomeController

public function indexAction()
{
    return new JsonModel(array(
        'posts' => $posts,
        'resources' => $resources,
        'style' => $style,
        'imgStyle' => $imgStyle,
        'success' => true,
    ));
}

The function that returns the resultset

public function fetchAll()
{
    $resultSet = $this->tableGateway->select(function (Select $select) {
        $select->order('date DESC');
    });
    return $resultSet;
}

Answer 1

Considering you have already done this in module.config.php:

'view_manager' => array(
    'strategies' => array(
        'ViewJsonStrategy',
    ),
),

My next suggestion would be to convert the result to array.

$resultSet->toArray();

OR

$return = array();

foreach( $resultSet as $r )
    $return[]=$r;

Your return new JsonModel, is correct.