A WordPress-centric search engine for devs and theme authors



post_exists ›

Since2.0.0
Deprecatedn/a
post_exists ( $title, $content = '', $date = '' )
Parameters: (3)
  • (string) $title Post title
    Required: Yes
  • (string) $content Optional post content
    Required: No
    Default: (empty)
  • (string) $date Optional post date
    Required: No
    Default: (empty)
Returns:
  • (int) Post ID if post exists, 0 otherwise.
Defined at:
Codex:

Determine if a post exists based on title, content, and date



Source

function post_exists( $title, $content = '', $date = '' ) {
	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' ) );

	$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( $args ) ) {
		return (int) $wpdb->get_var( $wpdb->prepare( $query, $args ) );
	}

	return 0;
}