MongoDB - How to add into object that is inside an array

Question

I am new to MongoDB and PHP and I am trying to make an API. The current problem I have is that I am not able to add an array to an object that is inside an array (of objects). I have tried a lot, but all failed.

This is the document I have so far:

_id:62307ccecabc9c2a2c4563e3
username:"NEWUser"
email:user@mail.com
password:1234
level:1
domainArray:Array
  0:Object
     domainname:"example.com"
     domainvalue:4
  1:Object
     domainname:"facebook.com"
     domainvalue:3

I would like to add an array after domainvalue, but can't seem to do that.

My code:

public function postDomain($domainData){//add user and replace it with testuser
     $data = json_decode(file_get_contents("php://input"), true);
     $collection = $collection = (new MongoDB\Client('mongodb://localhost:27017'))->mydb->users;
     $insertOneResult = $collection->updateOne(
         ["username" => "NEWUser"],
         ['$push' =>["domainArray" => $data]]
     );
}

The $data variable:

{
    "domainname":"twitter.com",
    "domainvalue":2
}

How would I change this code so that there is an array added after domainvalue? I have tried doing things like this:

$insertOneResult = $collection->updateOne(
    ["username" => "NEWUser", "domainArray"],
    ['$push' => ["domainname.$.ouputArray" => array("outputArray")]]
);

But without any luck. Can someone please help me because I am really stuck with this problem? Thanks in advance!

Do you mean like [this](https://mongoplayground.net/p/KK4NUiVlo4k)? — Yong Shun, Mar 16 '22 at 11:12
@YongShun Do you perhaps know how I would achieve that using PHP? — Coder, Mar 16 '22 at 11:15
Not PHP developer. Guess something like this: `$insertOneResult = $collection->updateOne( ["username" => "NEWUser"], ['$set' => ["domainArray.$[].ouputArray" => array("outputArray")]] );` — Yong Shun, Mar 16 '22 at 11:16

score 1 · Accepted Answer · answered Mar 16 '22 at 11:22

To create a new field for the nested documents in an array, you need the $set operator and $[] all positional operator.

db.collection.update({
  "username": "NEWUser"
},
{
  "$set": {
    "domainArray.$[].ouputArray": []  // Array
  }
})

Sample Mongo Playground

While for PHP syntax:

$insertOneResult = $collection->updateOne(
    ["username" => "NEWUser"],     
    ['$set' => ["domainArray.$[].ouputArray" => array("outputArray")]]
);

MongoDB - How to add into object that is inside an array

1 Answers1