MongoDB - PHP modifying array's object values

Question

I have a field which stores an array of objects. I want to modify the object's "status" value depending on the "id" value the object possesses.

"authors" : [ 
        {
            "id" : "18",
            "first_name" : "Buddhika",
            "last_name" : "Chathuranga",
            "$$hashKey" : "object:35",
            "status" : NumberLong(0)
        }, 
        {
            "id" : "3", // search for this number
            "first_name" : "Pasindu",
            "last_name" : "Priyanath",
            "$$hashKey" : "object:43",
            "status" : NumberLong(0) // modify this to 1
        }
    ],

Sandesh · Accepted Answer · 2016-08-16 10:32:35Z

2

We can leverage positional update in MongoDB to update values inside array.

Mongo Positional Update

Please find script below.

db.authors.update(
{"authors.id": "3"},
{ $set: { "authors.$.status" : NumberLong(1) }} 
)

edited Aug 16, 2016 at 10:32

answered Aug 16, 2016 at 10:17

Sandesh

1,0445 silver badges13 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:22:53Z

0

Update in Mongo DB php:

db.collection.update( criteria, objNew, upsert, multi );

Detail Explanation

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Aug 16, 2016 at 10:09

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

Collectives™ on Stack Overflow

MongoDB - PHP modifying array's object values

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related