xeditable select2将远程数据提取到选择字段中


xeditable select2 remote data fetching into a select field

我正试图通过从数据库中提取emote数据来实现xeditable插件select2,我的数据提取脚本返回json数据,但ajax调用没有检索到它。我的代码如下所示:HTML通过ID 找到

Javascript

$('#username ').editable({
  type: 'select2',  
  url: '../payments/person.php',    
  pk: 1,    
  onblur: 'submit',
  emptytext: 'None',
     select2: {
                placeholder: 'Select a Requester',
                allowClear: true,
                width: '230px',
                minimumInputLength: 3,
                id: function (e) {
                    return e.person_id;
                },
                ajax: {
                    url: '../payments/person.php',
                    dataType: 'json',
                    data: function (term, page) {
                        return { query: term };
                    },
                    results: function (data, page) {
                        return { results: data };
                    }
                },
                formatResult: function (employee) {
                    return employee.name;
                },
                formatSelection: function (employee) {
                    return employee.name;
                },
                initSelection: function (element, callback) {
                    return $.get('../payments/person.php', { query: element.val() }, function (data) {
                        callback(data);
                    }, 'json'); //added dataType
                }
            }
});

Php代码以json格式返回数据,如下所示:

[{"id":"1","name":"AdminAdmin"}]

我确信我的ajax代码没有正确收集数据,当我点击它时,它也不会加载弹出窗口。如果有人能帮忙的话。

我的php获取代码如下所示:

   if (isset($_POST['person_id'])) {
   $id = trim($_POST['person_id']);
     $result = array();
   $id = mysqli_real_escape_string($con,$id);
   $res = mysqli_query($con,"SELECT person_id,Concat(first_name ,last_name) as name FROM k_people ");
while ($row = mysqli_fetch_array($res)) {
$result[] = array(
  'id' => $row['person_id'],
  'text' => $row['name']
);
}
echo json_encode($result);

}

我认为[{"id":"1","name":"AdminAdmin"}]应该是[{"id":"1","text":"AdminAdmin"}]