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

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

Contents

Parameters

$title string Required
Post title.
$content string Optional
Post content.

Default: ''

$date string Optional
Post date.

Default: ''

$type string Optional
Post type.

Default: ''

$status string Optional
Post status.

Default: ''

Top ↑

Return

int Post ID if post exists, 0 otherwise.

Top ↑

Source

File: wp-admin/includes/post.php. View all references 

function post_exists( $title, $content = '', $date = '', $type = '', $status = '' ) {
	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' ) );
	$post_status  = wp_unslash( sanitize_post_field( 'post_status', $status, 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( $status ) ) {
		$query .= ' AND post_status = %s';
		$args[] = $post_status;
	}

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

	return 0;
}

View on Trac View on GitHub

Top ↑

Top ↑

Changelog

Changelog
Version Description
5.8.0 Added the $status parameter.
5.2.0 Added the $type parameter.
2.0.0 Introduced.

Top ↑

User Contributed Notes

  1. Skip to note 1 content
    You must log in to vote on the helpfulness of this noteVote results for this note: 2You must log in to vote on the helpfulness of this note
    Contributed by BlackSwan —

    Check if post exist by title :

    $fount_post = post_exists( "My Post Title",'','','');
	echo $fount_post ? "Found post at id #$fount_post" : "Can't find post!";

    Check if custom post type [news] exist by title :

    $fount_post = post_exists( "My Post Title",'','','news');
	echo $fount_post ? "Found post at id #$fount_post" : "Can't find post!";

You must log in before being able to contribute a note or feedback.