get_var($wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->users WHERE DATE(user_registered) = %s", $date )); } echo '

'; wp_enqueue_script('google-charts', 'https://www.gstatic.com/charts/loader.js'); wp_add_inline_script('google-charts', sprintf(" google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable(%s); var options = { title: 'User Registration', legend: { position: 'none' }, hAxis: { title: 'Date', format: 'M/d/yy', }, vAxis: { title: 'Number of registrations', }, bars: 'vertical' }; var chart = new google.visualization.ColumnChart(document.getElementById('user_registration_chart')); chart.draw(data, options); } ", json_encode(array_merge([['Date', 'Registrations']], array_reverse(array_map(null, $dates, $user_counts)))))); }