SeidonBro's Replies | ww.wp.xz.cn

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

Forum: Plugins
In reply to: [BP Profile Search] [Plugin: BP Profile Search] How to search multiple words per field? Will pay $$$ for help :)
Thread Starter SeidonBro
(@seidonbro)

13 years, 10 months ago
I’ve tried adding multiple values in manually here:

(starting line 75 bps_searchform.php)
```
case 'textbox':
echo "
<label for='$field_input_name'>$field->name</label>
<input type='text' name='$field_input_name' id='$field_input_name' value='surfing'/>
";
break;
```
This works great for searching SINGLE values but all I really need to do is add a second value and make the search look for either:

Value(1) or Value(2)
Forum: Plugins
In reply to: [BP Profile Search] [Plugin: BP Profile Search] How to search multiple words per field? Will pay $$$ for help :)
Thread Starter SeidonBro
(@seidonbro)

13 years, 10 months ago
Important:

With what I’m building, I’m going to be setting the ‘values’ MANUALLY – the user will not be able to enter search terms, they will be pre-chosen for them.

I know the problem is with the way the search specifies the value:

(Beginning line 107 in bps_functions.php)
```
case 'textbox':
case 'textarea':
$sql = "SELECT user_id from {$bp->profile->table_name_data}";
if ($bps_options['searchmode'] == 'Partial Match')
    $sql .= " WHERE field_id = $id AND value LIKE '%%$value%%'";
else
    $sql .= " WHERE field_id = $id AND value LIKE '$value'";
break;
```
Basically, all I need to do is get the search to recognise multiple, individual ‘values’ from a single field…

Viewing 2 replies - 1 through 2 (of 2 total)