javascript - 将php数组转换为js selectpicker数组格式

Question

这就是我构建 sql 数据并发送回 ajax 调用的方式:

    (...)
    $sql = "SELECT id_option FROM options WHERE id_win = '{$id_win}'";
    $result = mysqli_query($conn, $sql);
    $rows =  array();
    while ($row = mysqli_fetch_array($result)) {
      $rows[] =  $row;
    }

    $data["win_data"] = $rows;
    echo json_encode($data);

这是我的 ajax 函数，用于从数据库获取 selectpicker 的选项:

$.ajax({
  type: "POST",
  url: ...,
  data: ...,
  dataType: "json",
  success: function(data)   {       
    $("#id_win").selectpicker("val", data.win_data);
   // $("#id_win").selectpicker("val", [1,3];
  }
});

data.win_data 变量应为:[1,3]

但如果我这样做:console.log(JSON.stringify(data.win_data));我得到:

[{"0":"1","id_option":"1"},{"0":"3","id_option":"3"}]

为选择器获取正确格式数组的最简单方法是什么？

Answer 1

这是因为$row是一个数组。看:https://secure.php.net/manual/pt_BR/mysqli-result.fetch-array.php

你必须这样使用:

    (...)
    $sql = "SELECT id_option FROM options WHERE id_win = '{$id_win}'";
    $result = mysqli_query($conn, $sql);
    $rows =  array();
    while ($row = mysqli_fetch_array($result)) {
      $rows[] =  $row['id_option'];
    }

    $data["win_data"] = $rows;
    echo json_encode($data);