dongpu2694
2016-04-14 03:33
浏览 72
已采纳

使用带有php和MySql的highcharts时,只显示我的标题

I am new to highcharts. I can get the title to show up, but for some reason the x and y axis data won't come up. I am getting my data from a database with php, along with encoding it with JSON. Here is my HTML:

 <!DOCTYPE HTML>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <script src="https://code.jquery.com/jquery-1.12.0.min.js"></script>
    <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
    <script type="text/javascript">

        $(document).ready(function() {

            var options = {
                chart: {
                    renderTo: 'container',
                    type: 'bar'
                },
                title: {
                    text: 'TCP Upload Speed Averages for Los Angeles County in 2012',
                    x: -20 //center
                },
                subtitle: {
                    text: '',
                    x: -20
                },
                xAxis: {
                    categories: []
                },
                yAxis: {
                    min:0,
                    title: {
                        text: 'TCP Upload Averages'
                    },
                    labels: {
                    overflow: 'justify'
                }
                },
               legend: {
                layout: 'vertical',
                align: 'right',
                verticalAlign: 'top',
                x: -10,
                y: 100,
                borderWidth: 0
            }, 

               plotOptions: {
                bar: {
                    dataLabels: {
                        enabled: true
                    }
                },
                series: {

                   stacking:'percent' 
                }

            },
                series: []
            };
            $.getJSON("2012Data.php", function(json) {



                options.xAxis.categories = json[0]['data'];//xAxis: {categories: []}

                options.series[0] = json[1];



                //chart = new Highcharts.Chart(options);
            });
            chart = new Highcharts.Chart(options);
        });

    </script>
    <script src="highstock.js" ></script>
    <script src="http://code.highcharts.com/modules/exporting.js"></script>

</head>
<body>
    <div id="container" style="width: 600px; height: 400px; margin: 0 auto"></div>
</body>

Here is my JSON data from the php:

[{"name":"Providers","data":["AT&T","Sprint","T-Mobile","Verizon"]},{"name":"Averages","data":[972.03790849673,679.63696969697,992.06606060606,4520.2101851852]}]

Thanks for the help!

1条回答 默认 最新

相关推荐 更多相似问题