Answers

• zeinerrj Posts: 11Questions: 1Answers: 2

  August 2015 Answer ✓

  Hello tomish,

  Hopefully this will help. The Ajax processing example shows:

  "data": function ( d ) {
       d.myKey = "myValue";
       // d.custom = $('#myInput').val();
       // etc
  }
  

  A post variable called myKey will be passed by the Ajax call and have a value of myValue and custom would have whatever value was typed into the myInput form field. They would be accessed on the server side by $_REQUEST['myKey'] and $_REQUEST['custom'].

  So I believe that you are looking for is something like:

  "data": function ( d ) {
       d.provider = <provider value>;
       d.program_type = <program type value>
  }
  

  And they would be accessed on the server side by either request or post.

  I hope I didn't confuse you further. ;)
• INTONE Posts: 153Questions: 58Answers: 6

  August 2015 Answer ✓

  The link you provided gives the tutorial on how to get it done. if you read it carefully you will understand. However I will attempt to give a little more explanation.

  Take a look at this javascript.

      $('#contact').DataTable( {
      dom: "Tfrtip",
     ajax: {
      url: "php/contact.php",
      type: "POST",  // you can use GET
       data: {
        "name1": "value1",//send value to server as $_POST['name1'] 
        "name2":"value2"
     }
     },
      serverSide: true,
      processing:true
  
    });
  

  take a look at this PHP server side script:

     // DataTables PHP library
     include( "lib/DataTables.php" );
  
    // Alias Editor classes so they are easy to use
  
    use
  
      DataTables\Editor,
  
       DataTables\Editor\Field,
  
      DataTables\Editor\Format,
  
      DataTables\Editor\Join,
  
      DataTables\Editor\Validate;
  
     $data = Editor::inst( $db, 'tracking','tracking_id' )->fields(
       //load fields here
     );
  
   //now use your custom $_POST or $_GET however you wish, example
   //in this case i am using POST to filter query with a where clause when
  //editor is not in edit or create state.
   if ( !isset($_POST['action']) ) {
      if(isset($_POST['name1'])){
        $data->where( $key = 'name1', $value = $_POST['name1'], $op = '=' );
     }
  
   }
  
   $out = $data->process( $_POST )->data(); 
  
   //output
   echo json_encode( $out );
  
• tomish Posts: 17Questions: 11Answers: 0

  August 2015

  Thanks for both these postings! They make sense and I tried both - they do work but only up to a point. I get a '200 ok' message in my Chrome developer tool/network pane but an empty result set This is the query string submitted, which seems very verbose, and my variables are clearly in there, but no data returned :(

  Sorry for the verbosity of this URL but it might provide some clues:

  http://myServer/get.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=0&order%5B0%5D%5Bdir%5D=asc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&user=2&provider=CCC&program_type=Academic+Advising&_=1438894133525