javascript - Google柱形图mysql php不显示

Question

因为我已经编写了一些 Javascript 和 MySQL 来为谷歌图表填充动态数据，所以我几乎没有图表可以工作，但有一个图表让我感到困惑，我知道它应该可以工作，但我觉得我遗漏了一些东西，因为它根本不显示。

显示错误代码

Uncaught (in promise) ReferenceError: Amazon is not defined at columnCharttotal (Dashboard.php:144) at

这是Javascript代码

<script type="text/javascript">
    //begin columns chart 
    google.charts.load('current', {'packages': ['corechart']});
    google.charts.setOnLoadCallback(columnCharttotal);
    function columnCharttotal() {
        var data = google.visualization.arrayToDataTable([
            ["marketplace_name", "total_amount", {role: "style"}],
<?php
while (($rowResult = mysqli_fetch_array($totalresultchart, MYSQLI_ASSOC)) != NULL) {
    ?>
                [ <?php echo $rowResult["marketplace_name"]; ?>, <?php echo $rowResult["total_amount"]; ?>, "blue"]
    <?php
}
mysqli_free_result($totalresultchart);
?>
        ]);

        var view = new google.visualization.DataView(data);
        view.setColumns([0, 1,
            {calc: "stringify",
                sourceColumn: 1,
                type: "string",
                role: "annotation"},
            2]);

        var options = {
            title: "Total of all Europe sold",
            height: 400,
            bar: {groupWidth: "95%"},
            legend: {position: "none"},
        };
        var chart = new google.visualization.ColumnChart(document.getElementById("columnchart_values"));
        chart.draw(view, options);
    }
    //end of column chart
</script>

这是一段HTML代码

    <div class="col-sm-4">
            <div id="columnchart_values" style="width:100%"></div>
        <br>
    </div>

随着 Chrome 开发者工具显示在控制台上显示数据

Answer 1

看看这一行；

[ <?php echo $rowResult["marketplace_name"]; ?>, <?php echo $rowResult["total_amount"]; ?>, "blue"]

它的输出
[ Amazon.co.uk , 1231231, "Blue" ]

什么时候应该输出:
[ "Amazon.co.uk" , 1231231, "Blue" ]

因此；也更改行:

[ "<?php echo $rowResult["marketplace_name"]; ?>", <?php echo $rowResult["total_amount"]; ?>, "blue"]