php 实现两个select下拉框的数据联动

最新推荐文章于 2022-08-17 16:18:42 发布

原创最新推荐文章于 2022-08-17 16:18:42 发布 · 1w 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#php #mysql #query #sql #access #javascript

php 专栏收录该内容

48 篇文章

订阅专栏

这是一个用于修改系统中角色权限的界面示例，通过选择不同的工厂和角色来更新权限设置。页面包含下拉菜单供用户选择相应的工厂和角色。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>role perm modify</title>
<script language="javascript">
function getRole(){
document.role_perm_mod.action="";
document.role_perm_mod.submit();
}
</script>
</head>

<?php
$access_id = "root";
$access_pwd = "831025";
$db_name = "inv";
@ $db = mysql_connect('localhost', $access_id, $access_pwd) or
die("Could not connect to database. Please contact with IT supporting team ASAP.");
mysql_query("SET NAMES 'GBK'");
mysql_select_db($db_name);
?>

<body>
<form name="myform" method="post" action="" >
  <table cellpadding="0" cellspacing="1">
   <tr><th>Plant:</th>
    <td><select name="role_plant" onchange="javascript:getRole()">
    <?php
     echo '<option value="0">---Please Select---';
     $plants_sql = "SELECT plant_id,plant_desc FROM plant WHERE plant_act = '1' ";
     $plants_res = mysql_query($plants_sql);

     $plant_sql = "SELECT plant_id,plant_desc FROM plant WHERE plant_id='".$_POST['role_plant']."' ";
     $plant_res = mysql_query($plant_sql);

     $plant_row = mysql_fetch_array($plant_res);

     while($plants_row = mysql_fetch_array($plants_res)){
      if ($plant_row['plant_id'] == $plants_row['plant_id']){
       echo '<option value="'.$plants_row['plant_id'].'" selected > '.$plants_row['plant_id'].' - '.$plants_row['plant_desc'];
      }else{
       echo '<option value="'.$plants_row['plant_id'].'" > '.$plants_row['plant_id'].' - '.$plants_row['plant_desc'];
      }
     }
    ?>
        </select>
    </td>
      </tr>

   <tr><th>Role:</th>
    <td><select name="role_id">
    <?php
    echo'<option value="0">---Please Select---';
    $roles_sql = "SELECT * FROM sys_role WHERE role_plant='".$_POST['role_plant']."' and role_act='1'";
    $roles_res = mysql_query($roles_sql);

    $role_sql = "SELECT * FROM sys_role WHERE role_id='".$_POST['role_id']."' and role_act='1' ";
    $role_res = mysql_query($role_sql);

    $role_row = mysql_fetch_array($role_res);

    while($roles_row=mysql_fetch_array($roles_res)){
     if($role_row['role_id']==$roles_row['role_id']){
      echo "<option value=".$roles_row['role_id']." selected>".$roles_row['role_id']." - ".$roles_row['role_name'];
     }else{
      echo "<option value=".$roles_row['role_id'].">".$roles_row['role_id']." - ".$roles_row['role_name'];
     }
    }
    ?>
     </select>
    </td>
   </tr>
  </table>
    </form>
</body>
</html>