Question

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.

---

参数

$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'

---

返回值

(mixed) Comment post ID on success.

---

源代码

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

---

更新日志

Version	description
4.4.0	Added the $timezone parameter.
2.0.0	Introduced.

---

相关函数

Uses

• wp-includes/wp-db.php: wpdb::get_var()
• wp-includes/wp-db.php: wpdb::prepare()

---

User Contributed Notes