Contents

Code Reference Functions bp_ps_anyfield_search()

bp_ps_anyfield_search( $f )

Return results from BuddyBoss Profile Search all fields.

Description

Source

File: bp-core/profile-search/bps-xprofile.php

568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
function bp_ps_anyfield_search ($f)
{
    global $bp, $wpdb;
 
    $filter = $f->filter;
    $value = str_replace ('&', '&', $f->value);
 
    $sql = array ('select' => '', 'where' => array ());
    $sql['select'] = "SELECT DISTINCT user_id FROM {$bp->profile->table_name_data}";
 
    switch ($filter)
    {
    case 'contains':
        $escaped = '%'. bp_ps_esc_like ($value). '%';
        $sql['where'][$filter] = $wpdb->prepare ("value LIKE %s", $escaped);
        break;
 
    case '':
        $sql['where'][$filter] = $wpdb->prepare ("value = %s", $value);
        break;
 
    case 'like':
        $value = str_replace ('\\\\%', '\\%', $value);
        $value = str_replace ('\\\\_', '\\_', $value);
        $sql['where'][$filter] = $wpdb->prepare ("value LIKE %s", $value);
        break;
    }
 
    $sql = apply_filters ('bp_ps_field_sql', $sql, $f);
    $query = $sql['select']. ' WHERE '. implode (' AND ', $sql['where']);
 
    $results = $wpdb->get_col ($query);
    return $results;
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyBoss 1.0.0 Introduced.

Uses

Uses
Uses Description
bp-core/profile-search/bps-search.php: bp_ps_esc_like()

Returns escaped $text with backslashes before characters _%\.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.