<?php

defined( 'ABSPATH' ) || die();

// Number of rows the last n days
function get_num_rows_last_n_days( $period_days ) {

	global $wpdb;

	$sql = sprintf(
		'select count(*) FROM %1$s WHERE UNIX_TIMESTAMP(date) >= %2$d',
		$wpdb->prefix . SimpleHistory::DBTABLE,
		strtotime( "-$period_days days" )
	);

	return $wpdb->get_var( $sql ); // PHPCS:ignore
}

printf(
	esc_html( __( '<b>%1$s rows</b> have been logged the last <b>%2$s days</b>', 'simple-history' ) ),
	(int) get_num_rows_last_n_days( $period_days ),
	(int) $period_days
);
