PHP MongoDB find with multiple "AND" conditions?

Question

After hours of experimentations and readings, I cannot find a solution to this problem:

I want to do a MongoDB->find($query) with multiple AND conditions.

For instance, say I want id = 5 and a < 6 and a > 2 and b > 10 and b < 20

I was expecting $query to be:

$query = array("id" => 5,
   "a" => array('$gt' => 2,  
           '$lt' => 6),
   "b" => array('$gt' => 10,
           '$lt' => 20))

But this returns empty results with my DB

I tried various syntaxes such as:

$query = array("id" => 5,
          array( "a" => array('$gt' => 2,
              '$lt' => 6),
       "b" => array('$gt' => 10,
             '$lt' => 20)))

But this fails too.

Also tried with "$AND" variants, no luck.

Is it possible to "mix" several AND conditions in PHP-MongoDB find() requests?

I'm no SME, but is MondoDB a typo on MongoDB?

Martin Cowie
– Martin Cowie

2016-03-21 12:21:18 +00:00
Commented Mar 21, 2016 at 12:21 — Martin Cowie
– Martin Cowie, Commented Mar 21, 2016 at 12:21
@MartinCowie Sure, fixed! Thx.

Gwen Wing
– Gwen Wing

2016-03-21 13:04:40 +00:00
Commented Mar 21, 2016 at 13:04 — Gwen Wing
– Gwen Wing, Commented Mar 21, 2016 at 13:04

Wan B. · Accepted Answer · 2016-03-31 03:51:38Z

4

I've just tested this using MongoDB PHP driver v1.6.11 (PHP-5.5.9). The test data are as below

db.collection.insert({id:5, a:4, b:15})
db.collection.insert({id:9, a:4, b:15})
db.collection.insert({id:5, a:4, b:20})

Using PHP code snippet:

$condition = array(
    '$and' => array(
        array(
            "id" => 5,
            "a" => array('$gt' => 2, '$lt' => 6),
            "b" => array('$gt' => 10, '$lt' => 20)
        )
    )
);
$docs = $coll->find($condition);

foreach( $docs as $o=> $doc) {
    echo json_encode($doc);
}

The above returns only the first document sample. This indicates that $and should work as expected. I've also tested without $and, i.e. :

$condition = array(
                "id" => 5,
                "a" => array('$gt' => 2, '$lt' => 6),
                "b" => array('$gt' => 10, '$lt' => 20)
);

Which also works the same. Try checking your dataset, whether there is a document matching your criteria.

answered Mar 31, 2016 at 3:51

Wan B.

18.9k4 gold badges60 silver badges73 bronze badges

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

1 Comment

Gwen Wing Over a year ago

Thank you for checking this. I've figured out that the issue was an incorrect type for the values. They were strings instead of float (double). After updating the DB with correct type, it works as expected.

Gwen Wing · Accepted Answer · 2016-04-01 14:50:07Z

0

This issue is closed: bad value types in the DB (string instead of float/double). Works as expected when updating to correct types in DB.

answered Apr 1, 2016 at 14:50

Gwen Wing

912 silver badges7 bronze badges

Collectives™ on Stack Overflow

PHP MongoDB find with multiple "AND" conditions?

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