PHP MongoDB find nested element

Question

How can I do a select for all documents that have a parent.id that is equal to 3? I try doing this.parents.id == 3, but it doesn't seem to be working...

[parents] => Array (
    [0] => Array (
        [id] => 1
        [title] => Folder 1
    )
    [1] => Array (
        [id] => 3
        [title] => Folder 2
    )
)

and db.collectionName.find({'parents.id':3}) doesn't work either ? — Frederik Eychenié
– Frederik Eychenié, Commented Sep 26, 2011 at 9:43
and the php version : $collection->find(array('parents.id'=>3)) — Frederik Eychenié
– Frederik Eychenié, Commented Sep 26, 2011 at 9:45
PHP version worked - thank you! I'm a mongo newbie, sorry :P — Eric Simons
– Eric Simons, Commented Sep 26, 2011 at 21:29

Gates VP · Accepted Answer · 2011-09-26 20:56:15Z

1

OK, so the PHP input is actually unclear. The PHP you provided could be one of the following JSON objects:

Version 1:

{ parents: 
  [ 
    { id: 1, title: "Folder 1" }, 
    { id: 3, title: "Folder 2" } 
  ] }

Version 2:

{ parents: 
  { 0: { id: 1, title: "Folder 1" }, 
    1: { id: 3, title: "Folder 2" } 
} }

If you do find({'parents.id':3}) on version 1, this will work.

If you do find({'parents.id':3}) on version 2, this will not work.

The difference is not clear in PHP, so use the command-line and double-check.

answered Sep 26, 2011 at 20:56

Gates VP

45.3k11 gold badges108 silver badges108 bronze badges

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

2 Comments

Eric Simons Over a year ago

Thanks! As Frederik posted above, the correct code in PHP is this: $collection->find(array('parents.id'=>3))

Eric Simons Over a year ago

sorry it took so long, have been off the grid for a week :)

Collectives™ on Stack Overflow

PHP MongoDB find nested element

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related