Contents

Code Reference Classes BP_Media BP_Media::get_in_operator_sql()

BP_Media::get_in_operator_sql( string $field, array|bool $items )

Create SQL IN clause for filter queries.

Description

See also

Parameters

$field

(Required) The database field.

$items

(Required) The values for the IN clause, or false when none are found.

Return

(string|false)

Source

File: bp-media/classes/class-bp-media.php

838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
public static function get_in_operator_sql( $field, $items ) {
    global $wpdb;
 
    // Split items at the comma.
    if ( ! is_array( $items ) ) {
        $items = explode( ',', $items );
    }
 
    // Array of prepared integers or quoted strings.
    $items_prepared = array();
 
    // Clean up and format each item.
    foreach ( $items as $item ) {
        // Clean up the string.
        $item = trim( $item );
        // Pass everything through prepare for security and to safely quote strings.
        $items_prepared[] = ( is_numeric( $item ) ) ? $wpdb->prepare( '%d', $item ) : $wpdb->prepare( '%s', $item );
    }
 
    // Build IN operator sql syntax.
    if ( count( $items_prepared ) ) {
        return sprintf( '%s IN ( %s )', trim( $field ), implode( ',', $items_prepared ) );
    } else {
        return false;
    }
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyBoss 1.1.9 Introduced.

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.