MongoDB and the PHP driver

Question

There is a command line syntax in mongo that goes something like this

db.collection.find('nested_array.some_nested_key':'some_nested_value',{'nested_array.$' => 1})

This finds and returns just the "nested_array(s)" that match the criteria and not the entire object.

Problem is I can't seem to find the ".$" equivalent in the php driver. anyone have any ideas?

chridam · Accepted Answer · 2015-11-10 15:48:52Z

2

The methods in the MongoDB PHP driver are similar to their mongo shell counterparts, so the projection with the $ positional operator also uses associative arrays to map fields to MongoDB queries. Something like this will produce the desired result:

<?php
    $m = new MongoClient();
    $db = $m->selectDB("test");
    $collection = new MongoCollection($db, "collection_name");

    // search for nested array
    $fruitQuery = array("nested_array.some_nested_key" => "some_nested_value");

    // projection (fields to include)
    $projection =  array("_id" => false, "nested_array.$" => true);

    $cursor = $collection->find($query, $projection);
    foreach ($cursor as $doc) {
        var_dump($doc);
    }
?>

answered Nov 10, 2015 at 15:48

chridam

104k26 gold badges246 silver badges243 bronze badges

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

Collectives™ on Stack Overflow

MongoDB and the PHP driver

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