PHP mysql json Google charts

Question

I am working on a project where I am making use of the Google Charting API and I want to populate the chart using json with php mysql.

<?php 

$sql = $db->query("SELECT  COUNT(depots_id) AS count FROM inputs WHERE etat_input ='Valider'");


$results = array();
while ($var = $sql->fetch(PDO::FETCH_ASSOC)) {
        $results[] = $var;

}                   

$pie_chart_data = array();
foreach ($results as $result) {
    $pie_chart_data[] = array((int)$result['count']);
}
$pie_chart_data = json_encode($pie_chart_data);
?>

And the code javascript to building the chart :

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

        var data = google.visualization.DataTable();
        data.addColumn('number','depots_id');
        data.addRows({$pie_chart_data});

        var options = {
          title: 'My Daily Activities'
        };

        var chart = new google.visualization.PieChart(document.getElementById('piechart'));

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




 <div class="col-md-6 col-sm-6 col-xs-12">
              <div id="piechart" style="width: 900px; height: 500px;"></div>


            </div>

but it shows me no results.

Community · Accepted Answer · 2017-05-23 12:08:26Z

0

A similar question was asked here, and may help you identify the issue.

If this still doesn't help, could you confirm that your PHP correctly outputs the JSON as expected (and even post an example of the output)?

edited May 23, 2017 at 12:08

CommunityBot

11 silver badge

answered Jun 24, 2016 at 12:03

Jamie Weston

3484 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP mysql json Google charts

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related