Graphic with Google Charts

Question

How can I fill this chart with Mysql data?

<?php
$sql = 'SELECT * FROM historicos';
$resultado = mysqli_query($conn, $sql); 
?>
<script type="text/javascript">
  google.charts.load('current', {'packages':['corechart']});
  google.charts.setOnLoadCallback(drawChart);

  function drawChart() {
    var data = google.visualization.arrayToDataTable([
      ['Horario', 'Sales'],
      ['2004',  0.500],
      ['2005',  0.1],
      ['2006',  0.200],
      ['2007',  0.30]
    ]);

    var options = {
      title: 'Company Performance',
      curveType: 'function',
      legend: { position: 'bottom' }
    };

    var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

    chart.draw(data, options);
  }
</script>

---

After a few adjustments it worked.. ` Function drawChart() { var data = google.visualization.arrayToDataTable([ ['Horario', 'Response time'], ]);

`

Answer 1

just replace

function drawChart() {
var data = google.visualization.arrayToDataTable([
  ['Horario', 'Sales'],
  ['2004',  0.500],
  ['2005',  0.1],
  ['2006',  0.200],
  ['2007',  0.30]
]);

for something like that

function drawChart() {
var data = google.visualization.arrayToDataTable([
  ['Horario', 'Sales'],
  <?php 
    $sql="sua query";
    $query=mysqli_query($con,$sql);
    while($result=mysqli_fetch_array($query,MYSQLI_ASSOC)){
      echo "['".$result['campo1']."', '.$result['campo2']."'],";
    }
  ?>
]);

of course this in a php file