export data to php

alzambo

Hi,
I need to export table filtered data to http://www.tinybutstrong.com php script.
How can I access datatables filtered data?

Thank you,
Alex

allan

What have you tried? The rows().data() method is what I would suggest with a selector-modifier for rows() to get only the filtered rows.

Allan

alzambo

Good, thank you so much.

I managed to access filtered data with rows.data() but which would be the cleanest way to pass that object to ajax call?

This one:

        // Export
        $('#export').click(function () {
            $.ajax({
                url     : 'generaFascetta.php',
                type    : 'post',
                data    : table.rows({search:'applied'}).data(),
                dataType: 'json',
                success : function(returnedData) {
                    console.log(returnedData);
                }
            });
        });

will produce an error:

TypeError: 'insertCell' called on an object that does not implement interface HTMLTableRowElement.

Alex

allan

Try:

data: table.rows({search:'applied'}).data().toArray()

Otherwise you are passing jQuery a DataTables API instance, which it might not like.

Allan