BP_Activity_Activity::get_in_operator_sql( string $field, array|bool $items )
Create SQL IN clause for filter queries.
Description Description
See also See also
Parameters Parameters
- $field
-
(Required) The database field.
- $items
-
(Required) The values for the IN clause, or false when none are found.
Return Return
(string|false)
Source Source
File: bp-activity/classes/class-bp-activity-activity.php
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; }
Changelog Changelog
Version | Description |
---|---|
1.5.0 | Introduced. |