Zend Framework: How to unset data rows in a Zend_Db_Table_Rowset object

Question

I would like to iterate over the data rows stored in a Zend_Db_Table_Rowset object and then drop/unset some of the rows, if they don't fulfil certain criteria.

I could use toArray() to get only the data rows from the object and then it would be easy to unset the rows I don't need. But since I want to keep my object for further use I don't want to do that.

Of course one solution would be to adjust my query in order to retrieve only what I need, but that's not possible in this scenario. At least I wouldn't know how.

I tried the following which didn't work:

foreach ($rowset as $key => $row)
{
    if (!$condition == satisfied)
    {
        unset($rowset[$key]);
    }
}

And of course it doesn't work, since there is no $rowset[$key]... the data is stored in a subarray [_data:protected] but unset $rowset[_data:protected][$key] didn't work either.

Maybe my conception of a rowset object (or the representation of objects in general) is not mature enough to understand what I'm doing. Any clarification and tips would be welcome!

[EDIT] $row->delete is NOT an option, I don't want to delete the row from the database! I don't want to create an array first, if I wanted to I would just do $rowset->toArray() [/EDIT]

Solution: I ended up doing what I thought I wasn't able too, meaning I integrated everything into the initial query.

Ondrej Machulda · Accepted Answer · 2011-06-13 22:21:24Z

6

Example method for your custom rowset class:

public function removeFromRowset($id) {
    foreach ($this->_rows as $i => $v) {
        if ($v->id == $id) { // found Row we want to remove
            unset($this->_rows[$i]); // delete both rowset
            unset($this->_data[$i]); // and original data
            break; // not necessary to iterate any more
        }
    }
    $this->_data = array_values($this->_data); // reindex both arrays (otherwise it breaks foreach etc.)
    $this->_rows = array_values($this->_rows);
    $this->_count = count($this->_data); // don't forget to update items count!
}

It iterate through your Rowset, finds Row according to its id (supposing "id" is unique identifier) and than remove it from the Rowset.

Please note this doesn't delete the row from database, it just removes it from the Rowset!

edited Jun 13, 2011 at 22:21

answered Jun 13, 2011 at 21:30

Ondrej Machulda

1,0191 gold badge14 silver badges25 bronze badges

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

Comments

David Snabel-Caunt · Accepted Answer · 2009-04-18 21:38:36Z

4

You could use a custom Rowset class

This class would have then access to the protected $_rows stored internally, and you could add a public method to applying your filtering

answered Apr 18, 2009 at 21:38

David Snabel-Caunt

58.4k13 gold badges118 silver badges132 bronze badges

1 Comment

markus Over a year ago

I ended up doing what I thought I wasn't able too, meaning I integrated everything into the query. But thanks for the custom rowset input which I will certainly need at one point.

smack0007 · Accepted Answer · 2009-04-18 17:41:04Z

1

I don't know that there is a way to do this. You could first create an array and then modify the array.

$rows = array();
foreach($rowset as $row)
{
     $rows[$row->id] = $row;
}

foreach ($rows as $key => $row)
{
     if(!$condition == satisfied)
     {
         unset($rows[$key]);
     }
}

Not the most efficient thing to do but it works.

answered Apr 18, 2009 at 17:41

smack0007

11.4k8 gold badges45 silver badges48 bronze badges

3 Comments

markus Over a year ago

nope, I need the object to be healthy. and creating an array goes easy with $rowset->toArray()

smack0007 Over a year ago

$rowset->toArray() doesn't produce row objects. It returns the whole rowset as an array. That's why I didn't use it.

smack0007 Over a year ago

The custom rowset class above is probably your best bet.

gmcrist · Accepted Answer · 2009-04-18 17:48:14Z

-2

You can also use the delete() method on the individual row object.

foreach ($rowset as $row)
{
    if (!$condition == satisfied)
    {
       $row->delete();
    }
}

answered Apr 18, 2009 at 17:48

gmcrist

1783 bronze badges

3 Comments

Darryl E. Clarke Over a year ago

delete is destructive. The row will be deleted from the table.

markus Over a year ago

maybe I wasn't clear but I don't want to delete the row from the table, I just want to remove it from the object!!

gmcrist Over a year ago

Please accept my apologies for not understanding what you were wanting to do. As dcaunt suggested, and smack0007 affirmed, using a custom rowset would be the best option.

Collectives™ on Stack Overflow

Zend Framework: How to unset data rows in a Zend_Db_Table_Rowset object

4 Answers 4

Comments

1 Comment

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related