wpseek.com
A WordPress-centric search engine for devs and theme authors



comment_exists › WordPress Function

Since2.0.0
Deprecatedn/a
comment_exists ( $comment_author, $comment_date, $timezone = 'blog' )
Parameters: (3)
  • (string) $comment_author Author of the comment.
    Required: Yes
  • (string) $comment_date Date of the comment.
    Required: Yes
  • (string) $timezone Timezone. Accepts 'blog' or 'gmt'. Default 'blog'.
    Required: No
    Default: 'blog'
Returns:
  • (string|null) Comment post ID on success.
Defined at:
Codex:
Change Log:
  • 4.4.0

Determines if a comment exists based on author and date.

For best performance, use $timezone = 'gmt', which queries a field that is properly indexed. The default value for $timezone is 'blog' for legacy reasons.


Source

function comment_exists( $comment_author, $comment_date, $timezone = 'blog' ) {
	global $wpdb;

	$date_field = 'comment_date';
	if ( 'gmt' === $timezone ) {
		$date_field = 'comment_date_gmt';
	}

	return $wpdb->get_var(
		$wpdb->prepare(
			"SELECT comment_post_ID FROM $wpdb->comments
			WHERE comment_author = %s AND $date_field = %s",
			stripslashes( $comment_author ),
			stripslashes( $comment_date )
		)
	);
}