<link rel="stylesheet" href="../assets/css/M-style.css"/>
<!--
作者：彭均莹
任务：管理员-题型管理-按照题型查看
开发时间：2015/11/28
修改时间：2015/12/06
-->
<body>
<?php
include "../commonfile/dbconnect.php";
include "../function/pageControl.php";
session_start();
//控制页面 没有登录系统时跳转到登录页
if (!isset($_SESSION["userName"])) {
pageChange("请先登录系统！", 2, "../login.php");
die;
}
?>
<!-- ******************** head ********************* -->
<?php
include "../commonfile/c-head.php";
?>
<!-- ******************** main ********************* -->
<div id="g-bodybox">
<!--------------- leftbar ------------------->
<div id="g-leftbar">
<?php
include "M-ques-leftbar.php";
<?php
header("Content-Type:text/html;charset=utf-8");
session_start();
//1、获取表单递交的信息
$TeacherID = $_REQUEST["TeacherID"];
$OldPwd = $_REQUEST["old_p"];
$TeacherName = $_REQUEST["TeacherName"];
//$NewPwd=$_REQUEST["New_p"];
$CheckPwd = $_REQUEST["double_new_p"];
$Title = $_REQUEST["title"];
$Phone = $_REQUEST["phone"];
$Email = $_REQUEST["email"];
//3、数据库连接
include "../function/pageControl.php";
include "../commonfile/dbconnect.php";
//4、数据库访问（查询、插入、更新、删除）
$sql = "update teacherinfo set TeacherID='" . $TeacherID . "' , TeacherPassword='******', TeacherTitle='" . $Title . "'\n\t, TeacherPhone='" . $Phone . "' , TeacherEmail='" . $Email . "' where TeacherName ='" . $_SESSION['userName'] . "' ";
$rs = mysql_query($sql);
if ($rs) {
pageChange("修改成功", 2, "../Teacher/T-revise.php");
}
//关闭书数据库
mysql_close($conn);
作者：彭均莹
任务：管理员-修改用户信息 to-db
开发时间：2015/11/15
修改时间：2015/11/16
-->
<?php
header("Content-Type:text/html;charset=utf-8");
//函数导入
include "../function/pageControl.php";
include "../commonfile/dbconnect.php";
session_start();
//获取表单信息
$userName = $_REQUEST["userName"];
$userTitle = $_REQUEST["userTitle"];
$phone = $_REQUEST["phone"];
$email = $_REQUEST["email"];
//表单信息验证
if ($userName == "") {
pageChange("用户姓名不能为空！", 1, "");
die;
}
$sql2 = "update teacherinfo set TeacherName='" . $userName . "',TeacherTitle='" . $userTitle . "',TeacherPhone='" . $phone . "',TeacherEmail='" . $email . "' where TeacherNum = '" . $_SESSION["TeacherNum"] . "'";
$rs = mysql_query($sql2);
//关闭书数据库
mysql_close($conn);
//页面跳转到教师功能主页面
pageChange("成功修改用户信息！", 2, "M-user-manage.php");
unset($_SESSION["TeacherNum"]);
?>
<!--
作者：彭均莹
任务：管理员-重置用户密码
开发时间：2015/11/17
修改时间：
-->
<?php
header("Content-Type:text/html;charset=utf-8");
include "../function/pageControl.php";
include "../commonfile/dbconnect.php";
//修改密码
$sql = "update teacherinfo set TeacherPassword ='******' where TeacherNum=" . $_GET["TeacherNum"] . ";";
$rs = mysql_query($sql);
//if(mysql_affected_rows($conn)>0){
pageChange("重置密码成功，初始密码为123456！", 1, "");
//}
//else{
// pageChange("该密码并未修改，密码为123456！",1,"");
//}
//关闭书数据库
mysql_close($conn);
$_SESSION["userType"] = 1;
$_SESSION["userPwd"] = $row["TeacherPassword"];
pageChange("", 3, "../Teacher/T-index.php");
} else {
pageChange("密码不正确！", 1, "");
}
}
}
//管理员登录
if ($userType == 2) {
//3、数据库操作
$sql = "select * from admininfo where AdminUser='******'";
$rs = mysql_query($sql);
if (mysql_num_rows($rs) < 1) {
//没有数据
pageChange("管理员不存在！", 2, "../login.php");
} else {
$row = mysql_fetch_array($rs);
//4、页面输出控制
if ($row["AdminPassword"] == $userPwd) {
session_start();
$_SESSION["userName"] = $row["AdminUser"];
$_SESSION["userType"] = 2;
$_SESSION["userPwd"] = $row["AdminPassword"];
pageChange("", 3, "../Manager/M-ques-manage.php");
} else {
pageChange("密码不正确！", 2, "../login.php");
}
}
}
mysql_close($conn);
<!--
作者：彭均莹
任务：管理员-删除题目
开发时间：2015/11/28
修改时间：
-->
<?php
header("Content-Type:text/html;charset=utf-8");
session_start();
include "../function/pageControl.php";
include "../commonfile/dbconnect.php";
$sql = "delete from " . $_SESSION["M-table"] . " where QuestionId=" . $_GET["id"] . ";";
$rs = mysql_query($sql);
if (mysql_affected_rows($conn) > 0) {
pageChange("删除成功", 2, "M-ques-manage.php");
}
//关闭书数据库
mysql_close($conn);
<!--
作者：彭均莹
任务：管理员-修改密码
开发时间：2015/11/15
-->
<?php
header("Content-Type:text/html;charset=utf-8");
//公共文件导入
include "dbconnect.php";
include "../function/pageControl.php";
session_start();
//获取表单递交的信息
$oldpwd = $_REQUEST["oldpwd"];
$newpwd = $_GET["newpwd"];
$surepwd = $_GET["surepwd"];
//管理员登录
if ($_SESSION["userType"] == 2) {
if ($surepwd) {
$sql = "UPDATE admininfo SET AdminPassword = '******' WHERE AdminUser = '******' ";
$rs = mysql_query($sql);
session_destroy();
pageChange("密码修改成功，请重新登录！", 2, "../login.php");
}
}
mysql_close($conn);
$userName = $_REQUEST["userName"];
$userTitle = $_REQUEST["userTitle"];
$phone = $_REQUEST["phone"];
$email = $_REQUEST["email"];
//表单信息验证
//用户名为空
if ($userID == "") {
pageChange("用户ID不能为空！", 1, "");
die;
} else {
if ($userName == "") {
pageChange("用户姓名不能为空！", 1, "");
die;
}
}
//3连接数据库
$sql1 = "select * from teacherinfo where TeacherId = '" . $userID . "'";
$rs = mysql_query($sql1);
if (mysql_num_rows($rs) > 0) {
pageChange("用户ID已存在！", 1, "");
die;
}
$sql2 = "INSERT INTO teacherinfo (TeacherId,TeacherName,TeacherTitle,TeacherPhone,TeacherEmail) VALUES ('" . $userID . "','" . $userName . "','" . $userTitle . "','" . $phone . "', '" . $email . "');";
$rs = mysql_query($sql2);
//关闭书数据库
mysql_close($conn);
//页面跳转到教师功能主页面
pageChange("成功添加用户！", 2, "M-user-manage.php");
?>
<!--
作者：彭均莹
任务：管理员-删除用户
开发时间：2015/11/16
修改时间：
-->
<?php
header("Content-Type:text/html;charset=utf-8");
include "../function/pageControl.php";
include "../commonfile/dbconnect.php";
//只实现了在教师表中删除教师
$sql = "delete from teacherinfo where TeacherNum=" . $_GET["TeacherNum"] . ";";
$rs = mysql_query($sql);
if (mysql_affected_rows($conn) > 0) {
pageChange("删除成功", 2, "M-user-manage.php");
}
//关闭书数据库
mysql_close($conn);
<?php
header("Content-Type:text/html;charset=utf-8");
session_start();
session_destroy();
include "../function/pageControl.php";
pageChange("退出成功", 2, "../login.php");
