用库内数据实现模块功能
<?php
//打开session
session_start();
?>
<!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>
</head>
<body>
<?php
//连接数据库
include "../include/dbConn.php";
/**该文件的作用是 接收用户输入的信息,进行查询,判断是否存在,如果存在则跳转到成功页面,如果错误,则给出错误提示。*/
//接受用户参数(用户名、密码)
$user=$_POST['UserName'];
$pass=$_POST['PassWord'];
//根据用户名进行查询,取出密码
$sql="select password,ulimit from user where username='".$user."'";
//执行查询
$rs=mysql_query($sql);
echo $sql;
$rows=mysql_fetch_assoc($rs);
$selimit=$rows['ulimit'];
if($rs!=""){
$selpass=$rows['password'];
}
//echo $pass."====".md5($pass)."<br>";
//echo "*****************".$selpass;
if($selpass!=''){
//判断取出的密码是否和用户输入的一致
if($pass==$selpass){
$_SESSION['username']=$user;
$_SESSION['ulimit']=$selimit;
?>
<script>
//如果一致提示登陆成功
alert("登陆成功!");
//页面要跳转到主页
location.href="./Default.php";
</script>
<?php
}else{
//提示密码错误
?>
<script>
//如果一致提示登陆成功
alert("密码输入错误,再想想!");
//页面要跳转到主页
location.href="./login.htm";
</script>
<?php
}
}else{
//如果根据用户名查询不到信息,提示用户名不存在
?>
<script>
//如果一致提示登陆成功
alert("您输入的用户名不存在,请核实!");
//页面要跳转到主页
location.href="./login.htm";
</script>
<?php
}
?>
</body>
</html>
left.php 模板的显示文件
<?php
session_start();
include "../include/dbConn.php";
//根据seesion中的权限、执行查询、查询所对应的模块
$sql="select * from module where id in(".$_SESSION['ulimit'].")";
//$sql="select * from module where id in(1,4,5)";
//执行查询
$rs=mysql_query($sql);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>管理页面</TITLE>
<STYLE type=text/css>BODY {
BACKGROUND: #799ae1; MARGIN: 0px; FONT: 9pt 宋体
}
TABLE {
BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px
}
TD {
FONT: 12px 宋体
}
IMG {
BORDER-RIGHT: 0px; BORDER-TOP: 0px; VERTICAL-ALIGN: bottom; BORDER-LEFT: 0px;
BORDER-BOTTOM: 0px
}
A {
FONT: 12px 宋体; COLOR: #000000; TEXT-DECORATION: none
}
A:hover {
COLOR: #428eff; TEXT-DECORATION: underline
}
.sec_menu {
BORDER-RIGHT: white 1px solid; BACKGROUND: #d6dff7; OVERFLOW: hidden; BORDER-
LEFT: white 1px solid; BORDER-BOTTOM: white 1px solid
}
.menu_title {
}
.menu_title SPAN {
FONT-WEIGHT: bold; LEFT: 7px; COLOR: #215dc6; POSITION: relative; TOP: 2px
}
.menu_title2 {
}
.menu_title2 SPAN {
FONT-WEIGHT: bold; LEFT: 8px; COLOR: #428eff; POSITION: relative; TOP: 2px
}
</STYLE>
<SCRIPT language=javascript1.2>
function showsubmenu(sid)
{
whichEl = eval("submenu" + sid);
if (whichEl.style.display == "none")
{
eval("submenu" + sid + ".style.display=\"\";");
}
else
{
eval("submenu" + sid + ".style.display=\"none\";");
}
}
</SCRIPT>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=left border=0>
<TBODY>
<TR>
<TD vAlign=top bgColor=#799ae1>
<TABLE cellSpacing=0 cellPadding=0 width=158 align=center>
<TBODY>
<TR>
<TD vAlign=bottom height=42><IMG height=38
src="left.files/title.gif" width=158> </TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=158 align=center>
<TBODY>
<TR>
<TD class=menu_title onMouseOver="this.className='menu_title2';"
οnmοuseοut="this.className='menu_title';" background=""
height=25><SPAN>
| <A
href="exit.asp"
target=_parent><B>退出</B></A></SPAN></TD>
</TR>
<TR>
<TD class=menu_title onMouseOver="this.className='menu_title2';"
οnmοuseοut="this.className='menu_title';" background=""
height=25> </TD>
</TR>
</TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=158 align=center>
<TBODY>
<TR>
<TD class=menu_title id=menuTitle1
οnmοuseοver="this.className='menu_title2';" οnclick=showsubmenu(0)
οnmοuseοut="this.className='menu_title';"
background=left.files/admin_left_1.gif
height=25><span><B><%=trim(rs("userName"))%>个人资料</B></span></TD>
</TR>
<TR>
<TD id=submenu0>
<DIV class=sec_menu style="WIDTH: 158px ">
<TABLE cellSpacing=0 cellPadding=0 width=135 align=center>
<TBODY>
<TR>
<TD height=20><A
href="UserInfo.asp"
target=mainFrame>你的个人资料</A></TD>
</TR>
<TR>
<TD height=20><A
href="UserInfoAlter.asp"
target=mainFrame>修改个人资料</A></TD>
</TR>
<TR>
<TD height=20><a href="UserInfoPassWord.asp" target="mainFrame">修改用户
密码</a></TD>
</TR>
</TBODY></TABLE>
</DIV>
<DIV style="WIDTH: 158px">
<TABLE cellSpacing=0 cellPadding=0 width=135 align=center>
<TBODY>
<TR>
<TD height=20></TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE>
<?php
//遍历显示所有的模块------start
while($rows=mysql_fetch_assoc($rs)){
?>
<TABLE cellSpacing=0 cellPadding=0 width=158 align=center>
<TBODY>
<TR>
<TD class=menu_title id=menuTitle1
οnmοuseοver="this.className='menu_title2';" οnclick=showsubmenu(2)
οnmοuseοut="this.className='menu_title';"
background=left.files/admin_left_2.gif height=25><SPAN><?php echo $rows['name']
?></SPAN> </TD>
</TR>
<TR>
<TD id=submenu2><DIV class=sec_menu style="WIDTH: 158px">
<TABLE cellSpacing=0 cellPadding=0 width=135 align=center>
<TBODY>
<TR>
<TD height=20><a href="Produce.asp" target=mainFrame>商品管理帮助
</a></TD>
</TR>
<TR>
<TD height=20><a href="ProduceShow.asp" target="mainFrame">商品浏览
|修改</a></TD>
</TR>
<TR>
<TD height=20><a href="ProduceAdd.asp" target="mainFrame">商品添加
</a></TD>
</TR>
<TR>
<TD height=20><a href="ProduceSearch.asp" target="mainFrame">商品搜
索</a></TD>
</TR>
<TR>
<TD height=20><a href="addCategory.asp" target="mainFrame">商品类别
|添加</a></TD>
</TR>
</TBODY>
</TABLE>
</DIV>
<DIV style="WIDTH: 158px">
<TABLE cellSpacing=0 cellPadding=0 width=135 align=center>
<TBODY>
<TR>
<TD
height=20></TD>
</TR>
</TBODY>
</TABLE>
</DIV></TD>
</TR>
</TBODY>
</TABLE>
<?php
}
?>
</BODY></HTML>