Advertisements

post_exists

Definition:
function post_exists($title, $content = '', $date = '') {}

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

Parameters

  • string $title: Post title
  • string $content: Optional post content
  • string $date: Optional post date

Return values

returns:Post ID if post exists, 0 otherwise.

Source code

function post_exists($title, $content = '', $date = '') {

	global $wpdb;



	$post_title = stripslashes( sanitize_post_field( 'post_title', $title, 0, 'db' ) );

	$post_content = stripslashes( sanitize_post_field( 'post_content', $content, 0, 'db' ) );

	$post_date = stripslashes( 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 $wpdb->get_var( $wpdb->prepare($query, $args) );



	return 0;

}

2571

Advertisements

No comments yet... Be the first to leave a reply!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: