bootstrap+datatable+ajax,以bootstrap模式显示ajax成功数据为datatable

  • Post author:
  • Post category:其他


我试图显示ajax返回的成功数据在引导弹出窗口模式时点击link.i尝试,但我不知道在哪里我必须调用数据表函数。以bootstrap模式显示ajax成功数据为datatable

在index.php我有一个modal div和ajax函数来调用data.php。 data.php返回json编码值。

的index.php


Show Popup

$(document).ready(function() {

$(‘#myModal’).on(‘show.bs.modal’, function (e) {

var rowid = ‘1’;

var reference = ‘2’;

var nemix_id = ‘3’;

$.ajax({

type : ‘post’,

url : ‘data.php’, //Here you will fetch records

data : ‘rowid=’+ rowid+’&reference=’+reference+’&nemix_id=’+nemix_id, //Pass $id

success : function(data){

$(‘#example’).DataTable({

“ajax”: data

});

}

});

});

});

data.php

$sql_sel = mysqli_query($con,”SELECT * FROM `table`”);

$array = array();

$array[‘data’] = array();

while($res_sel = mysqli_fetch_row($sql_sel)){

$array[‘data’][] = $res_sel;

}

echo json_encode($array);