Answers

• rf1234 Posts: 3,000Questions: 87Answers: 421

  December 2019 edited December 2019 Answer ✓

  $_POST is wrong. It should be $_POST["pinno"].

  If you want me to take a look post your server side code please.

  Also: I can't see what row.data() really is. Is it the data of one single row?

  Here is an example with a parent and a a child table that works:

  var selected;
  selected = parentTable.row({selected: true});
  if (selected.any()) {
      parentId = selected.data().ctr.id;
  }
  
  var editor = new $.fn.dataTable.Editor( {
      ajax: {
          url: 'actions.php?action=tblCtrCategoryWithValueRange',
          data: function ( d ) {
              d.parent_id = parentId;
          }
      },
      table: "#table",
      fields: [
                  ..............
          }
      ]
  } );
  

  Server side:

  if ( ! isset($_POST['parent_id']) || ! is_numeric($_POST['parent_id']) ) {
      echo json_encode( [ "data" => [] ] );
  } else {    
      Editor::inst( $db, 'ctr_has_ctr_category' ) 
      ->field(
          Field::inst( 'ctr_has_ctr_category.ctr_id' )->set( false ),
          ............
      )
      } )
     
      ->where( function ( $q ) {        
          $q  ->where( 'ctr_has_ctr_category.ctr_id', $_POST['parent_id'] );
      } )   
      ->process($_POST)   
      ->json();
  
• jojome Posts: 3Questions: 1Answers: 0

  December 2019

  @rf1234 thank you for your response. Yes row.data is the data of a single row. I verified that the

  var rowData = row.data() 
  

  has the correct value using the

  {
                  label: "PINNO",
                  name: "pinno",
                  def: rowData.pinno
              }
  

  as it will give the value of whatever row it belongs to whenever I create new entries.

  I am trying to send that value from ajax to server-side script using

  ajax: {
          url: "php/table.rpt2.php",
          type:"POST",
          data: function(d) {
                  d.pinno = rowData.pinno;
              }
          },
  

  Here is my Server-Side Script using the code you have given

  if ( ! isset($_POST['pinno']) || ! is_numeric($_POST['pinno']) ) {
      echo json_encode( [ "data" => [] ] );
      } else {   
      Editor::inst( $db, 'rpt')
      ->field(
          Field::inst( 'propertyid' )->set( false ),
          Field::inst( 'ownername' ),
          Field::inst( 'tdno' ),
          Field::inst( 'pinno' )  
      )
      } )
      
      ->where( function ( $q ) {       
          $q  ->where( 'pinno', $_POST['pinno'] );
      } )  
      ->process($_POST)  
      ->json();
  

  I received a warning "table id = table - Invalid JSON response". I did try another approach as I remove the if()else() statements then use a sample data '1'

   ->where( function ( $q ) {       
          $q  ->where( 'pinno','1' );
      } ) 
  

  to check if the code would give me a result.
• jojome Posts: 3Questions: 1Answers: 0

  December 2019

  thanks for the help @rf1234 ! Anyway I already solved the problem , with the example you have given I was able to understand the general gist on how to pass the value to server-side. Aside from that, I changed my script to this...

  Editor::inst( $db, 'rpt','propertyid' )
      ->field(
          Field::inst( 'propertyid' )->set(false),
          Field::inst( 'ownername' ),
          Field::inst( 'tdno' ),
          Field::inst( 'pinno' )
      )
      
      ->where( function ( $q ) {       
          $q  ->where( 'pinno', $_POST['pinno'] );
      } )  
      ->process($_POST)  
      ->json();
  

  I removed the if statement completely and it works fine now!