How to query MongoDB from PHP using '$or' or '$and' clause?

Question

I want to get data from mongodb by using MongoDB PHP7.1 Driver with the help of $or or $and clause in filter. I have tried to construct query to do the same but that didn't work.

Here is my sample code here:

$manager = new MongoDB\Driver\Manager("mongodb://localhost:27017");

try {
   $filter = [
        '$or'  => [
          'age' => [ '$gt' => 40],
          'name' => 'abc'
        ]
      ];
   $query = new MongoDB\Driver\Query($filter);

   $rows = $manager->executeQuery("test.users", $query);


   foreach ($rows as $key => $val) {
      print_r($val);
   }
} catch(MongoDB\Driver\Exception $e) {
   echo $e->getMessage(), "\n";
   exit;
}

The above code gives me below error:

Fatal error: Uncaught MongoDB\Driver\Exception\ConnectionException: $or must 
be an array in C:\xampp\htdocs\local\demo.php:50 Stack trace: #0 
C:\xampp\htdocs\local\demo.php(50): MongoDB\Driver\Manager-
>executeQuery('test.users', Object(MongoDB\Driver\Query)) #1 {main} thrown 
in C:\xampp\htdocs\local\demo.php on line 50

Please help me to understand what I am doing wrong.

You will need a second expression for $or. Try $filter = [ 'name' => 'abc', '$or' => [[ 'age' => [ '$gt' => 40] ], second expression goes here] ]; — s7vr
– s7vr, Commented Apr 28, 2017 at 13:43
@Veeram thank you it's worked. I had forgot to add that internal array bracket to every condition. — Mayur
– Mayur, Commented Apr 28, 2017 at 13:49

dougB · Accepted Answer · 2018-08-25 05:13:10Z

4

Adding to answer from @Veeram: Had this as my filter, which did not work:

$filter  = [
    '$and' =>
        ['date' => ['$gte' => $start_date]],
        ['date' => ['$lte' => $end_date]]
];

added the extra [] as @Veeram suggested. This configuration works for $and:

$filter  = [
    '$and' => [
        ['date' => ['$gte' => $start_date]],
        ['date' => ['$lte' => $end_date]]
    ]
];

answered Aug 25, 2018 at 5:13

dougB

5096 silver badges11 bronze badges

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

Comments

Fadhel Ali · Accepted Answer · 2022-05-06 09:38:07Z

0

you can do this also

$result=$collections->
find(array('$and=>array(array('date'=>array('$gte'=>$start_date)
),array('date'=>array('$lte'=>$end_date))));

answered May 6, 2022 at 9:38

Fadhel Ali

413 bronze badges

Collectives™ on Stack Overflow

How to query MongoDB from PHP using '$or' or '$and' clause?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related