PHP - MongoDB：使用数组中的字段名称从子文档中检索字段

Question

Consider an Array

$lettersArray = [A,C,E,G]

and my MongoDB Collection has the following structure.

{
    Collection : {
        letters:{
            A:{...},
            B:{...},
            ...
            Z:{...}
        }

    }
}

Consider that the Letter Sub document is a part of a larger collection. Hence I am using Aggregation. Right Now I have tried to project -

['$Collection.letters' => ['$elemMatch' => ['$in' => $lettersArray]]

and also tried

['Letters' => ['$in' => [$lettersArray,'$Collection.letters']]

But it didn't work.

In the End, I want result like the following:

 [
     Collection => [
        letters => [
            A => [...],
            C => [...],
            E => [...],
            G => [...]
        ]
    ]
]

Is there any way to do this?

Answer 1

In PHP you can use array_combine with array_fill to create the empty arrays.

$lettersArray = ['A','C','E','G'];

$letters = array_combine($lettersArray, array_fill(0,count($lettersArray), []));

Array_fill creates an array from index 0, to the count of items in $lettersArray with the contents []

Output:

array(4) {
  ["A"]=>
  array(0) {
  }
  ["C"]=>
  array(0) {
  }
  ["E"]=>
  array(0) {
  }
  ["G"]=>
  array(0) {
  }
}

https://3v4l.org/TeoFv