$data['countries']      = Countries::orderBy('name', 'ASC')->where('id', '!=', '231')->get();
        $data['categories']     = categories::get();

        $query = UserProfiles::join('users', 'users_profiles.user_id', '=', 'users.id');

        $query->join('countries','users_profiles.country','=','countries.id');
        $query->join('states','users_profiles.state','=','states.id');


        if(!empty($request->category)){
            $query->where('users.member_type',$request->category);
        }

        if(!empty($request->country)){
            $query->where('users_profiles.country', $request->country);
        }

        if(!empty($request->state)){
            $query->where('users_profiles.state', $request->state);
        }

        if(!empty($request->type)){
            $query->where('users_profiles.type_surrogacy', $request->type);
        }

        if(!empty($request->city)){
            $query->where('users_profiles.city', $request->city);
        }

        if(!empty($request->willing_to)){
            $query->where('users_profiles.willing_to_assist', $request->willing_to);
        }

        if(!empty($request->languages)){
            $query->where('users_profiles.languages', $request->languages);
        }

        if(!empty($request->country)){
            $query->where('users_profiles.country', $request->country);
        }

        if(!empty($request->education)){
            $query->where('users_profiles.education', $request->education);
        }

        if(!empty($request->smoker)){
            $query->where('users_profiles.smoker', $request->smoker);
        }

        if(!empty($request->hair_color)){
            $query->where('users_profiles.hair_color', $request->hair_color);
        }

        if(!empty($request->eye_color)){
            $query->where('users_profiles.eye_color', $request->eye_color);
        }

        if(!empty($request->marital_status)){
            $query->where('users_profiles.marital_status', $request->marital_status);
        }

        $query->select('users.*','countries.name as country','states.name as state');

        $data['search_results'] = $query->paginate(15);

@foreach($search_results as $results)

{{$results->first_name.' '.$results->last_name}}

@endforeach

{!! $search_results->appends(Request::except('page'))->render() !!}