dongyong1942
dongyong1942
2019-05-12 01:01

给定的每一行必须为null或带有Google图表行的数组

已采纳

I am trying to draw a line from google chart samples and when I used th data.addRows to read my data number from Mysql database it gives me Every row given must be either null or an array. but if I put the data manually the line will draw but fetch from database table gives me error.

My code :

 <script type="text/javascript">
  google.charts.load('current', {'packages':['corechart', 'line']});
  google.charts.setOnLoadCallback(drawLineColors);

  function drawLineColors() {
    var data = new google.visualization.DataTable();
  data.addColumn('number', 'id');
   data.addColumn('number', 'temp');
   data.addColumn('number', 'hum');

    data.addRows([  ['id', 'temp', 'hum']


     <?php

       if(mysqli_num_rows($result)>0){
           while($row = mysqli_fetch_array($result)){
               echo " 
     [".$row['id'].",".$row['temp'].",".$row['hum']."],";
           }

       }

     ?>
       ]);

      var options = {
       hAxis: {
        title: 'Time'
       },
       vAxis: {
        title: 'Popularity'
      },
      colors: ['#a52714', '#097138']
     };

    var chart = new 

  google.visualization.LineChart(document.getElementById('chart_div'));
  chart.draw(data, options);
  }
</script>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • dongpu3792 dongpu3792 2年前

    You've already defined your row column names, so you should remove the first array in addRows.

    Change:

    data.addRows([  ['id', 'temp', 'hum']
    

    To:

    data.addRows([ 
    
    点赞 评论 复制链接分享