javascript - 如何合并数据表字段？

Question

数据库表字段:id,first_name,last_name,email

数据表:全名，电子邮件(无 ID)？

 <script type="text/javascript">
        $(document).ready(function () {


            var table = $('#havuz_table').DataTable({

                "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],

                "ajax": "{{URL::to('ajaxUzmanListesi/')}}",
                "language": {
                    "url": '/lib/datatables/language/Turkish.json'
                },
                "columns": [
                    {
                        "mData": null ,
                        "mRender" : function ( data, type, full ) {
                            return full['first_name']+''+full['last_name'];}
                    }

                ]

});

});

Answer 1

试试这个:

"columns": [{
        "data": null,
        "title": "Name",
        "render": function(data, type, full) {
            return full['first_name'] + ' ' + full['last_name'];
        }
    },
    {
        "data": "email",
        "title": "Email"
    }
]

工作 JSFiddle here .希望对您有所帮助。