$or requires nonempty array exception

Question

I need to get data from Mongodb Database, My code as follow,

    $collection = $global["dbmongo"] -> person_uuid;
    $rows = $collection->find(array("p_uuid" => $global['uuid'],
            '$or'=>array(

                    'expiry_date'=>null,
                    'expiry_date'=> '0000-01-01 00:00:00'
            )
    )
    );

But it shows,

$or requires nonempty array

if i write echo "count".$count; var_dump($rows); Then the output is countArrayobject(MongoCursor)#48 (0) { }, addition to above output Please help me.

$or is an array of arrays, with each element of the parent array being a clause — Sammaye
– Sammaye, Commented Dec 1, 2013 at 14:38
Thanks, So how can i fix that ? In test case, I finding with 'expiry_date'=> '0000-01-01 00:00:00' — Lakmal Vithanage
– Lakmal Vithanage, Commented Dec 1, 2013 at 14:42
wrap each line of the $or clause with array( so it is an set of array clauses — Sammaye
– Sammaye, Commented Dec 1, 2013 at 14:51

Salvador Dali · Accepted Answer · 2013-12-01 21:24:08Z

2

The problem is with this part:

array(
  'expiry_date'=>null,
  'expiry_date'=> '0000-01-01 00:00:00'
)

The keys are the same and because of this one overwrites another. You can use $in operator and do something like

'expiry_date' => array(
  '$in' => array(null, '0000-01-01 00:00:00')
)

Also it is hard to understand what exactly are you looking for here.

answered Dec 1, 2013 at 21:24

Salvador Dali

224k151 gold badges728 silver badges766 bronze badges

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

Collectives™ on Stack Overflow

$or requires nonempty array exception

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