php多条件筛选查询mysql

 此块代码实现当传入用户名和用户id时直接查询，多条件查询组合为排序、类型、时间区间

    if(!empty($user_id)){//如果传入用户id
        $query="select * from water_work_list where user_id = '{$user_id}' order BY time desc limit {$current_num} , {$num}";
        $rowcount = search_all_row($link,"select count(*) from water_work_list where user_id = '{$user_id}'");
    }else if(!empty($user_name)){//如果传入用户名
        $query="select * from water_work_list where user_name = '{$user_name}' order BY time desc limit {$current_num} , {$num}";
        $rowcount = search_all_row($link,"select count(*) from water_work_list where user_name = '{$user_name}'");
    }else if(!empty($time_cixu) || !empty($use_type) || !empty($startBudgetTime)){//如果筛选字段不为空
        $query="from water_work_list";
        if(!empty($use_type)){//如果传入类型筛选
            $query  .= " where {$use_type} = 1";
        }
        if(!empty($startBudgetTime)){//如果传入时间筛选，单个时间参数使用>,<符号
            $query .= ( preg_match('/where/' , $query ) ? " and ": " where " ) . " handle_time between '{$startBudgetTime}' and '{$endBudgetTime}'";
        }
        if(!empty($time_cixu) && $time_cixu==1){//如果传入排序筛选
            $query .=" order BY handle_time desc";
        }else{
            $query .=" order BY handle_time ASC";
        }
        //获取总条数
        $rowcount = search_all_row($link,"select count(*) {$query}");
        //分页
        $query.=" limit {$current_num} , {$num}";
        $query = "select * {$query}";
    }else{
        $query="select * from water_work_list order BY time desc limit {$current_num} , {$num}";
        $rowcount = search_all_row($link,"select count(*) from water_work_list");
    }