function ur_registration_stats_display() {
global $wpdb;
// Get today's new users count
$today_users = $wpdb->get_var(
$wpdb->prepare(
"SELECT COUNT(ID) FROM $wpdb->users WHERE DATE(user_registered) = CURDATE()"
)
);
// Get registrations for the last 7 days
$last_7_days_users = $wpdb->get_var(
$wpdb->prepare(
"SELECT COUNT(ID) FROM $wpdb->users WHERE DATE(user_registered) BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()"
)
);
// Get registrations for the last 30 days
$last_30_days_users_data = $wpdb->get_results(
$wpdb->prepare(
"SELECT DATE(user_registered) as registration_date, COUNT(ID) as user_count FROM $wpdb->users WHERE DATE(user_registered) BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE() GROUP BY DATE(user_registered)"
),
ARRAY_A
);
$last_30_days_users = 0;
foreach ($last_30_days_users_data as $data_point) {
$last_30_days_users += $data_point['user_count'];
}
// Get registrations for the last 90 days
$last_90_days_users = $wpdb->get_var(
$wpdb->prepare(
"SELECT COUNT(ID) FROM $wpdb->users WHERE DATE(user_registered) BETWEEN CURDATE() - INTERVAL 90 DAY AND CURDATE()"
)
);
// Get total registrations
$total_users = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users");
// Display the statistics
echo "Today's New Users: $today_users
";
echo "Registrations in Last 7 Days: $last_7_days_users
";
echo "Registrations in Last 30 Days: $last_30_days_users
";
echo "Registrations in Last 90 Days: $last_90_days_users
";
echo "Total Registrations: $total_users
";
// Display chart
echo '';
// Prepare data for the chart
$chart_labels = [];
$chart_data = [];
foreach ($last_30_days_users_data as $data_point) {
$chart_labels[] = $data_point['registration_date'];
$chart_data[] = $data_point['user_count'];
}
$chart_labels = json_encode($chart_labels);
$chart_data = json_encode($chart_data);
?>
Redirecting... - FisheryAPP
Обращение к ВКонтакте, подаждите пожалуйста...