How to update an object in an array in a mongodb collection (php)?

Question

PHP

I have an object in the collection:

{
  _id:{},
  name: 'name',
  someArray: [{
    id: 234,
    info: 'some info'
  }, {
    id: 567,
    info: 'other info'
  }]
}

For example, I need to change info in an object with id 567, what is the best way to do this? It is possible to find an object in an array, but not to update it. I use puff as a language. Thank you!

Answer 1

Lots of options. For example, updating with a search query:

$retval = $col->findAndModify(
     ["name" => "name"],
     ['$set' => ['someArray.0.info' => 'update info']],
);

Or if the processing is significant:

$doc = $col->find(["name" => "name"]);
$doc['someArray'][0]['info'] = 'update info';
$col->save($doc);