Answers

• maxstd Posts: 6Questions: 2Answers: 0

  October 2015

  replay
• allan Posts: 63,356Questions: 1Answers: 10,444 Site admin

  November 2015

  So you want the options in the second list to change based on the value selected int he first list?If so, then the dependent() method is probably the best way to do this. You would need to write a script on the server-side that will get the data for the list based on the value submitted, and then return the options as JSON data so Editor can update the list of options.

  Regards,
  Allan
• maxstd Posts: 6Questions: 2Answers: 0

  November 2015

  Thanks for the quick response!
  Do I understand correctly -

  1 step:

  create get_fields.php file

  <?
  $db = mysql_connect ("localhost","root",""); mysql_select_db ("testbase",$db);
  $sql="SELECT parent_id FROM testtable";
  $result = mysql_query($sql);
  $stack=array();
      while($row = mysql_fetch_array($result))
            { array_push($stack,array($row['parent_id '],$row['parent_id '])); }
  echo json_encode($stack);
  
  <?php
  >
  ```
  step 2:
  ?>
  
  
  add in my js file this code
  ```javascript
  var test= new Array({"label" : "a", "value" : "a"});
   
  function loader(){
  test.splice(0,1);
  $.ajax({
    url: 'php/get_fields.php',
    async: false,
    dataType: 'json',
    success: function (json) {
        for(var a=0;a<json.length;a++){
          obj= { "label" : json[a][0], "value" : json[a][1]};
          test.push(obj);
        }
      }
  });
  return test;
  }
  

  step 3:

  add in my js file this code

          columns: [
              {data: "test.id"},
              {data: "test.parent_id",ipOpts:loader()}
                         ],
  

  or this metod is wrong?

  Sorry Allan, but I can not understand how to relate these fields using dependent. I have tried only to show and hide, but no more.