$或要求非空数组异常

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.

Answer 1

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.