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_author
string
Required
Author of the comment.
$comment_date
string
Required
Date of the comment.
$timezone
string
Optional
Timezone. Accepts "blog" or "gmt". Default "blog".
Default: "blog"
Return
string|null Comment post ID on success.
Source
File: wp-admin/includes/comment.php.
View all references
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 )
)
);
}