douzi9211
2015-11-24 07:12
浏览 50

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

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

enter image description here

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

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongsha7215 2015-11-24 07:31
    已采纳

    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);
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题