wp_post_mime_type_where( string|string[] $post_mime_types, string $table_alias = '' ): string

Compatibility

Present in every tracked release (6.7.7 to 7.1.0), and compiles on PHP 7.4 through 8.6-dev.

Parameters

$post_mime_typesstring|string[]

List of mime types or comma separated string of mime types.

$table_aliasstringoptional

Specify a table alias, if needed.
Default empty.Default: ''

Return value

string

The SQL AND clause for mime searching.

Performance profile

How much work a call to wp_post_mime_type_where() does, and what it touches: the algorithmic scaling, the Zend instruction count per call across PHP versions, the hooks it hands control to, and the core code that calls it. Measured from the compiled opcodes, not a stopwatch, so every number is identical on any machine running the same PHP version, and every function in core is ranked by cost.

Cost class

Light

Touches nothing outside its own arguments.

Scaling

Scales with input

The body loops, so the work grows with what you pass in.

Instructions

12–51

Executed per call on PHP 8.5, depending on the branch taken. The body compiles to 95.

Plugin surface

None

Nothing here hands control to plugin code.

Called by

2

2 places in core call this, so the cost is paid more often than your own code shows.

What one call costs · 2 distinct outcomes

One number would be a lie: the work depends on which branch runs. These are every distinct cost wp_post_mime_type_where() can have, taken from its control-flow graph on PHP 8.5.

Uses · 1

• str_contains()Polyfill for `str_contains()` function added in PHP 8.0.

Used by · 2

• WP_Query::get_posts()Retrieves an array of posts based on query variables.
• wp_count_attachments()Counts number of attachments for the mime type(s).

Source code

View on Trac ↗View on GitHub ↗

3765function wp_post_mime_type_where( $post_mime_types, $table_alias = '' ) {3766	$where     = '';3767	$wildcards = array( '', '%', '%/%' );3768	if ( is_string( $post_mime_types ) ) {3769		$post_mime_types = array_map( 'trim', explode( ',', $post_mime_types ) );3770	}3771 3772	$where_clauses = array();3773 3774	foreach ( (array) $post_mime_types as $mime_type ) {3775		$mime_type = preg_replace( '/\s/', '', $mime_type );3776		$slashpos  = strpos( $mime_type, '/' );3777		if ( false !== $slashpos ) {3778			$mime_group    = preg_replace( '/[^-*.a-zA-Z0-9]/', '', substr( $mime_type, 0, $slashpos ) );3779			$mime_subgroup = preg_replace( '/[^-*.+a-zA-Z0-9]/', '', substr( $mime_type, $slashpos + 1 ) );3780			if ( empty( $mime_subgroup ) ) {3781				$mime_subgroup = '*';3782			} else {3783				$mime_subgroup = str_replace( '/', '', $mime_subgroup );3784			}3785			$mime_pattern = "$mime_group/$mime_subgroup";3786		} else {3787			$mime_pattern = preg_replace( '/[^-*.a-zA-Z0-9]/', '', $mime_type );3788			if ( ! str_contains( $mime_pattern, '*' ) ) {3789				$mime_pattern .= '/*';3790			}3791		}3792 3793		$mime_pattern = preg_replace( '/\*+/', '%', $mime_pattern );3794 3795		if ( in_array( $mime_type, $wildcards, true ) ) {3796			return '';3797		}3798 3799		if ( str_contains( $mime_pattern, '%' ) ) {3800			$where_clauses[] = empty( $table_alias ) ? "post_mime_type LIKE '$mime_pattern'" : "$table_alias.post_mime_type LIKE '$mime_pattern'";3801		} else {3802			$where_clauses[] = empty( $table_alias ) ? "post_mime_type = '$mime_pattern'" : "$table_alias.post_mime_type = '$mime_pattern'";3803		}3804	}3805 3806	if ( ! empty( $where_clauses ) ) {3807		$where = ' AND (' . implode( ' OR ', $where_clauses ) . ') ';3808	}3809 3810	return $where;3811}

Changelog

Introduced in 2.5.0. Unchanged from 6.7.7 through 7.1.0.

1. 6.7.7
2. 6.8.8
3. 6.9.7
4. 7.0.4
5. 7.1.0

Signature, return type and hooks compared across 5 parsed releases.

About this page

Parsed data

Generated from the wordpress-develop 7.1.0 tag, from src/wp-includes/post.php, and regenerated for each WordPress release so it tracks the code rather than a snapshot of it.

Corrections

Something wrong on this page? Report it and it gets fixed in the next regeneration.