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_authorstring Required -
Author of the comment.
-
$comment_datestring Required -
Date of the comment.
-
$timezonestring 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. |