Passing the total row count to Datatables

Question

I've got a datatables implementation that does an ajax request tho $_SERVER['PHP_SELF']. I run my query to get all records when the page loads. However, the first ajax call will do this again without limit. I was wondering if it is possible to pass the total row count in the initial ajax request. This is my datatables code:

var myTable = $('.datatable').DataTable({
    "serverSide": true,
    "processing": true,
    "paging": true,
    "searching": { "regex": true },
    "lengthMenu": [ [10, 25, 50, 100, -1], [10, 25, 50, 100, "All"] ],
    "pageLength": 10,
    "ajax": {
        "type": "POST",
        "url": "<?= $_SERVER['PHP_SELF']; ?>",
        "dataType": "json",
        "contentType": 'application/json; charset=utf-8',
        "data": function (data) {
            // Grab form values containing user options
            var form = {};
            $.each($("form").serializeArray(), function (i, field) {
                form[field.name] = field.value || "";
            });
            // Add options used by Datatables
            var info = { "start": 0, "length": 10, "draw": 1 };
            $.extend(form, info);
            return JSON.stringify(form);
        },
        "complete": function(response) {
            console.log(response);
       }
    }
});

with this "url": "<?= $_SERVER['PHP_SELF']; ?>" you are likely to not get a reasonable response. Should be a seperate php. — Jeff
– Jeff, Commented Oct 6, 2017 at 14:44
@Jeff I check if the request is ajax and return the appropriate value accordingly. — Peter
– Peter, Commented Oct 9, 2017 at 6:05

Peter · Accepted Answer · 2017-10-11 07:36:29Z

1

I've found the solution to my issue which in terms seemed to be multiple issues.

I had the wrong value for recordsTotal thinking it was supposed to be the amount of rows I wanted to retrieve in my ajax call.
"contentType": 'application/json; charset=utf-8', seemed to break my ajax request.
I now pass the total number of rows using:

"data": { "totalRows": "", },
I now set $totalData initially using a count on my query results and then overwriting it using $_REQUEST.

answered Oct 11, 2017 at 7:36

Peter

9,1868 gold badges69 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

Passing the total row count to Datatables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related