WP_Date_Query::build_value() WordPress Method
The build_value() method is used to construct a string for use in the WHERE clause of a SQL query. It is used internally by the WP_Date_Query class.
WP_Date_Query::build_value( string $compare, string|array $value ) #
Builds and validates a value string based on the comparison operator.
Parameters
- $compare
(string)(Required)The compare operator to use.
- $value
(string|array)(Required)The value.
Return
(string|false|int) The value to be used in SQL or false on error.
Source
File: wp-includes/class-wp-date-query.php
public function build_value( $compare, $value ) { if ( ! isset( $value ) ) { return false; } switch ( $compare ) { case 'IN': case 'NOT IN': $value = (array) $value; // Remove non-numeric values. $value = array_filter( $value, 'is_numeric' ); if ( empty( $value ) ) { return false; } return '(' . implode( ',', array_map( 'intval', $value ) ) . ')'; case 'BETWEEN': case 'NOT BETWEEN': if ( ! is_array( $value ) || 2 !== count( $value ) ) { $value = array( $value, $value ); } else { $value = array_values( $value ); } // If either value is non-numeric, bail. foreach ( $value as $v ) { if ( ! is_numeric( $v ) ) { return false; } } $value = array_map( 'intval', $value ); return $value[0] . ' AND ' . $value[1]; default: if ( ! is_numeric( $value ) ) { return false; } return (int) $value; } }
Expand full source codeCollapse full source codeView on TracView on GitHub
Changelog
Version | Description |
---|---|
3.7.0 | Introduced. |