php - Every row given must be either null or an array with google chart line

459

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 meEvery 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>
71

Answer

Solution:

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

Change:

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

To:

data.addRows([ 

People are also looking for solutions to the problem: php - Query search # going up in ascending order rather then fetching the actual code from database

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.