comment_exists() WordPress Function

The comment_exists() function checks whether a comment with a given ID exists. If the comment exists, the function returns the comment ID. If the comment does not exist, the function returns false.

comment_exists( string $comment_author, string $comment_date, string $timezone = 'blog' ) #

Determine if a comment exists based on author and date.


Description

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


Top ↑

Parameters

$comment_author

(string)(Required)Author of the comment.

$comment_date

(string)(Required)Date of the comment.

$timezone

(string)(Optional)Timezone. Accepts 'blog' or 'gmt'.

Default value: 'blog'


Top ↑

Return

(string|null) Comment post ID on success.


Top ↑

Source

File: wp-admin/includes/comment.php

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 )
		)
	);
}


Top ↑

Changelog

Changelog
VersionDescription
4.4.0Added the $timezone parameter.
2.0.0Introduced.

The content displayed on this page has been created in part by processing WordPress source code files which are made available under the GPLv2 (or a later version) license by theĀ Free Software Foundation. In addition to this, the content includes user-written examples and information. All material is subject to review and curation by the WPPaste.com community.