實現基於json的串聯功能表

 對於ajax應用來說，把和控制項榜定的資料用json來承載，既可以避免頻繁調用httprequest，也可以避免xml帶來的效能解釋。

假設我們要有一個串聯功能表，顯示使用者組以及下面的使用者，我們可以這樣做

      $group_user = Array();   
      $groups = $db->getAll("select * from $dbutils->group");

      for ($i = 0, $count = count($groups); $i < $count; $i++) {
     
         $users = $db->getAll("select * from $dbutils->user_group ug,$dbutils->user u where ug.user_id = u.user_id and ug.group_id = ".$groups[$i]['group_id']);
         $group_user[$groups[$i]['group_id']]['users'] = $users;
      }

      $json = new JSON(JSON_LOOSE_TYPE);
      $group_user_json_data = $json->encode($group_user);  //將資料從php數群組轉換成javascript數組
     

     
      $group_user_javascript_data = '<script type="text/javascript">' . "/n"
   . '<!-- // associated javascript data' . "/n"
   . 'var group_user_json_data = '
   . $group_user_json_data . ";/n"
   . '-->' . "/n"
   . '</script>';

 

在模板表單裡面

<?php

 echo $group_user_javascript_data;    //把json的資料顯示出來
 

?>

<script language="javascript" type="text/javascript" >
 
function addOptions(optionList, optionMenu)
{
 removeOptions(optionMenu);  // clear out the options
 for (var i=0; i < optionList.length; i++) {
  
   optionMenu[i] = new Option(optionList[i].truename, optionList[i].user_id);

  }

}

 

function removeOptions(optionMenu)
{
  len = optionMenu.options.length;
  for (var i=len-1; i >=0 ; i--) {
  
    optionMenu.options[i] = null;

  }

}

 
function change_group() {

  var users = group_user_json_data[document.getElementById('receive_group').value]['users'];//從json裡面得到對象

  addOptions(users, document.getElementById('receive_user'))

 
  
}
</script>

 

                                    <tr>
                                      <td width="10%" >接收部門</td>
                                      <td width="80%"><select name="receive_group" onchange="change_group()"><?php echo build_group_select(''); ?></select></td>
                                     </tr> 
                                    <tr>
                                      <td>接收人</td>
                                      <td><select name="receive_user" id="receive_user"></select></td>
                                     </tr>