After searching on SO, I couldn't find a satisfactory answer to my question related to working with mongodb and php for the past couple of weeks. So here I am seeking help. I have a database where I need to add new data to one of the embedded/nested documents, but I'm struggling to do so.
This is the current structure of my data:
{
"_id" : ObjectId("5ab0dc4fb57dce17e0002c5c"),
"meter" : "meter_2",
"data" : {
"magnitude1" : {
"date" : "05/03/2013 08:13:18",
"value" : 200
},
"magnitude2" : {
"date" : "30/06/2014 23:46:05",
"value" : 126
}
}
}
Now, I'm attempting to add new data to the subdocument magnitude, like this:
{
"_id" : ObjectId("5ab0dc4fb57dce17e0002c5c"),
"meter" : "meter_2",
"data" : {
"magnitude1" : {
"date" : "05/03/2013 08:13:18",
"value" : 200,
"somedata" : "somevalue"
},
}
}
I've tried various approaches, including the one below, but none of them seem to work in inserting the new data.
$center->updateOne(
['_id' => new \MongoDB\BSON\ObjectID('5ab0dc4fb57dce17e0002c5c'), 'data.magnitude1'],
['$set' => ['somedata' => 'somevalue']]
);
If anyone could provide assistance or guidance on this matter, it would be greatly appreciated.