MongoDB unexpected query result

Question

So I'm learning MongoDB and everything was working fine until I wanted to query and discovered that it returns an array that does not work the way I'm used to. Take the example:

$cursor = $collection->find(array('game' => 'Borderlands 2'));

$array = iterator_to_array($cursor);

So far so good, but then I wanted to get a single value to add dynamically to a page:

The game is: <?php echo $array['game'] ?>

And only errors followed. I tried tons of things but then I var_dump it and found that the array is contained under a ID/index array, so this worked:

<?php echo $array["5138225097777c4014000001"]["game"] ?>

I couldn't find any explanation around. Though I understand now how it works, I'm not sure if this is a mistake I made when adding the values to the collection or if I'm missing something. Thanks!!

Munim · Accepted Answer · 2013-03-07 06:36:38Z

2

This is because find returns an array of results(and each result is converted to an array). Hence you have an array of results with the Mongo ObjectId as the key in the array. Use findOne if you want to get just one result.

answered Mar 7, 2013 at 6:36

Munim

6,5802 gold badges37 silver badges44 bronze badges

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

Comments

Nanhe Kumar · Accepted Answer · 2013-03-07 06:48:55Z

1

$cursor = $collection->find(array('game' => 'Borderlands 2'));
while ($document = $cursor->getNext()){
      echo $document['game'];
}

answered Mar 7, 2013 at 6:48

Nanhe Kumar

16.4k5 gold badges84 silver badges72 bronze badges

Collectives™ on Stack Overflow

MongoDB unexpected query result

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related