如何将两列从数据库传递到一个数据表单元格 - How to Pass Two Columns from Database to one Datatable Cell

How to Pass Two Columns from Database to one Datatable Cell

我试图使用 ajax 将多列传递给 php 文件我想在一个数据单元格中显示多列。

这是适用于一个列

的代码

<script type="text/javascript">
        $(document).ready(function () {
            $('#datatable-responsive').DataTable({
                "columns": [
                    {"data": "fname"},
                    {"data": "phoneno"},
                    {"data": "email"},
                    {"data": "idno"},
                    {"data": "idno"},
                    {"data": "status"}
                ], 
                "processing": true,
                "fixedHeader": true,
                "serverSide": true,
                "ajax": {
                    url: '../lib/request/viewrequests.php',
                    type: 'POST'
                }
            });
        });
    </script>

如何更改上述内容以传递两列{"data": ""}

使用columns.render选项定义渲染函数。

例如：

"columns": [
    {"data": "fname"},
    {"data": "phoneno"},
    {"data": "email"},
    {"data": "idno"},
    {"data": "status"},
    {
       "data": null,
       "render": function(data, type, full, meta){
          return full["idno"] + ", " + full["status"];
       }
    }
],