MemberPress: Display Current User’s Memberships Statuses And Renewal Dates

function mp_custom_membership_info() {

    if (!is_user_logged_in()) {

        return 'You need to be logged in to view this information.';

    }

    global $wpdb;

    $user_id = get_current_user_id();

    // Query to get all active MemberPress transactions for the current user

    $transactions = $wpdb->get_results($wpdb->prepare(

        "SELECT txn.*, p.post_title 

         FROM {$wpdb->prefix}mepr_transactions txn

         JOIN {$wpdb->prefix}posts p ON txn.product_id = p.ID

         WHERE txn.user_id = %d

         AND txn.status IN ('complete', 'failed', 'pending', 'refunded')", // Remove any status if not needed

        $user_id

    ));

    if (empty($transactions)) {

        return 'No active memberships found.';

    }

    $output = '<div class="mp-membership-info">';

    foreach ($transactions as $txn) {

        // Format renewal date

        $renewal_date = $txn->expires_at ? date("F j, Y", strtotime($txn->expires_at)) : 'N/A';

        $output .= '<p>';

        $output .= '<strong>Membership:</strong> ' . esc_html($txn->post_title) . '<br>';

        $output .= '<strong>Status:</strong> ' . esc_html(ucfirst($txn->status)) . '<br>';

        $output .= '<strong>Renewal Date:</strong> ' . esc_html($renewal_date) . '<br>';

        $output .= '</p>';

    }

    $output .= '</div>';

    return $output;

}

add_shortcode('mp_membership_info', 'mp_custom_membership_info');