Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  March 2021

  I'm not too clear what the problem is, I'm afraid. For us to help, please can you link to your page, or at the least post your code here so we can take a look,

  Colin
• ghafariz Posts: 14Questions: 6Answers: 0

  March 2021

  im sorry colin, i will give you screenshot about this

  -> datatables
  -> PHP file that accessing the data using ssp class
• tangerine Posts: 3,365Questions: 39Answers: 395

  March 2021

  Colin said

  please can you link to your page, or at the least post your code here so we can take a look,

  Your screenshot doesn't help.
• ghafariz Posts: 14Questions: 6Answers: 0

  March 2021

  i cannot give you access to the page, but the code for table:

  var table2 = $("#tabelrekap").DataTable({
      "processing": true,
      "serverSide": true,
      "ajax": {
          url:"../assets/data/list.php",
          data: {db: 'rekappelatihan'},
          type:"POST"
      },
      "autoWidth": false,
      "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
      "columnDefs":[
        {
          "className": 'centertext', "targets": [0]
        }]
    });
  

  and the ajax PHP file:

  <?php 
  require "connection.php";
  require 'class/ssp.php'; 
  
  if (isset($_POST['db'])) {
      $table = $_POST['db'];
      $primaryKey = 'id'; 
  
      if ($table == 'rekappelatihan') {
          $columns = array(
              array( 'db' => 'nip',           'dt' => 0 ),
              array( 'db' => 'persid',        'dt' => 1 ), 
              array( 'db' => 'nama',          'dt' => 2 ),
              array( 'db' => 'divisi',        'dt' => 3 )
          );
      }
  
      $dbDetails = array( 
      'host' => $dbhost, 
      'user' => $dbusername, 
      'pass' => $dbpassword, 
      'db'   => $dbname 
      ); 
       
      echo json_encode( 
          SSP::simple( $_POST, $dbDetails, $table, $primaryKey, $columns ) 
      );
  } else header("Location: ../../dashboard");
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  March 2021

  Everything looks OK, try removing the type:"POST",

  Colin
• ghafariz Posts: 14Questions: 6Answers: 0

  March 2021

  Hello colin, when i remove the type: "POST", it give me warning Invalid JSON response
• allan Posts: 63,819Questions: 1Answers: 10,517 Site admin

  March 2021 Answer ✓

  What is the response from the server in that case? The error message should have pointed you to this tech note which explains how you can get that information.

  Also, can you post the type:"POST" back, since that it what you are using for your SSP::simple( $_POST, ...) call.

  Finally, since you can't provide a link, can you use the debugger to give me a trace please - click the Upload button and then let me know what the debug code is.

  Allan
• ghafariz Posts: 14Questions: 6Answers: 0

  March 2021

  Sorry guys, turns out the data from database is empty all along, I'm soo sorry for wasting your time guys.. you can delete this post Admin