custom variables php/ajax

tomish

Apologies if this question has been answered to death, but could someone give me a clearer explanation about specifically how to send a name/value pair to a php file that will return a MySQL query json object.

I'd like to send my php file the equivalent of http://myserver/myphp.php?provider='Company A'&program_type='Program B'

I looked at this example but couldn't figure out to send that name/value pair.(provider and program_type)

http://www.datatables.net/release-datatables/examples/server_side/custom_vars.html

Could someone show me how 'provider' and 'program_type' with their associated values would play in the example provided by dataTable?

Thanks so much!

zeinerrj

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

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

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