MongoDB increment multiple document array values in PHP

Question

I want to increment all documents in a collection that contain a given nested array value. My objects each contain an "order" array with key:number values.

{
    _id: ...,
    order : array(
        foo: 34
    )
}

However, I can't figure out the correct MongoDB Query using the PHP MongoDB Native Driver.

    // Update all existing items with an order greater than this number
    $number = 2;

    $result = $collection->update(
        array("order" => array('foo' => array('$gt' => $number))),
        array('$inc' => array('order' => array('foo' => 1))),
        array("safe" => true)
    );

Chien-Wei Huang · Accepted Answer · 2012-10-28 07:58:20Z

1

This is the PHP version of your MongoDB query and I add a multiple option additionally.

$collection->update(array('order.foo'=>array('$gt'=>2)), array('$inc' => array('order.foo'=>1)), array('multiple'=>true, 'safe'=>true));

answered Oct 28, 2012 at 7:58

Chien-Wei Huang

1,8611 gold badge18 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

MongoDB increment multiple document array values in PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related