MemberPress: Display Purchase Information With Shortcode

function custom_purchase_info_shortcode() {

    global $wpdb;

    // Get the current user ID

    $user_id = get_current_user_id();

    // Get the latest MemberPress transaction for this user

    $latest_transaction = $wpdb->get_row( $wpdb->prepare(

        "SELECT * FROM {$wpdb->prefix}mepr_transactions 

        WHERE user_id = %d 

        ORDER BY id DESC 

        LIMIT 1",

        $user_id

    ) );

    if ($latest_transaction) {

        $value = $latest_transaction->amount;

        $transaction_id = $latest_transaction->trans_num;

        $user_email = get_userdata($user_id)->user_email;

        // Format the output

        $output = "

            <p><strong>Purchase Value:</strong> $" . number_format($value, 2) . "</p>

            <p><strong>Transaction ID:</strong> " . $transaction_id . "</p>

            <p><strong>Your Email:</strong> " . $user_email . "</p>

        ";

        return $output;

    } else {

        return "No purchase information found.";

    }

}

add_shortcode('purchase_info', 'custom_purchase_info_shortcode');