FluentCRM Subscriber Count Shortcode

stoute-fluentcrm-subscriber-count.php

<?php

/**
 * Plugin Name: FluentCRM Subscriber Count
 * Version: 1.0
 * Description: Adds a shortcode [fluentcrm_subscriber_count]
 */
 
function stoute_fcrm_subscriber_count($atts)
{
	global $wpdb;
	
	$a = shortcode_atts(array(
		'status' => 'subscribed',
	), $atts );
	
	$status = esc_attr($a['status']);
	$table = "{$wpdb->prefix}fc_subscribers";
	
	$results = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $table WHERE status = '%s'", $status ));
	
	return $results;
}
add_shortcode('fluentcrm_subscriber_count', 'stoute_fcrm_subscriber_count');