I’m working on a member directory.
I’m interested in creating a search that queries ONLY a certain field ‘State’ and value ‘Idaho’.
I’m wondering if I can pass this to the search via the url?
Ex.
/members/s?field=State&value=Idaho

A search for Idaho shows the members in Idaho,
but it also displays anyone that has entered ‘Idaho’ in their profile.
I need to develop a more rigid search based on the field ‘State’.

[@perywinkle Participant 12 years, 7 months ago]

The other option I’ve been toying with is creating the State values: as Idaho_state ( more specific search term )
Then display state as “Idaho” ( in the profile ) with some php:
if value “Idaho – ID”
echo “Idaho”

[@yoramz Member 12 years, 7 months ago]

i’m looking for the same things to do with my site.
did you find a solution for that?

[@shanebp Moderator 12 years, 7 months ago]

I’d approach this a different way –

something like:
`
$match_ids = $wpdb->get_var( “SELECT user_id FROM wp_bp_xprofile_data WHERE field_id = [whatever the field_id is for State] AND value = [whatever value you want to find] “);
`

$match_ids will be a simple array.
So loop thru the array and create a comma separated string out of the ids.
Then pass the string to bp_has_members() using ‘include’

something like
`
//$get_these_members is the id string you created
$get_these_members = ‘include=’ . substr($get_these_members, 0, -1); //trim the last comma

if ( bp_has_members( $get_these_members ) )
`

That way you could search for any value on any profile field.
Your approach might work, but… yikes.

https://codex.buddypress.org/developer-docs/custom-buddypress-loops/the-members-loop/

[@kaformedia Participant 12 years, 7 months ago]

Ok where do you put the code and how can we make it for role.

[@perywinkle Participant 12 years, 7 months ago]

Hey Thanks @shanebp
I’ll give that a try…

[@jamers_786 Participant 11 years, 1 month ago]

hi thanks @shanebp i am really biggner for my self i did what you said but matter is when i tried but never got result kindly check my code tell me i already spend 4 days.

<?php
global $wpdb, $bp;
$result = $wpdb->get_results(“SELECT user_id FROM wp_bp_xprofile_data WHERE value = ‘$_POST[language]’ OR value = ‘$_POST[budget]’ OR value = ‘$_POST[style]’LIMIT 0 , 30”);
print_r($result);
$result = array();
//$values = maybe_unserialize($result);
//echo var_dump( maybe_unserialize( $result ) );
//$values = $result;
//$value = bp_unserialize_profile_user_id( $values );
//$values = implode( “, “, $value);
//echo $values;
//print_r($values);
//so you have to ‘manually’ unserialize them
foreach($result as $user_id=>%d)
{
echo “Key=” . $user_id . “, Value=” . %d;
echo “<br>”;
}
//$values_str = implode( ‘,’, $getty );
//print_r($values_str);

//)

echo $get_these_members;
$get_these_members = ‘include=’ . substr($get_these_members, 0, -1);

?>