comment_exists() – Determine if a comment exists based on author and date.

You appear to be a bot. Output may be restricted

Description

Determine if a comment exists based on author and date.

For best performance, use `$timezone = 'gmt'`, which queries a field that is properly indexed. The default value for $timezone is 'blog' for legacy reasons.

Usage

$string|null = comment_exists( $comment_author, $comment_date, $timezone );

Parameters

$comment_author
( string ) required – Author of the comment.
$comment_date
( string ) required – Date of the comment.
$timezone
( string ) optional default: blog – Timezone. Accepts 'blog' or 'gmt'. Default 'blog'.

Returns

string|null Comment post ID on success.

Source

File name: wordpress/wp-admin/includes/comment.php
Lines:

1 to 17 of 17
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 )
    )
  );
}
 

 View on GitHub View on Trac