get_term_by

Source code

function get_term_by($field, $value, $taxonomy, $output = OBJECT, $filter = 'raw') {

	global $wpdb;



	if ( ! taxonomy_exists($taxonomy) )

		return false;



	if ( 'slug' == $field ) {

		$field = 't.slug';

		$value = sanitize_title($value);

		if ( empty($value) )

			return false;

	} else if ( 'name' == $field ) {

		// Assume already escaped

		$value = stripslashes($value);

		$field = 't.name';

	} else {

		$term = get_term( (int) $value, $taxonomy, $output, $filter);

		if ( is_wp_error( $term ) )

			$term = false;

		return $term;

	}



	$term = $wpdb->get_row( $wpdb->prepare( "SELECT t.*, tt.* FROM $wpdb->terms AS t INNER JOIN $wpdb->term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = %s AND $field = %s LIMIT 1", $taxonomy, $value) );

	if ( !$term )

		return false;



	wp_cache_add($term->term_id, $term, $taxonomy);



	$term = apply_filters('get_term', $term, $taxonomy);

	$term = apply_filters("get_$taxonomy", $term, $taxonomy);

	$term = sanitize_term($term, $taxonomy, $filter);



	if ( $output == OBJECT ) {

		return $term;

	} elseif ( $output == ARRAY_A ) {

		return get_object_vars($term);

	} elseif ( $output == ARRAY_N ) {

		return array_values(get_object_vars($term));

	} else {

		return $term;

	}

}