push new value to mongodb inner array - mongodb/php

Question

i have this document in mongo:

{
   "_id": ObjectId("4d0b9c7a8b012fe287547157"),
   "done_by": ["1"]
}

and i want to add another value to "done_by" field, so my expected document will be::

{
   "_id": ObjectId("4d0b9c7a8b012fe287547157"),
   "done_by": ["1","2","3"]
}

i try this:

$conn = new Mongo();
$q = $conn->server->gameQueue;
$id = new MongoId("4d0b9c7a8b012fe287547157");
$q->update(array("_id"=>$id),array('$push' => array("done_by","2")));

but nothing happens, anyone know how to do this?

Justin Jenkins · Accepted Answer · 2011-01-09 22:52:57Z

43

Since neither of these answers are actually telling you what's wrong here ...

$conn = new Mongo();
$q = $conn->server->gameQueue;
$id = new MongoId("4d0b9c7a8b012fe287547157");
$q->update(array("_id"=>$id),array('$push' => array("done_by","2")));

There is a problem with your $push statement, you are not pushing "done_by" with a value of "2" you are actually sending "done_by" and "2" ...

Here is the issue ...

array('$push' => array("done_by","2"))

This should have a => not a ,

array('$push' => array("done_by" => "2"))

However, note that every time you run this it will insert another "2" if you want MongoDB to only inset "2" if it doesn't already exist in "done_by" then you should use $addToSet ...

array('$addToSet' => array("done_by" => "2"))

This statement won't add 2 everytime, only the first time.

answered Jan 9, 2011 at 22:52

Justin Jenkins

27.2k6 gold badges71 silver badges1.3k bronze badges

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

Comments

Bob · Accepted Answer · 2011-01-09 22:12:59Z

4

$filter = array('_id'=>$id));
$update = array('$push'=>array('done_by'=>'2'));
$q->update($filter,$update);

answered Jan 9, 2011 at 22:12

Bob

6711 gold badge7 silver badges12 bronze badges

Comments

chx · Accepted Answer · 2011-01-09 21:14:21Z

2

$push => array('done_by' => '2')

So says the manual: { $push : { field : value } }

answered Jan 9, 2011 at 21:14

chx

11.9k8 gold badges64 silver badges144 bronze badges

Comments

Graham · Accepted Answer · 2018-02-05 05:13:36Z

0

$filter = array('_id'=>$id));
$update = array('$addToSet'=>array('done_by'=>'2'));
$q->update($filter,$update);

When you need to update use $addToSet so you avoid duplicate inserts which leads to multiple entries.

edited Feb 5, 2018 at 5:13

Graham

7,86020 gold badges67 silver badges92 bronze badges

answered Feb 5, 2018 at 5:05

CKL

11 bronze badge

Comments

Kirti Pawar · Accepted Answer · 2014-04-09 07:33:38Z

-1

u can use as this :

$conn = new Mongo();
$q = $conn->server->gameQueue;
$id = new MongoId("4d0b9c7a8b012fe287547157");
$q->update(array("_id"=>$id),array('$addToSet' => array("done_by","2")));

answered Apr 9, 2014 at 7:33

Kirti Pawar

893 bronze badges

Collectives™ on Stack Overflow

push new value to mongodb inner array - mongodb/php

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related