使用php-mongo查询mongodb

Question

I am building a simple messaging system, and i have a collection in mongodb with documents like this:

{ "_id" : ObjectId("50ad003f9811e5bc5c000000"), "between" : [ "user1,user2,user3" ] }

I want to perform this query:

db.conversations.find({'between': ["user1,user2,user3"]});

to get this exact document back. This query works in mongo shell.

in php-mongo, i tried this:

$collection->find(array("between"=>array("user1", "user2", "user3")));

but it does not work.

What am i doing wrong ?

Answer 1

Wouldn't you want to do an In query here?

db.collection.find( { "between" : { $in : ["user1", "user2", "user3"] } } );

See In query here: Mongo Advanced $in query

making your PHP query look like:

$collection->find(array("between"=>array("$in"=>array("user1", "user2", "user3"))));
//untested, should be something similar to this.

or if you're trying to find it exactly wouldn't you just be able to do:

$collection->find(array("between"=>array("user1,user2,user3")));