Zend_Db_Table_Rowset to array of objects

Question

I am not looking for $myRowset->toArray(); because I want to get an array of objects.

What I want to do is to be able to merge $myRowset with an array of objects.

$myOtherArray = [new Foo(), new Bar()];
$array = array_merge($myRowset, $myOtherArray);

With a Zend_Db_Table_Rowset, it is impossible. Using $myRowset->toArray(); doesn't work too because I need an array of objects.

Edit - Example of code doing what I want, but I'm looking for a better solution if it exists:

// Convert the Zend_Db_Table_Rowset to an array of Zend_Db_Table_Row
$myRowset = $dbTable->fetchAll();
$rowArray = array();
foreach ($myRowset as $row) {
    $rowArray[] = $row;
}

// Merge with other array of objects
$myOtherArray = [new Foo(), new Bar()];

$finalArray = array_merge($rowArray, $myOtherArray);

I'm not sure how Zend is supposed to know what object you want to instantiate from the data returned from the database. Other than foreaching over the array and instantiating each object yourself, I don't think what you want is possible, unless by object you just mean stdClass objects which you can make by casting an array to object. But you really don't want to do that, for a lot of reasons. — GordonM
– GordonM, Commented Jun 24, 2012 at 18:37
@GordonM No need for instanciating anything, the rowset returned by the query contains subtypes of Zend_Db_Table_Row (my model objects). See my edit for better understanding. — Matthieu Napoli
– Matthieu Napoli, Commented Jun 24, 2012 at 18:51
I think the solution you have already is pretty much your only option. You could extend Zend_Db_Table_Rowset with a method to return the array of rows to make it easier to manage but that's about it. — GordonM
– GordonM, Commented Jun 24, 2012 at 18:57
Why not use the zend fetch mode? framework.zend.com/manual/1.12/en/… if you were to do $db->setFetchMode(Zend_Db::FETCH_OBJ); then any fetchAll() statement after that will return an array of objects... — Krzysztof Karski
– Krzysztof Karski, Commented Aug 29, 2016 at 7:43

Matthieu Napoli · Accepted Answer · 2012-06-25 17:56:59Z

3

Here is my "cleanest" solution: I override Zend_Db_Table_Rowset

class My_RowSet extends Zend_Db_Table_Rowset {

    public function rowArray() {
        $rowArray = array();
        foreach ($this as $row) {
            $rowArray[] = $row;
        }
        return $rowArray;
    }

}

and Zend_Db_Table:

abstract class My_Db_Table extends Zend_Db_Table {

    protected $_rowsetClass = 'My_RowSet';

}

Now I can do:

$myRowset = $dbTable->fetchAll();
$rowArray = $myRowset->rowArray();

answered Jun 25, 2012 at 17:56

Matthieu Napoli

50k49 gold badges188 silver badges273 bronze badges

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

1 Comment

PowerKiKi Over a year ago

Not as straightforward as I wished, but still clean enough to be used in my opinion, thanks

Tomáš Fejfar · Accepted Answer · 2021-09-27 14:31:43Z

1

You can use

/** @var Zend_Db_Table_Row[] $rows */
$rows = iterator_to_array($rowset)

answered Sep 27, 2021 at 14:31

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

3 Comments

Matthieu Napoli Over a year ago

Almost 10 years later! Nice :)

Tomáš Fejfar Over a year ago

Still using this daily! :) Not sure if that's great or sad :D

Tomáš Fejfar Over a year ago

BTW: Also working on this to get rid of the docblock github.com/tomasfejfar/phpstan-zf1

Collectives™ on Stack Overflow

Zend_Db_Table_Rowset to array of objects

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related