MongoDB PHP using $in with array

Question

I'm using MongoDB and PHP and trying to do a $in based on a generated array.

When I specify the same array manually, it works, but when I build it, it return any results with the same data.

There's what I have:

$settings = array();
foreach($items as $item) {
   $settings[] = $item['id'];
}

//Settings is the same as this
$setting2 = array(1,2,3,4,5,6,7,8);

//This returns no results
$cursor = $collection->find(array('status' => 0, 'sid' => array('$in' => $settings)));


//This does return results
$cursor = $collection->find(array('status' => 0, 'sid' => array('$in' => $setting2)));

I've checked using

$cursor->info()

And the items in the array are the same.

Any ideas what I'm doing wrong?

Thanks!

Derick · Accepted Answer · 2012-04-02 08:32:40Z

4

It's likely that the data types of the numbers are not the same. Try using var_dump() on the built array, and the specified array. You'll probably see one has them as numbers in a string, and the other as simple integers.

answered Apr 2, 2012 at 8:32

Derick

36.9k7 gold badges82 silver badges104 bronze badges

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

Collectives™ on Stack Overflow

MongoDB PHP using $in with array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related