Answers

• allan Posts: 63,364Questions: 1Answers: 10,449 Site admin

  March 2015

  Have a look at the ajax.data documentation. It has an example showing how to send data in a JSON format. To send column names, define the names using columns.name.

  Allan
• proecil Posts: 3Questions: 1Answers: 0

  March 2015 edited March 2015

  Thank you so much Allan.

  how can I trigger datatable ajax call to save data?

  This is actually my code:

  HTML

  <form ....>
     <table id="stockTable">
             -----------------------
                 Some rows
             -----------------------
     </table>
     <input type="submit" name="saveData" id="saveData" value="Save">
  </form>
  

  JS

  var oTable = $('#stockTable').dataTable({
      "columns": [
          { "name": "id", "width": "5%" },
          { "name": "name", "width": "25%" },
          { "name": "ean", "width": "15%" },
          { "name": "supplier", "width": "5%" },
      ],
      "ajax": {
          "contentType": "application/json",
              "url": "/controller/stock/save", // PHP function will save data
          "data": function ( d ) {
                    return JSON.stringify( d );
              }
      }
  });
  

  Is it possible to send data to server on custom javascript ajax call?

  Sorry for my rookie questions :/
• allan Posts: 63,364Questions: 1Answers: 10,449 Site admin

  March 2015

  You have input elements in the table? DataTables won't submit those values - you would need to do that yourself if that is what you wanted since DataTables doesn't know anything about them. Have a look at this example.

  Allan
• proecil Posts: 3Questions: 1Answers: 0

  March 2015 edited March 2015

  Hello again Allan,

  Exactly, my table hasn't input elements. This is my table format:

  <table id="stockTable">
     <thead>
      <tr>
          <th class="no-sort">ID</th>
          <th class="no-sort">Name</th>
          <th class="no-sort">EAN/th>
          <th class="no-sort">Supplier</th>
         </tr>
     </thead>
     <tbody>
         <tr>
           <td>18</td>
           <td>Jordan boots</td>
           <td>12345678901234</td>
           <td>Nike</td>
        </tr>
     </tbody>
  </table>
  

  Just want send data to server in json format with column names as index:

  ['stockTable': {'ID': 18, 'Name': 'Jordan boots', 'EAN': '4716659293521', 'Supplier': 'Nike'}]
  

  Thank you so much Allan.
• allan Posts: 63,364Questions: 1Answers: 10,449 Site admin

  March 2015

  Exactly, my table hasn't input elements

  Has or hasn't? Your HTML doesn't have input elements.

  If you want to get the data form the table use data() and you can then send that to the server.

  columns.data can be used to create JSON objects from an HTML table data source.

  Allan