Question

I m using MongoDB with PHP s own driver and I have saved multiple arrays under main document. Structure looks like this:

{
 _id: 234234234324,
 accounts: {
    0: {
        enabled: 1,
        name:  asdf 
    },
    1: {
        enabled: 0,
        name:  gfsd 
    }
}

Accounts are removed and added by the user so I have no control over the array key. I need to somehow get all accounts that have enabled: 1. I tried array("accounts.enabled"=>1) but it doesn t work. And suggestions?

Answer 1

In your schema accounts isn t nested array, it s actually complex object, because of this array("accounts.enabled"=>1) will not work (you actually can check only particular element -> array("accounts.0.enabled"=>1)).

解决你的问题,可作如下计划:

{
 _id: 234234234324,
 accounts: [
    {
        enabled: 1,
        name:  asdf ,
        id: 0
    },
    {
        enabled: 0,
        name:  gfsd ,
        id: 1
    }]
}

如果你作出上述改动,你将提出疑问。

友情链接