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