comment_exists( string $comment_author, string $comment_date, string $timezone = 'blog' )

Determine if a comment exists based on author and date.

Contents

Description 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 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 value: 'blog'

Top ↑

Return Return

(mixed) Comment post ID on success.

Top ↑

Source Source

File: wp-admin/includes/comment.php

27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
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 )
        )
    );
}

Expand full source code Collapse full source code View on Trac

Top ↑

Changelog Changelog

Changelog
Version Description
4.4.0 Added the $timezone parameter.
2.0.0 Introduced.

Top ↑

Top ↑

Uses Uses

Uses
Uses Description
wp-includes/wp-db.php: wpdb::get_var()

Retrieve one variable from the database.
wp-includes/wp-db.php: wpdb::prepare()

Prepares a SQL query for safe execution. Uses sprintf()-like syntax.

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.