如何使用mongodb实现搜索过滤器查询？

Question

i have few search filter user like the following image. User can select any one two or both

these are my filters language,format and status I have written a query but its not working

$lang_id =2;
$format = ''; //user not selected
$status = ''; //user not selected
$request =  $collection->find(array
                            (  '$and' => array(
                                array(
                                    'language' => $lang_id ,
                                    ),
                                 array(
                                    'format' => $format,
                                    ),
                                array(
                                    'status' => $status,
                                    )

                                )
                            ));

I have check with or also then also its not working

if filters are empty no need to find the empty field but if it is not empty need to find the field .

Please give me a solution I am new in mongodb

Thank you

Answer 1

As a solution to above mentioned issue please try executing following code snippet

    $lang_id = 2;
    $format = ''; //user not selected
    $status = ''; //user not selected
    $filter=array();
    if(!empty($lang_id))
    {
      $filter['language']=$lang_id;
    }
    if(!empty($format))
    {
      $filter['format']=$format;
    }
    if(!empty($status))
    {
      $filter['status']=$status;
    }

    $request =  $collection->find($filter);