Function Reference: geodir_get_review_count_by_user_id

Summary

Get review count by user ID.

Description

Returns review count of a user. If no results returns false.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory

Parameters

$user_id

(int) (required)

Default: None

Return Values

(bool|null|string)

Change Log

Since: 1.0.0

Source File

geodir_get_review_count_by_user_id() is located in geodirectory-functions/comments_functions.php [Line: 586]

Source Code

function geodir_get_review_count_by_user_id($user_id = 0)
{
    global $wpdb;
    $results = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT COUNT(overall_rating) FROM " . GEODIR_REVIEW_TABLE . " WHERE user_id = %d AND status=1 AND overall_rating>0",
            array($user_id)
        )
    );

    if (!empty($results))
        return $results;
    else
        return false;
}