使用PHP的谷歌可视化 - Google Visualization with PHP

Google Visualization with PHP

本文关键字：可视化谷歌 PHP 使用 | 更新日期: 2023-09-27

我很好奇是否可以将PHP代码注入谷歌可视化的数据表，而不是使用JSON字符串。

<html>
  <head>
    <!--Load the AJAX API-->
    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">
      // Load the Visualization API and the piechart package.
      google.load('visualization', '1.0', {'packages':['corechart']});
      // Set a callback to run when the Google Visualization API is loaded.
      google.setOnLoadCallback(drawChart);
      // Callback that creates and populates a data table,
      // instantiates the pie chart, passes in the data and
      // draws it.
      function drawChart() {
        // Create the data table.
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Topping');
        data.addColumn('number', 'Slices');
        data.addRows(
<?php
some PHP code that echoes the same format like this 
[['Mushrooms', 3],['Onions', 1],['Olives', 1],['Zucchini', 1],['Pepperoni', 2]]
?>);
        // Set chart options
        var options = {'title':'How Much Pizza I Ate Last Night',
                       'width':400,
                       'height':300};
        // Instantiate and draw our chart, passing in some options.
        var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <!--Div that will hold the pie chart-->
    <div id="chart_div"></div>
  </body>
</html>

我正在尝试在谷歌可视化上制作事件。非常感谢任何帮助/建议。谢谢

@scibuff有正确的想法。

$my_array = array(
                  array('Mushrooms',3),
                  array('Onions',1),
                  array('Olives',1),
                  array('Zucchini',1),
                  array('Pepperoni',2)
);
echo json_encode( $my_array );

将为您提供[["Mushrooms",3],["Onions",1],["Olives",1],["Zucchini",1],["Pepperoni",2]]