Category: charts

Show analytics of registered users for last 12 months using chart

I’m trying to get all users for the last 12 months from database and show some statistics using chart.For that purpose I’m using chartJS. $registeredUsersData = $connection->fetchAll( ‘SELECT COUNT(id) AS registered_users, CONCAT(MONTHNAME(created_on), ” “, YEAR(created_on)) AS created_on FROM users WHERE…