Dynamic MySQL Pie-Chart Integration

Job ID: 37647288

Budget: $10 – $30 USD

I'm in need of a talented developer with proficiency in PHP, MySQL, and JQuery to I need someone to integrate https://canvasjs.com/php-charts/pie-chart/ with the mySQL query below to capture the values. Integration should be as an include to a PHP file. The integration also needs to update the values in the pie-chart when the date is changes by the $dateRange. This date is changed from a drop down in the PHP file and ueses the the Jquery below. Attached is the php file where the integration will be as an include file.

The Query
$dbDemographicsQuery = "SELECT Race, COUNT(Race) AS totalRace, Ethnicity
FROM Greeter_Detail
WHERE $dateRange
GROUP BY Race";


JQ used to update dates:
$('#month, #year').on('change', function() {
var url = window.location.href;
url += '?month=' + $('#month').val();
url += '&year=' + $('#year').val();
$('#table-data').load(url + ' #table-data > *');
});
Related categories: PHP JavaScript AJAX MySQL HTML