' ;
global $wpdb ;
$apvc_table = APVC_DATA_TABLE;
$currentDateFull = date( 'Y-m-d H:i:s', strtotime( "-10 minute" ) );
$YesterDay = date( 'Y-m-d H:i:s', strtotime( "-1 day" ) );
$visits_today = $wpdb->get_var( "SELECT COUNT(*) FROM {$apvc_table} WHERE date >= '{$YesterDay}'" );
$total_visits = $wpdb->get_var( "SELECT COUNT(*) FROM {$apvc_table}" );
$total_visitors = $wpdb->get_var( "SELECT COUNT(*) FROM {$apvc_table} GROUP BY ip_address" );
$total_countries = $wpdb->get_var( "SELECT COUNT(*) FROM {$apvc_table} GROUP BY country" );
?>
' ;
echo $args['after_widget'] ;
}
public function form( $instance )
{
$title = ( !empty($instance['title']) ? $instance['title'] : esc_html__( '', 'apvc' ) );
?>