登录页面
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>