PHP mongoDB列出具有相同字段值的用户

Question

Using PHP and MongoClient, I'm trying to figure out how to list users in one organization.

I can list all users from all organizations, but I only want to list users from one organization.

How do I filter the documents like this?

My document structure is simple:

{
    "_id" : ObjectId("56fd6a77768d8864028b4578"),
    "name" : "Jack Daniels",
    "email" : "[e-mail]",
    "manager" : "John doe",
    "password" : "$2y$10$cec5pzCghhhRdwPVnT/t4.EssfIbqighVqpZSa3jWPRV4gdfXUGDu",
    "organization" : "Jane's Jeans"
}

Here is my code where I'm trying to only get results related to one organization:

<optgroup label="Employees">
<?php
     $cursor = $collection->find($curr_org);
     foreach($cursor as $curr_org) {
          echo '<option name="name">';
               echo $curr_org['name'];
          echo '</option>';
     }
?>
</optgroup>

$curr_org contains the organization name.

Removing $curr_org from find() displays all user from all organizations.

Thanks for your help.

Answer 1

You need to pass proper argument to ->find:

$cursor = $collection->find(['organization' => $curr_org]);

For more details you can check out documentation