5.27权限练习

权限设置页面效果图：

实现功能：可以增添或者取消用户的相应职能权限。代码如下：

主页面：

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>权限管理</title>
<script src="jquery-2.2.3.js">
</script>
</head>

<body>
<h1>Authority Management</h1>
<!--用户选择-->
<div>
请选择用户：<select id="uid">
              <?php
                 include ("database.class.php");
                 $db = new database();
                 $sql_users = "select * from Users";
                 $arr_users = $db->Query($sql_users);
                 foreach($arr_users as $value_users)
                 {
                    echo "<option value='{$value_users[0]}'>{$value_users[2]}</option>"; 
                 }
              ?>
         </select>
</div>
<br />
<!--职位选择-->
<div>
请选择职位：
            <?php
                $sql_position = "select * from JueSe";
                $arr_position = $db->Query($sql_position);
                foreach($arr_position as $value_position)
                {
                    echo "<input type='checkbox' class='job' value='{$value_position[0]}' />{$value_position[1]}&nbsp;";
                }
            ?>
</div>
<br />
<div>
<input type="button" value="确定" id="btn" />
</div>
</body>
</html>
<script>
$(document).ready(function(e) {
    
    Job();
    
    $("#uid").change(function ()
    {
        Job();
        })
    $("#btn").click(function ()
    {
        var uid = $("#uid").val();
        var job = $(".job");
        var str ="";
        for(var i=0;i<job.length;i++)
        {
            if(job.eq(i).prop("checked"))
            {
                str = str + job.eq(i).val() + "|";
            }
        }
        str = str.substr(0,str.length-1);
        //alert(str);
        $.ajax({
                url:"job1cl.php",
                data:{uid:uid,js:str},
                type:"POST",
                dataType:"TEXT",
                success: function(d){
                    
                    if(d.trim()=="OK")
                    {
                        alert("添加成功");
                    }
                    else
                    {
                        alert("添加失败");
                    }
                  }
              })
        
        })
        
        
    
        
        
        
    function Job()
    {
        var uid = $("#uid").val();
        $.ajax({
                
                url:"jobcl.php",
                data:{uid:uid},
                type:"POST",
                dataType:"TEXT",
                success: function(d){
                    
                    var data = d.split("|");
                    var job = $(".job");
                    job.prop("checked",false);
                    for(var i = 0 ;i<job.length; i++)
                    {
                        var value =job.eq(i).val();
                        //alert($.inArray(value,data));
                        if($.inArray(value,data)!=-1)
                        {
                            job.eq(i).prop("checked",true);
                        }
                    }
                 }
              })
    }    
    
    
    
});




</script>

View Code

用户下拉列表处理：

<?php

$uid = $_POST['uid'];
include ("database.class.php");
$db = new database();
$sql = "select JueSeId from UserInJueSe where UserId = '{$uid}'";
$result = $db->str_ajax($sql);
echo $result;

View Code

权限处理：

<?php

$uid = $_POST['uid'];
$js = $_POST['js'];//是一个字符串
include("database.class.php");
$db = new database();
$arr_job = explode("|",$js);//拆分字符串，放入一个数组中
$result = true;//定义一个变量判断执行结果
//清除用户原有的信息
if(!$db->Query("delete from UserInJueSe where UserId ='{$uid}'",1))
{
    $result = $result && false;
}
//添加新信息，循环拆分好的数组
foreach($arr_job as $v)
{
    $sql = "insert into UserInJueSe values('','{$uid}','{$v}') ";
    if(!$db->Query($sql,1))
    {
        $result = $result && false;
    }
}
//判断添加是否成功
if($result)
{
    echo "OK";
}
else
{
    echo "NO";
}

View Code

权限设置完毕，即可登录相关网站，根据自身权限显示相应的内容

例子效果图：

代码如下：

<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主页面</title>
<style>
#menu
{
    width:100%;
    height:150px
}

.menu1
{
    width:150px;
    height:50px;
    background-color:#999;
    line-height:50px;
    text-align:center;
    border-radius:5px;
    color:#FFF;
    float:left;
}
.menu1:hover
{
    cursor:pointer;
    background-color:#F60;
}
</style>
</head>

<body>
<?php
session_start();
if(empty($_SESSION['uid']))
{
    header("location:login.php");
    exit;
}
$uid = $_SESSION['uid'];
?>
<h1 align="center">主页面</h1>
<div><h2>Hello <?php if(!empty($_SESSION['uid'])){echo $_SESSION['uid'];} ?></h2>&nbsp;&nbsp;&nbsp;
<div style="float:right"><a href="login.php">退出系统</a></div></div>
<div id="menu">
      <div class="menu1">权限管理</div>
      <?php
      include ("database.class.php");
      $db = new database();
      //根据uid查角色代号
        $sql_actor_id = "select JueSeId from  UserInJueSe where UserId = '{$uid}' ";
        $r_actor_id = $db->Query($sql_actor_id);
      //根据角色代号查功能id
          $all = array();//存放所有功能Id
         foreach($r_actor_id as $value_actor_id)
         {
             $sql_rule = "select RuleId from JueSeWithRules where JueSeId = '{$value_actor_id[0]}' ";
             $r_rule = $db->Query($sql_rule);
             foreach($r_rule as $value_rule)
             {
                 array_push($all,$value_rule[0]);
             }
             $all = array_unique($all);//数组去重
         }
      //根据功能id显示职责
       foreach($all as $value_show)
       {
         $sql_show = "select Name from Rules where Code = '{$value_show}'"; 
         $r_show = $db->str_ajax($sql_show);
         echo "<div class='menu1'>{$r_show}</div>";
       }
      ?>
</div>
</body>
</html>

View Code