Zend framework 2 \Zend\Db\ResultSet\ResultSet->toArray() doe not return records

Question

I'm simply trying to fetch all records in a given table by extending Zend AbstractTableGateway and making use of inherited select() function. this select() function returns type Zend ResultSet however I'm not able get an array of results using toArray().

I get the following message:

Rows as part of this DataSource, with type object cannot be cast to an array

Update

I worked it out

assuming you have extended AbstractTableGateway

$resultSet = $this->select();
foreach($resultSet as $row) { echo $row->yourProperty }

Zend_Db_Result is already having a toArray(). could you please paste your code for reference.framework.zend.com/apidoc/2.0/classes/… — Vijay
– Vijay, Commented Oct 6, 2012 at 7:54
FYI: if you are using a custom array object prototype in the result set, adding a toArray() method to your entity will fix this — Fatmuemoo
– Fatmuemoo, Commented Jan 30, 2013 at 15:43

cglvli · Accepted Answer · 2013-05-30 13:51:37Z

6

You should use HydratingResultSet like this :

class MyClassTable extends AbstractTableGateway
{
    public function __construct(Adapter $adapter)
{
    $this->adapter = $adapter;
    $this->resultSetPrototype = new HydratingResultSet();
    $this->resultSetPrototype->setObjectPrototype(new MyClass());
    $this->initialize();
}

public function fetchAll()
{
    $resultSet = $this->select();
    return $resultSet;
}

public function fetchAllToArray()
{
    $aData = $this->fetchAll()->toArray();
    return $aData;
}

answered May 30, 2013 at 13:51

cglvli

1373 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Schleis · Accepted Answer · 2013-10-25 19:33:47Z

4

You can also try this

$sql = new Sql($adapter);

$select = $sql->select();

$select->from('table');

$statement = $sql->prepareStatementForSqlObject($select); 

$results = $statement->execute();

$resultSet = new ResultSet();
$resultSet->initialize($results);

print_r($resultSet->toArray());

With Zend\Db\ResultSet\ResultSet;

edited Oct 25, 2013 at 19:33

Schleis

44.2k8 gold badges73 silver badges90 bronze badges

answered Sep 30, 2013 at 19:57

Willy Makend

1371 silver badge8 bronze badges

Comments

Gabriel Lucas · Accepted Answer · 2013-02-21 14:31:29Z

3

Just try to use

(array)$resultSet

I've used this sometimes on ZF and works fine.

answered Feb 21, 2013 at 14:31

Gabriel Lucas

1192 silver badges5 bronze badges

1 Comment

NaN Over a year ago

Awesome shortcut. This has saved me a ton of time.

tasmaniski · Accepted Answer · 2015-12-15 10:51:03Z

2

Mine issue was as @Fatmuemoo noted.

If you register your custom object prototype, code eg.

$resultSetPrototype = new ResultSet($entityClassName, new $entityClassName);
$instance->setResultSetPrototype($resultSetPrototype);

you have to implement toArray() method in yout Entity class.

public function toArray()
{
    return get_object_vars($this);
}

answered Dec 15, 2015 at 10:51

tasmaniski

4,9083 gold badges37 silver badges66 bronze badges

Collectives™ on Stack Overflow

Zend framework 2 \Zend\Db\ResultSet\ResultSet->toArray() doe not return records

Update

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Update

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related