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
stringrequired- Author of the comment.
$comment_date
stringrequired- Date of the comment.
$timezone
stringoptional- Timezone. Accepts
'blog'
or'gmt'
. Default'blog'
.Default:
'blog'
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 )
)
);
}
User Contributed Notes
You must log in before being able to contribute a note or feedback.