通过 AJAX 将 PHP 表单变量传递给 Google Chart

我有一个 PHP 表单下拉列表，其中包含数据库中的表名，该列表发布了用户所做的选择。 我想使用该发布的表名称来生成Google图表。 我在将变量通过 AJAX 传递到我的 PHP 脚本时遇到问题，该脚本为 Google 图表生成 JSON。

我知道我的 JSON 格式正确，我只需要将发布的表名传递给制作 JSON 对象的 PHP 脚本。

以下是显示图表的页面上的 javascript 的代码：

<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);
function drawChart() {
  //this is where I save the posted url parameter, format is tableDDL=tableName
  var url = <?php echo json_encode($_POST) ?>;
  var jsonData = $.ajax({
      url: "getData.php",
      type: "POST",
      data: ({url: tableDDL}),
      dataType:"json",
      async: false
      }).responseText;
  // Create our data table out of JSON data loaded from server.
  var data = new google.visualization.DataTable(jsonData);
  // Instantiate and draw our chart, passing in some options.
  var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
  chart.draw(data, {width: 400, height: 240});
}
</script>

这是我生成JSON对象的PHP脚本：

<?php 
include 'dbConnect.php';
$table = $_POST['url'];
$sql = "SELECT row1, row2 from " . $table;
$array = array();
$array['cols'][] = array("id" =>"", "label" => "Row1", "pattern" => "", 'type' => 'string');
$array['cols'][] = array("id" =>"", "label" => "Row2", "pattern" => "", 'type' => 'number');
if ($result = $conn->query($sql)) {
    while ($row = $result->fetch_assoc()) {
        $array['rows'][] = array('c' => array( array('v' => $row["row1"]), array('v' => $row["row2"])));
    }
}
echo json_encode($array);
?>

编辑：我已经将我的代码更新为我尝试传递给我的 PHP 脚本的静态值。代码仍然不起作用。

我的错误是：JSQL ajax error: parsererror, SyntaxError: Unexpected token <

这是我一直在尝试的更新的javascript：

<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
google.setOnLoadCallback(drawChart);
function drawChart() {
  var jsonData = $.ajax({
    url: "getData.php",
    type: "POST",
    data: '{table: tableDDL}',
    dataType:"json",
    async: false,
      success: function(response, textStatus, jqXHR){ 
          },         
      error: function(jqXHR, textStatus, errorThrown){             
          console.log("JSQL ajax error: " + textStatus + ", " + errorThrown);
          }, 
      complete: function(){
          }
    }).responseText;
  var jsonChartData = $.parseJSON(jsonData);
  console.log("jsonChartData: " + jsonChartData);
  // Create our data table out of JSON data loaded from server.
  var data = new google.visualization.DataTable(jsonChartData);
  // Instantiate and draw our chart, passing in some options.
  var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
  chart.draw(data, {width: 400, height: 240});
}
</script>

这是应该从 AJAX 函数调用并获取传递数据的更新 PHP：

<?php
include 'dbConnect.php';
$table = $_POST['tableDDL'];
$sql = "SELECT row1, row2 from " . $table;
// check connection
if ($conn->connect_errno) {
    printf("Connect failed: %s'n", $conn->connect_error);
    exit();
}
$array = array();
$array["cols"][] = array("id" =>"", "label" => "Row 1", "pattern" => "", "type" => "string");
$array["cols"][] = array("id" =>"", "label" => "Row 2", "pattern" => "", "type" => "number");
if ($result = $conn->query($sql)) {
    while ($row = $result->fetch_assoc()) {
        $array["rows"][] = array("c" => array( array("v" => $row["row1"]), array("v" => $row["row2"])));
    }
}
echo json_encode($array);
?>