MongoDB & PHP | How to add object into existing document?

Question

I am very new to MongoDB and PHP and I am trying to add an object into an already existing document. The problem is that I am seeing the $push variable being used a lot, but can't seem to get it working on my own project.

My Document

{
    "_id": {
        "$oid": "622dfd21f8976876e162c303"
    },
    "name": "testuser",
    "password": "1234"
}

Lets say this is a document inside my collection users. I want to add an object that is called domains with some data inside that object like below:

"domains": {
        "name": "example.com"
}

I have tried a bunch of different things, but they do not seem to work. What I tried: I have tried doing to like this:

$doc = array(
    "domains" => array("name": "nu.nl")
);

$collection->insert($doc);

And like this:

$insertOneResult = $collection->updateOne(
    {"name" : "testuser"},
    '$push': {"domains": {"name": "example.com"}}
);

But they both do not work. Can anyone help me with this problem or comment a link which would help me with this problem? Thanks in advance!

rickhg12hs · Accepted Answer · 2022-03-14 09:02:11Z

1

You were really close!

db.users.update({
  "name": "testuser"
},
{
  "$push": {
    "domains": {
      "name": "example.com"
    }
  }
})

Try it on mongoplayground.net.

I haven't used php since the ancient gforge days, but my guess at using the php connector would be (corrections welcome!):

<?php

$collection = (new MongoDB\Client)->test->users;

$updateResult = $collection->updateOne(
    ['name' => 'testuser'],
    ['$push' => ['domains' => ['name' => 'example.com']]]
);

printf("Matched %d document(s)\n", $updateResult->getMatchedCount());
printf("Modified %d document(s)\n", $updateResult->getModifiedCount());

edited Mar 14, 2022 at 9:02

answered Mar 14, 2022 at 0:03

rickhg12hs

12k6 gold badges31 silver badges50 bronze badges

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

5 Comments

Coder Over a year ago

How would that look in PHP, since I need to do it in that language?

rickhg12hs Over a year ago

@Coder See answer update for my guess at php.

Coder Over a year ago

I have one more question. What if I want to add an object within the domain object now (so adding an object within an object that is in a document), how would I do that? I cannot seem to figure it out

rickhg12hs Over a year ago

@Coder Probably best to ask a new question showing the doc before/after with what you've tried.

Coder Over a year ago

Did it! Thanks for the tip!

Collectives™ on Stack Overflow

MongoDB & PHP | How to add object into existing document?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest