使用JSON将MySQL数据转换为Highcharts饼图

Question

I am Trying to create a HighCahrts JS's PIE CHART using The Data I fetched From the MySQL Data, Which I fetched into The JSON Format .

Here is my php Code :

foreach($row as $rec)  
{  
$json_array['label']=$rec['user_type_detail'];  
$json_array['value']=$rec['id']; 

array_push($json_data,$json_array);  
}  
?> 

The JSON I am Getting is :

[{"label":"Government Doctor","value":"8"},
 {"label":"Private Doctor","value":"5"},
 {"label":"Public Doctor","value":"6"},
 {"label":"Student","value":"4"}
] 

But THe problem is that Pie Chart is not being displayed on the Page. its just Blank.

I am USing the div with id="container"

And Here is my Script :

<script type="text/javascript">

Highcharts.chart('container', {
chart: {
    plotBackgroundColor: null,
    plotBorderWidth: null,
    plotShadow: false,
    type: 'pie'
},
title: {
    text: 'Browser market shares in January, 2018'
},
credits: {
  enabled: false
},
exporting: { enabled: false } ,
tooltip: {
    pointFormat: '{series.name}: <b>{point.percentage:.1f}%</b>'
},
plotOptions: {
    pie: {
        allowPointSelect: true,
        cursor: 'pointer',
        dataLabels: {
            enabled: true,
            format: '<b>{point.name}</b>: {point.percentage:.1f} %',
            style: {
                color: (Highcharts.theme && 
Highcharts.theme.contrastTextColor) || 'black'
            }
        }
    }
},
series: [{
    name: 'Brands',
    colorByPoint: true,
    data:<?php echo json_encode($json_data) ?>
}]
});
</script>

Answer 1

You need to use the data format required by Highcharts:

    data: [{
            "name": "Government Doctor",
            "y": 8
        },
        {
            "name": "Private Doctor",
            "y": 5
        },
        {
            "name": "Public Doctor",
            "y": 6
        },
        {
            "name": "Student",
            "y": 4
        }
    ]

Live demo: http://jsfiddle.net/BlackLabel/ce72x3bu/

API Reference: https://api.highcharts.com/highcharts/series.pie.data