MongoDB + PHP how to select

Question

Structure :

Collection : merchant > id, name, country

I want to select all name field from this collection, but all the documentation I read says I must specify the name like :

  $name = array('name' => 'test');

  $cursor = $collection->find($name);

PS : Something like

select name from merchant

in sql is enough

Ma'moon Al-Akash · Accepted Answer · 2013-11-27 05:49:15Z

1

Try the following:

db.merchant.find({}, {"name": 1});

Which would be translated to the following PHP code:

$name = array('name' => 1);

Hope this would solve your issue.

answered Nov 27, 2013 at 5:49

Ma'moon Al-Akash

5,4931 gold badge23 silver badges17 bronze badges

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

Comments

Justin Jenkins · Accepted Answer · 2013-11-27 05:51:18Z

0

I think you are confusing the first optional parameter query with the second optional parameter fields ...

public MongoCursor MongoCollection::find ([ array $query = array() [, array $fields = array() ]] )

If you pass basically an empty array for your query (ala *) and name for the fields ... that should work.

$db->collection->find(array(), array("name" => 1));

answered Nov 27, 2013 at 5:51

Justin Jenkins

27.2k6 gold badges71 silver badges1.3k bronze badges

This will return _id field, not name :(