DataTables - external Array

Question

Happy Evening All,

I am trying to add formatting to the data that was collected in MySql and display with its corresponding array value.

MySql
name, age, gender (1=M, 0=F)
Max, 18, 1

Current DataTable Display
Max, 18, 1

DataTable (desired version)
Max, 18, M

How to add array to datatable serverside php. Also tried using Formatter - unable to get the desired display. Any help would be greatful.

something tried at my end does't work.

array( 'db' => 'gender', $arrayName('dt') => 8 ),

Thanks,

Sylvain Guilbert · Accepted Answer · 2016-05-24 13:17:40Z

1

you can define each column :

$('#table').DataTable({    
"columns": [
{
    "title": "gender.", 
    "data": "gender", 
    "render": function (data, type, row) {
                 return data ? "M" : "F";
                 }
}
]
});

answered May 24, 2016 at 13:17

Sylvain Guilbert

7324 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bala Krishnan D Over a year ago

Thanks Sylvain, tried with the above code - no luck - I am using ajax - server side to populate MySql data.

Bala Krishnan D Over a year ago

Following is code used - but it result with only male for both '0' and '1'. ` "title": "gender.", "data": "gender", render: function (data, type, row) { return data ? "Male" : "Female"; }}, `

Sylvain Guilbert Over a year ago

can you console.log() your values ? data ? "M" : "F"; is just a short syntax for if else

Bala Krishnan D · Accepted Answer · 2016-06-02 09:49:16Z

0

Complete Working solution :)

<script type="text/javascript">
$(document).ready(function() {
var genderValue = [
"Female", //0
"Male", // 1 
];
$('#example').DataTable( {
        "processing": true,
        "serverSide": true,
        "ajax": "scripts/server_processing.php",
        "columns": [
                { data : gender, 
                render: function (data, type, row) {
                return genderValue[data]
                }},
                    ]
        } );
} );
</script>

answered Jun 2, 2016 at 9:49

Bala Krishnan D

1311 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

DataTables - external Array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related