PHP MongoDb update $in array

Question

From the MongoDB command line I can do

db.user.update({userid: {$in: [435707147,88513850,466518582]}},{$unset: {f1 : 1}})

Which will remove the variable f1 from all user objects in the DB. How would you translate that to PHP syntax?

I the following runs with no error, but no changes are made to the DB.

$db->user->update(array("userid"=>array('$in'=>$ids)), 
    array('$unset'=> array("f1"=>1)));

Eve Freeman · Accepted Answer · 2012-01-25 22:21:25Z

2

Do you set $ids = array(435707147, 88513850, 466518582); ?

You probably also need to say it with 'multiple'=>true to update all of them at once:

$db->user->update(array("userid"=>array('$in'=>$ids)), 
   array('$unset'=> array("f1"=>true)), 
   array('multiple'=>true));

edited Jan 25, 2012 at 22:21

answered Jan 25, 2012 at 21:43

Eve Freeman

33.3k5 gold badges89 silver badges104 bronze badges

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

3 Comments

Lloyd Over a year ago

Should have added that, yes $ids is an array. I have tried with multiple and without. Pretty stumped here.

Eve Freeman Over a year ago

Try doing a simple find with the $in to see if you can get it to work first. I updated my $unset array to use true instead of 1--not sure if that will help.

Lloyd Over a year ago

I was able to the above to work in a controlled script file. Thanks so much.

vrtx · Accepted Answer · 2012-01-26 00:58:38Z

0

Wes is correct, you will likely want to use 'multiple'=>true. If the the $in query alone still doesn't return any results, make sure the elements in $ids are integers and not strings (try calling gettype() on each element).

answered Jan 26, 2012 at 0:58

vrtx

2,6461 gold badge16 silver badges3 bronze badges

Collectives™ on Stack Overflow

PHP MongoDb update $in array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related