comment_exists() – Function | Developer.WordPress.org

comment_exists( string $comment_author, string $comment_date, string $timezone = 'blog' ): string|null

Determines 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.

Parameters

$comment_authorstringrequired: Author of the comment.
$comment_datestringrequired: Date of the comment.
$timezonestringoptional: Timezone. Accepts 'blog' or 'gmt'. Default 'blog'.
Default:'blog'

Return

string|null Comment post ID on success.

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

View all references View on Trac View on GitHub

Uses	Description
wpdb::get_var()`wp-includes/class-wpdb.php`	Retrieves one value from the database.
wpdb::prepare()`wp-includes/class-wpdb.php`	Prepares a SQL query for safe execution.

Changelog

Version	Description
4.4.0	Added the `$timezone` parameter.
2.0.0	Introduced.

User Contributed Notes

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