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_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 )
)
);
}
Changelog
Version | Description |
---|---|
4.4.0 | Added the $timezone parameter. |
2.0.0 | Introduced. |