MongoDB $and operator query in PHP

Question

I've been having difficulty with the $and operator and MongoRegex.

I'm doing a regex record search for "Amazon" that also has the field "enabled" set to 1.

This is my query.

$search = "Amazon";
$results = $collection->find(array(
  '$and' => array(
     array('orgname' => new MongoRegex("/.*$search.*/")),
     array('enabled' => '1')
   )
));

Maybe someone can point out what I'm doing wrong. Thanks in Advance.

I edited your question and formatted in so it is easier to read. Perhaps it works now. I think you hade placed one ending bracket at the end instead of after new MongoRegex("/.*$search.*/"). But I cannot go back and see your orignal post... Anyway, in this case you don't need the $and operator, see my anwer. — luttkens
– luttkens, Commented Jul 21, 2013 at 8:48
@luttkens If you changed the code then you changed the nature of the question, that incorrect bracket could have been the problem... — Sammaye
– Sammaye, Commented Jul 21, 2013 at 9:12

luttkens · Accepted Answer · 2013-07-21 08:37:15Z

2

I think that in this case you don't need to use the $and operator. Try this:

$search = "Amazon";
$cursor = $collection->find(array(
  'orgname' =>new MongoRegex("/.$search./"), 
  'enabled' => 1)
);

answered Jul 21, 2013 at 8:37

luttkens

1,2848 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

MongoDB $and operator query in PHP

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