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