0527权限管理

登录页面

 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5 <title>无标题文档</title>
 6 </head>
 7 
 8 <body>
 9 <br />
10 <h1>登录页面</h1>
11 <br />
12 <form action="dlchuli.php" method="post">
13 <div>用户名：<input type="text" name="uid" /></div><br />
14 <div>密  码：<input type="text" name="psw" /></div><br />
15 <input type="submit" value="登录" />
16 
17 </form>
18 </body>
19 </html>

　　登录处理页面

 1 <?php
 2 session_start();
 3 $uid=$_POST["uid"];
 4 $psw=$_POST["psw"];
 5 
 6 include ("../DBDA.class.php");
 7 $db=new DBDA();
 8 //查找有没有这条信息
 9 $sql="select count(*) from users where UserName='{$uid}' and Password='{$psw}'";
10 
11 $r=$db->StrQuery($sql);
12 
13 if($r==1)
14 {
15     $_SESSION["uid"]=$uid;
16     header("location:zhu.php");
17     }
18 else
19 {
20     header("location:login.php");
21     }

　　权限管理页面

<!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-1.11.2.min.js"></script>
</head>

<body>
<h1>权限管理</h1>
<div>请选择用户：
<select id="yhm">
  <?php
  include("../DBDA.php");
  $db=new DBDA();
  $sql="select * from yuangong";
  $jieguo=$db->Query($sql);
  foreach($jieguo as $v)
  {
	  echo"<option value='{$v[0]}'>{$v[2]}</option>";
  }
  ?>
</select>
</div>
<br />
<div>请选择角色： <br /><br />
  <?php
  $sqljs="select * from juese";
  $juesejg=$db->Query($sqljs);
  foreach($juesejg as $v)
  {
	 echo"<input type='checkbox' class='js' value='{$v[0]}'/>{$v[1]} ";  
  }
  ?>
</div><br /><br />
<div>
<input type="button" value="确定" id="queding" />
</div>
</body>
<script type="text/javascript">
$(document).ready(function(e) {
	juese();
    $("#yhm").change(function() {
	juese();
	})
		function juese(){
        var uid=$("#yhm").val();
		$.ajax({
			url:"jschuli.php",
			data:{uid:uid},
			type:"POST",
			dataType:"TEXT",
			success: function(zhi){
				var shuju = zhi.split("|");//拆分返回来的值
				var ck = $(".js"); //根据class找到所有的复选框
				ck.prop("checked",false);
				for(var i=0;i<ck.length;i++)
				{
				    var v=ck.eq(i).val();	//取每一个复选框的value值
					//$.inArray(v,shuju)   判断所选的这个value值在没在返回的数组里面
					if($.inArray(v,shuju)>=0)
					{
						ck.eq(i).prop("checked",true);
					}
				}
				}
			});
    }
	
	//操作确定按钮
	$("#queding").click(function() {
		
        var uid=$("#yhm").val();//取下拉列表的value值
		var juese=$(".js");//找到所有被选中的复选框
		var str="";
		for(var i=0;i<juese.length;i++)
		{
		   if(juese.eq(i).prop("checked"))
		   {
			 str=str+juese.eq(i).val()+"|";  
		   }
		}
		 str=str.substr(0,str.length-1);
		$.ajax({
			url:"tjchuli.php",
			data:{uid:uid,juese:str},
			type:"POST",
			dataType:"TEXT",
			success: function(zhi){
				if(zhi.trim()=="ok")
				{
				   alert("添加成功");	
				}
				else
				{
				    alert("添加失败");	
				}
			}
		});
    })
});
</script>
</html>

　　选择用户角色处理页面

<?php
$uid=$_POST["uid"];
include("../DBDA.php");
$db=new DBDA();
$sql="select JueSeId from userinjuese where UserId='{$uid}'";
echo $db->StrQuery($sql);

　　更改用户角色处理页面

<?php
include("../DBDA.php");
$db=new DBDA();
$uid=$_POST["uid"];
$juese=$_POST["juese"];
$js=explode("|",$juese);//拆分
$br= true;
//删除本来该用户的角色
$sqlsc="delete from userinjuese where UserId='{$uid}'";
if(!$db->Query($sqlsc,0))
{
    $br=$br &&false;	
}
//添加新选中的信息
foreach($js as $v)
{
	$sql="insert into userinjuese values('','{$uid}','{$v}')";
	if(!$db->Query($sql,0))
	{
	  $br=$br &&false;  	
	}
}
if($br)
{
	echo "ok";
}
else
{
	echo "no";
}

　　主页面

 1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 2 <html xmlns="http://www.w3.org/1999/xhtml">
 3 <head>
 4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
 5 <title>主页面</title>
 6 <style type="text/css">
 7 *{
 8     margin:0px auto;
 9     padding:0px;
10     }
11 #menu{
12     70%;
13     height:40px;
14     margin-left:300px;
15     }
16 .aa{
17     100px;
18     height:40px;
19     background-color:#8080FF;
20     color:white;
21     font-size:18px;
22     text-align:center;
23     line-height:40px;
24     vertical-align:middle;
25     float:left;
26     }
27 .aa:hover{    
28     cursor:pointer;
29     background-color:#FF8080;}
30 
31 </style>
32 </head>
33 
34 <body>
35 <?php
36 session_start();
37 if(empty($_SESSION["uid"]))
38 {    
39     header("location:login.php");
40     exit;
41     }
42 $uid=$_SESSION["uid"];
43 include("../DBDA.class.php");
44 $db=new DBDA();    
45 ?>
46 <br />
47 <br />
48 
49 <center><h1>主页面</h1></center>
50 <div style="margin-right:150px; 100px; height:10px;">
51 <a href="login.php">退出 <?php echo $uid; ?></a>
52 </div>
53 <br />
54 <div id="menu">
55 <div class="aa">管理权限</div>
56     <?php
57     
58     //根据用户名找到所对应的角色代号
59     $sql="select JueSeId from UserInJueSe where UserId ='{$uid}'";
60     $sd=$db->Query($sql);//结果是数组，存到
61     
62     //根据角色代号找到对应的功能
63     $all=array();//存储该用户所有的功能代号
64     
65     foreach($sd as $vsd)
66     {
67         $sgn="select RuleId from JueSeWithRules where JueSeId='{$vsd[0]}'";
68         $agn=$db->Query($sgn);
69         foreach($agn as $vgn)
70         {
71             array_push($all,$vgn[0]);
72             
73             }
74         }
75         $all=array_unique($all);//移除数组中重复的值array_unique()
76         
77         
78         //显示菜单
79         foreach($all as $vall)
80         {
81             $smn="select Name from Rules where code='{$vall}'";
82             $name=$db->StrQuery($smn);
83             echo "<div class='aa'>{$name}</div>";
84             }
85         
86 
87     ?>
88 </div>
89 </body>
90 </html>

　　

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/wcc731546227/p/5555515.html