Find documents based on referenced ID in MongoDB & PHP
i've got referenced Users collection object in my MongoDB Items collection. Random Item document looks like this:
ps: to clarify, i really dont want to embed Items into Users collection.Array
(
[_id] => MongoId Object
(
开发者_Python百科 [$id] => 4d3c589378be56a008000000
)
[modified] => 1295800467
[order] => 1
[title] => MyFirstItem
[user] => Array
(
[$ref] => users
[$id] => MongoId Object
(
[$id] => 4d3c55e7a130717c09000012
)
)
)
So i need to find only items, which are assigned to the specific user. Find this question of my problem, but the solution didnt work for me.
MongoDB-PHP: JOIN-like query
Here is snippet of my code, givin' me no results at all.
What is the correct way to finding that data? Should i instead put an user_id as a MongoID without reference? $user = $db->users->findOne(array("_id" => new MongoID("4d3c55e7a130717c09000012")));
$items = $db->items->find(array("user" => array('$id' => $user["_id"])));
Spent all my day with this, thanks in advance!
Try
$items = $db->items->find(array("user.$id" => $user["_id"]));
精彩评论