OR operator in mongodb with php

Question

Working of OR operator in mongodb with php

$query = array(
        'table' => $table,
        'user_id' => array('$ne'=> null),
        '$or' => array('movies' => array('$ne' => null), 'comics' => array('$ne' => null) )
    );

$dbcollection->find($query);

Here I try to return whole records where movies array or comics array is not null, But I always return empty array. In database, movies or comics array is present in some records and some other records no movies or comics array is present.

How can I correct this query ?

@Micku: I using version 1.0.4 or 'OR' operator needs v1.6+, is it ? — Justin John
– Justin John, Commented May 30, 2012 at 5:47
When you say "1.0.4", do you mean the server version or the PHP Driver version? Try logging in with the mongo shell (type mongo) and it will tell you which version you are it. In any case, PHP driver version 1.0.4 is really old. And I don't think MongoDB version 1.0.4 exists. Don't you mean 2.0.4? Also, post a sample document with your question so we can have a look at what is stored. — Derick
– Derick, Commented May 30, 2012 at 10:15

Derick · Accepted Answer · 2012-05-30 22:06:27Z

2

The comments indicate that you are using MongoDB 1.4.4. The $or operator did not get introduced until MongoDB 1.6 as per documentation. MongoDB 1.4.4 is also really really old. Please upgrade!

answered May 30, 2012 at 22:06

Derick

36.9k7 gold badges82 silver badges104 bronze badges

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

1 Comment

Justin John Over a year ago

Its my local server mongo version is 1.4.4, but in production server where the mongo version is 1.6.2 is also not working the OR operator. Any way Thanks for help...

Collectives™ on Stack Overflow

OR operator in mongodb with php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related