W3cubDocs

/WordPress

post_exists( string $title, string $content = '', string $date = '', string $type = '' )

Determines if a post exists based on title, content, date and type.

Parameters

$title

(string) (Required) Post title.

$content

(string) (Optional) post content.

Default value: ''

$date

(string) (Optional) post date.

Default value: ''

$type

(string) (Optional) post type.

Default value: ''

Return

(int) Post ID if post exists, 0 otherwise.

Source

File: wp-admin/includes/post.php 

function post_exists( $title, $content = '', $date = '', $type = '' ) {
	global $wpdb;

	$post_title   = wp_unslash( sanitize_post_field( 'post_title', $title, 0, 'db' ) );
	$post_content = wp_unslash( sanitize_post_field( 'post_content', $content, 0, 'db' ) );
	$post_date    = wp_unslash( sanitize_post_field( 'post_date', $date, 0, 'db' ) );
	$post_type    = wp_unslash( sanitize_post_field( 'post_type', $type, 0, 'db' ) );

	$query = "SELECT ID FROM $wpdb->posts WHERE 1=1";
	$args  = array();

	if ( ! empty( $date ) ) {
		$query .= ' AND post_date = %s';
		$args[] = $post_date;
	}

	if ( ! empty( $title ) ) {
		$query .= ' AND post_title = %s';
		$args[] = $post_title;
	}

	if ( ! empty( $content ) ) {
		$query .= ' AND post_content = %s';
		$args[] = $post_content;
	}

	if ( ! empty( $type ) ) {
		$query .= ' AND post_type = %s';
		$args[] = $post_type;
	}

	if ( ! empty( $args ) ) {
		return (int) $wpdb->get_var( $wpdb->prepare( $query, $args ) );
	}

	return 0;
}

Uses

Uses Description
wp-includes/formatting.php: wp_unslash()

Remove slashes from a string or array of strings.
wp-includes/post.php: sanitize_post_field()

Sanitizes a post field based on context.
wp-includes/wp-db.php: wpdb::get_var()

Retrieves one variable from the database.
wp-includes/wp-db.php: wpdb::prepare()

Prepares a SQL query for safe execution.

Changelog

Version Description
5.2.0 Added the $type parameter.
2.0.0 Introduced.

© 2003–2019 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/post_exists