Replies

• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  [code]<?php echo $sMiddlename; ?>[/code]
  You have not defined this variable in THIS php document.
  
  when you sent to the server, it opened a different document and defined $sMiddlename
  
  and since you hard coded the value in as "JAMES" I'm not really sure how you're trying to use the variable in this case (you could assign "JAMES" to it above or simply use the literal "JAMES")
• rjbelandres Posts: 6Questions: 0Answers: 0

  October 2011

  Thanks FBAS, Correct If i'm wrong, Yes, I have hard coded "JAMES" in the aoData just to see to it that "mname" variable has a value. My initial goal here is to parse 'mname' with 'JAMES' value to 'server_processing.php' but how come I get a response of JSON formatted result from my defined table and "No middle name".
  [code]
  <?php
  require 'serverside/server_processing.php';
  echo $sMiddlename;
  ?>
  [/code]
  
  in the serverside:
  
  [code]
  $sMiddlename="";
  if (empty($_GET['mname']) && $_GET['mname']=="")
  {$sMiddlename = "No middle name";}
  else{$sMiddlename = $_GET['mname'];}
  [/code]
  
  Still I can't get to view the value of $_GET['mname']. Please FBAS tell me what am I missing here.
  
  Thanks in advance and more power
• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011 edited October 2011

  You can add any values you want to the JSON that is returned by the server_processing.php script (or equivalent server side script)
  
  the default script returns an JSONified version of this:
  [code]
  /*
  * Output
  */
  $output = array(
  "sEcho" => intval($_GET['sEcho']),
  "iTotalRecords" => $iTotal,
  "iTotalDisplayRecords" => $iFilteredTotal,
  "aaData" => array() // the db data is attached here in code below this
  );
  [/code]
  (good reference for the server side values is here: http://www.datatables.net/usage/server-side )
  
  You are free to add any values to this object:
  [code]
  /*
  * Output
  */
  $output = array(
  "sEcho" => intval($_GET['sEcho']),
  "iTotalRecords" => $iTotal,
  "iTotalDisplayRecords" => $iFilteredTotal,
  "aaData" => array(),
  "sMiddlename" => $sMiddlename // add this and any other values you wish to the output json.... I do this a bit for debugging. returning the $sQuery or other values of interest
  );
  [/code]
  
  --------------
  
  now the next question is: how can you retrieve that value on the client side? you can access the JSON returned in fnServerData
  
  [code]
  fnServerData: function (sSource,aoData,fnCallback ) {
  aoData.push( { "name": "mname", "value": "JAMES" } );
  $.ajax( {
  "dataType": 'json',
  "type": 'GET',
  "url": 'serverside/server_processing.php',
  "data": aoData,
  "success": function (data, textStatus, jqXHR) {
  data.sMiddlename; // do something with sMiddleName.. "data" is the JSON data returned. you could access all the other parts of "data" if you wish, as well.
  
  fnCallback(data,textStatus,jqHXR); // call DT's callback function for the normal processing
  }
  } );
  }
  [/code]
  
  reference for the "success" (and $.ajax() ) is at http://api.jquery.com/jQuery.ajax/
• rjbelandres Posts: 6Questions: 0Answers: 0

  October 2011

  Thanks FBAS for the immediate reply
  I have this code that works base on your reply
  
  client:
  [code]
  $('#example').dataTable( {
  bProcessing: false,
  bServerSide: true,
  bRetrieve:true,
  bJQueryUI: true,
  sPaginationType: 'full_numbers',
  sAjaxSource: "serverside/server_processing.php",
  fnServerData: function (sSource,aoData,fnCallback ) {
  aoData.push( { "name": "mname", "value": "JAMES" } );
  $.ajax( {
  "dataType": 'json',
  "type": 'GET',
  "url": 'serverside/server_processing.php',
  "data": aoData,
  "success": function (data, textStatus, jqXHR) {
  alert(data.sMiddlename);
  fnCallback(data,textStatus,jqHXR);
  }
  } );
  }
  });
  [/code]
  
  server side:
  [code]
  $sMiddlename="JAMES";
  $output = array(
  "sEcho" => intval($_GET['sEcho']),
  "iTotalRecords" => $iTotal,
  "iTotalDisplayRecords" => $iFilteredTotal,
  "aaData" => array(),
  "sMiddlename" => $sMiddlename
  );
  [/code]
  
  But if I do this on the server side the alert is blank
  [code]
  $sMiddlename="";
  if (isset($_REQUEST["mName"])) $sMname = $_REQUEST["mName"];
  $output = array(
  "sEcho" => intval($_GET['sEcho']),
  "iTotalRecords" => $iTotal,
  "iTotalDisplayRecords" => $iFilteredTotal,
  "aaData" => array(),
  "sMiddlename" => $sMiddlename
  );
  [/code]
  
  Do I have to check for any initialization on my php.ini or something. Why can't I get to my GET or POST variables return to my client page.
  
  Thanks in advance and more power datatables
• fbas Posts: 1,094Questions: 4Answers: 0

  October 2011

  it's possible your version of PHP doesn't support $_REQUEST, in which case either use $_GET or $_POST (depending on which you are using) or merge the arrays yourself to create your own $_REQUEST
  
  [code]
  $_REQUEST = array_merge($_GET, $_POST); // the order you put $_GET and $_POST affects which takes precendence. last added array will overwrite previous array values if the keys are the same
  [/code]