MongoDB/PHP: update individual value of an array

Question

Greetings,

I have the following mongodb object:

{
   "_id": ObjectId("4d0b9c7a8b012fe287547157"),
   "messages": {
     "0": {
       "toUname": "Eamorr3",
       "fromUname": "Eamorr2",
       "time": 1292606586,
       "id": "j7zwr2hzx14d3sucmvp5",
       "subject": "asdf",
       "message": "asdf",
       "read": 0
    }
  },
   "uname": "Eamorr3"
}

How do I set "read" to 1 in PHP?

Here's what I've tried sofar to no avail:

update(array('uname'=>$uname),array('$set'=>array('messages'=>array('read')=>'1')));

I'm totally stuck. Any help much appreciated.

Many thanks in advance,

ceejayoz · Accepted Answer · 2010-12-17 17:39:24Z

2

I believe it's either

update(array('uname'=>$uname),array('$set'=>array('messages.0'=>array('read')=>'1')));

or

update(array('uname'=>$uname),array('$set'=>array('messages.0.read'=>1));

answered Dec 17, 2010 at 17:39

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

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

2 Comments

Eamorr Over a year ago

Hi, thanks for your answer! Do you know how I can search through the array by specifying the id (j7zwr2hzx14d3sucmvp5 in this case) rather than "messages.0". I meant to ask that in the original question...

ceejayoz Over a year ago

Take a look at the "The Positional Operator" section at the bottom of php.net/manual/en/mongo.updates.php - looks like what you're looking for.

Collectives™ on Stack Overflow

MongoDB/PHP: update individual value of an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related