PHP MongoDB Nested Document Search

Question

I have a nested Document which have some language dependent content and I want to search if content have data for specific language and query should return me content else false.

I tried this query option

$data = $collection->findOne(array('original'=>'What is this', 'translation.language'=>'english') );

I am expecting this result:

{
       "language": "english",
       "quote": "What is this"
}

but above query return both language content. Can anyone please share some code also regarding saving and updating data using PHP

My collection:

{
   "_id": ObjectId("56a8844bc56760810e483815"),
   "language": "english",
   "original_key": "What is this",
   "translation": [
     {
       "language": "english",
       "quote": "What is this"
    },
     {
       "language": "spanish",
       "quote": "What is this Spanish"
    }
  ]
}

chridam · Accepted Answer · 2016-01-27 11:37:08Z

1

Use the positional $ operator in the projection document of the findOne() method when you only need one particular array element in selected documents:

// search criteria for nested array
$query = array(
    'original' => 'What is this', 
    'translation.language' => 'english'
);

// projection (fields to include)
$projection =  array('_id' => false, 'translation.$' => true);

$result = $collection->findOne($query, $projection);
$data = $result->translation;
var_dump($data);

answered Jan 27, 2016 at 11:37

chridam

104k26 gold badges246 silver badges243 bronze badges

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

1 Comment

Gurveer Over a year ago

Thanks that worked :). Can you also share some code to insert new language data to existing collection ex. inserting Arabic language sub-document into exiting record?

Quicksilver · Accepted Answer · 2016-01-27 11:22:52Z

0

I think you should use mongodb's aggregation pipeline.

This may work. Not tested.

db.collection.aggregate([
    {$unwind :translation},
    {$project: {original_key:true,language:true, quote:true}},
    {$match:{original_key:"What is this", language:"english"}}
]);

answered Jan 27, 2016 at 11:22

Quicksilver

2,7403 gold badges25 silver badges38 bronze badges

Collectives™ on Stack Overflow

PHP MongoDB Nested Document Search

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related