BP_XProfile_Query::get_cast_for_type( string $type = '' )

Return the appropriate alias for the given field type if applicable.

Description

Parameters

$type

(Optional) MySQL type to cast value.

Default value: ''

Return

(string) MySQL type.

Source

File: bp-xprofile/classes/class-bp-xprofile-query.php

	public function get_cast_for_type( $type = '' ) {
		if ( empty( $type ) ) {
			return 'CHAR';
		}

		$meta_type = strtoupper( $type );

		if ( ! preg_match( '/^(?:BINARY|CHAR|DATE|DATETIME|SIGNED|UNSIGNED|TIME|NUMERIC(?:\(\d+(?:,\s?\d+)?\))?|DECIMAL(?:\(\d+(?:,\s?\d+)?\))?)$/', $meta_type ) ) {
			return 'CHAR';
		}

		if ( 'NUMERIC' === $meta_type ) {
			$meta_type = 'SIGNED';
		}

		return $meta_type;
	}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
BuddyPress 2.2.0	Introduced.

Used By
Used By	Description
bp-xprofile/classes/class-bp-xprofile-query.php: BP_XProfile_Query::get_sql_for_clause()	Generate SQL JOIN and WHERE clauses for a first-order query clause.

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.

Contents