Jquery Datatable Save state in DB not in client side

Question

I need to save state of datatable in DB.I want to have a save state button when it is pressed what should i do in on click event of save state button ? Which functions I have to override to send ajax request to server containing state of datatable? I also want to load from the saved state from DB.

@madalinivascu DataTables has the option of being able to save the state of a table (its paging position, ordering state etc) so that is can be restored when the user reloads a page, or comes back to the page after visiting a sub-page. — Himanshu dua
– Himanshu dua, Commented Sep 13, 2016 at 5:28
I want to save ordering state of datatable in DB . By default it is stored in local storage. For more details refer datatables.net/reference/option/stateSave — Himanshu dua
– Himanshu dua, Commented Sep 13, 2016 at 5:32
@madalinivascu If a user have changed some ordering of table it is stored in client side. If user login in different machine he will not be able to see those changes if state is saved on client side.So I want to save the satate on server side rather than client side — Himanshu dua
– Himanshu dua, Commented Sep 13, 2016 at 5:39

madalinivascu · Accepted Answer · 2016-09-13 05:45:33Z

3

Use the stateSaveCallback callback

"stateSaveCallback": function (settings, data) {
    // Send an Ajax request to the server with the state object
    $.ajax( {
      "url": "/state_save",
      "data": data,
      "dataType": "json",
      "type": "POST",
      "success": function () {}
    } );

for more info:https://datatables.net/reference/option/stateSaveCallback

For loading use stateLoadCallback callback

 "stateLoadCallback": function (settings) {
    var o;
    $.ajax( {
      "url": "/state_load",
      "async": false,
      "dataType": "json",
      "success": function (json) {
        o = json;
      }
    } );

    return o;
  }

more info: https://datatables.net/reference/option/stateLoadCallback

answered Sep 13, 2016 at 5:45

madalinivascu

32.4k4 gold badges41 silver badges59 bronze badges

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

Comments

codelock · Accepted Answer · 2016-09-13 05:26:49Z

0

I am assuming that by "save state" you actually mean save changes to a database ?

If so, what exactly do you wish to store in a database ?

By example:

The classic scenario is having a form that contains input elements such as a user profile or contact form etc..

What you usually do from the client, is bundling your form input data and sending it to the server using AJAX, then on the server side the form data is being processed and finally saved to a database (e.g MySQL).

The original (and older) method is to have a submit button in your form, and make sure to set your form's "action" and "method" attributes - then when the submit button is clicked, the form data will be submitted to the path given in the "action" attribute which is a path on the server that should have server-side code for processing and storing the data in a database.

Hope it helps a bit

answered Sep 13, 2016 at 5:26

codelock

7805 silver badges8 bronze badges

1 Comment

Himanshu dua Over a year ago

DataTables has the option of being able to save the state of a table (its paging position, ordering state etc) so that is can be restored when the user reloads a page, or comes back to the page after visiting a sub-page.

Collectives™ on Stack Overflow

Jquery Datatable Save state in DB not in client side

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related