[PHP 5.5] PHP mysql json Google charts

Je travaille sur un projet où je fais usage de l'API Google Charting.

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?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);
?>

Et le code javascript pour la construction du chart:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<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>

Mais aucun résultat:(. Une idée. Merci