MongoDB PHP query using $and operator on the same object

Question

I've got a fairly simple query that I have working in command line, and am trying to execute using php.

It's looking for documents that match all of the given "tags" entered in a search box:

db.collection.find( { $and: [ { tags: "cats" }, { tags: "video" } ] } )

I can't seem to figure out how to translate this to php. I've been using codeigniter for everything up to this point (Alex Bilbie's library), but have looked into building my own queries with no luck. Most of the methods I've tried eliminate the first tag (cats), since it is looking at the same field name (tags).

any thoughts?

Petrogad · Accepted Answer · 2011-12-09 16:56:21Z

3

PHP can be a bit tricky with how you need to format the arrays. What I've found to be the best way to create the queries is through doing things like:

json_encode($myQuery);

then comparing that to what actually works directly on the console of the app. In this case you're looking for:

$item = array('$and' => array(array('tags' => 'cats'), array('tags' => 'videos')))

which you can confirm by doing:

echo(json_encode(array('$and' => array(array('tags' => 'cats'), array('tags' => 'videos')))));

Good Luck!

answered Dec 9, 2011 at 16:56

Petrogad

4,4335 gold badges41 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

MongoDB PHP query using $and operator on the same object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related