MongoDB remove item from array from a selected document

Question

I am developing a web app using Codeigniter and Alex Bilbies MongoDB library. Each user got a document that contains an item called phones which contains an array of phone numbers. How can I pull an item out of the array from the selected users document?

Thankful for all help!

Mongo has support of $pull out of the box: mongodb.org/display/DOCS/Updating#Updating-%24pull — ioseb
– ioseb, Commented Nov 16, 2011 at 13:03

Ramana Gottipati · Accepted Answer · 2012-10-14 18:16:17Z

2

Even I ran into an issue when directly trying to pull a value from an array using Alex Bilbies MongoDB library. This approach works for me, first unsetting the value, and then pulling all nulls.

Hope this helps

$this->mongo_db->where('items', "5678")->unset_field('items.$')->update('mycollection');
$this->mongo_db->pull('items', NULL)->update('mycollection');

answered Oct 14, 2012 at 18:16

Ramana Gottipati

213 bronze badges

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

Comments

ioseb · Accepted Answer · 2011-11-16 13:14:43Z

1

Using MongoDB $pull for removing specific array item from array:

> db.mycollection.insert({user: "test", items: [1234, 5678, 91011]});
> db.mycollection.find()
{ "_id" : ObjectId("4ec3b9af8d1ae67f1fb2b30a"), "user" : "test", "items" : [ 1234, 5678, 91011 ] }
> db.mycollection.update({user: "test"}, {$pull: {items: 5678}});
> db.mycollection.find()
{ "_id" : ObjectId("4ec3b9af8d1ae67f1fb2b30a"), "items" : [ 1234, 91011 ], "user" : "test" }

answered Nov 16, 2011 at 13:14

ioseb

17k3 gold badges37 silver badges31 bronze badges

4 Comments

Jonathan Clark Over a year ago

Nice. But how can I pull from an array of a specific document?

ioseb Over a year ago

well, when using modifier operators you do not need to specify whole document you need to specify only criteria and specify field which you need to modify. In terms of PHP this would look like: $coll->update(array('username' => 'jamesbond', array('$pull' => array('items' => 5678)));

Jonathan Clark Over a year ago

Ok. But what does that look like using Alex Bilbies library? This does not work: $this -> mongo_db -> pull ('items', $pull) -> update ('market.carts', $query);

ioseb Over a year ago

Sorry I do not know anything about this library :( solutions I posted work in mongo shell and PHP driver.

Collectives™ on Stack Overflow

MongoDB remove item from array from a selected document

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related