PHP/MongoDB & Complex Query

Question

I'm pretty new in Mongodb. Just read documentation and played. I wanted to find documents with the word "MIA" and timestamp value between 25th Aug, 2014 to 28th Aug, 2014. I wrote this way

$var = "MIA";
date_default_timezone_set('UTC');
$from = strtotime('2014-08-25');
$to = strtotime('2014-08-28');;

$var = new MongoRegex("/$var/");
$where1 = array( '$or' => array( array(array('caller' => $var)), array('callee' => $var)));

$where2 = array( '$and' => array( array('timestamp' => array('$gte' => $from )), array('timestamp' => array('$lte'=> $to)) ) );

$where = array( '$and' => $where1, $where2 );

//var_dump($where);

$cursor = $collection->find($where);
var_dump($cursor);

I was getting empty result. Can you please advice to fix this?

Thanks

EDIT: Collection Structure enter image description here

Can i see the collection structure?

alu
– alu

2014-10-31 07:49:37 +00:00
Commented Oct 31, 2014 at 7:49 — alu
– alu, Commented Oct 31, 2014 at 7:49

alu · Accepted Answer · 2014-10-31 08:27:30Z

1

Try this.

$where1 = array(
    '$or' => array(
        // array(array('caller' => $var)) => often nest one
        array('caller' => $var),
        array('callee' => $var)
    )
);

$where2 = array(
    '$and' => array(
        array('timestamp' => array('$gte' => $from)),
        array('timestamp' => array('$lte'=> $to))
    )
);

// $where = array( '$and' => $where1, $where2 ); => `$where2` is not in $and query
$where = array( '$and' => array($where1, $where2));

answered Oct 31, 2014 at 8:27

alu

4562 silver badges7 bronze badges

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

2 Comments

alu Over a year ago

Hmm. Is var_dump(iterator_to_array($cursor)); output empty?

LuckyCoder Over a year ago

My bad, miss-typed one variable. However, worked. Thanks

Collectives™ on Stack Overflow

PHP/MongoDB & Complex Query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related