Update resultset

Question

Update resultset

Dylan Anderson Dec '13

Created Dec '13	Last Reply Dec '13	Replies 1	Views 1411	Votes 0

Dylan Anderson 125.8k

Dec '13

Looking at the documentation, a resultset should have an update() function I should be able to use like:

public function initialize(){
    $this->hasMany('session_id','Store\Model\ItemHold','session_id',['alias'=>'ItemHold']);
}
...
public function updateHold(){
    $this->ItemHold->update(['date'=>date(DATE_MYSQL)]);
}

However, I get an error saying the function isn't found. Looking at the documentation for the class, there is no mention of the update() function.

So, does it exist? Is there any way to update every record in a resultset?

Eike · Answer 1 · 2013-12-06T01:25:35-07:00

As you relate the ItemHold as a hasMany relationship you get a resultsetInterface by calling $this->ItemHold. So to update every record you have to loop and update.

foreach ($this->ItemHold as $itemHold) {
    $itemHold->update(['date'=>date(DATE_MYSQL)]);
}

I didn't try this ;)

If there is a solution for your last qustion let us know :)

Dylan Anderson · Answer 2 · 2013-12-06T14:19:00-07:00

The documentation clearly shows though, that the update() function is available on the ResultSet: https://docs.phalcon.io/en/latest/reference/models.html#updating-related-records