列表页
//连接数据库
$db = new MySQLi('localhost','root','','z_1032');
!mysqli_connect_error() or die('连接失败');
$db->query('set names utf8');
//判断修改状态
if(!empty($_GET['id'])){
$sno = $_GET['id'];
$sql = "update student set status = 1 where sno = '$sno'";
$res = $db->query($sql);
}
//查数据
$sql = "select * from student where status >= 0";
$res = $db->query($sql);
$arr = $res->fetch_all();
?>
列表页
.spanErr{
background: red;
cursor: pointer;
}
.spanSu{
background: green;
cursor: pointer;
}
登录页
登录页
账号:
密码:
登录
注册
注册页
if(!empty($sno)){
//连接数据库
$db = new MySQLi('localhost','root','','z_1032');
!mysqli_connect_error() or die('连接失败');
$db->query('set names utf8');
//接收值
$sno = $_POST['sno'];
$sname = $_POST['sname'];
$ssex = $_POST['ssex'];
$sbirthday = $_POST['sbirthday'];
$class = $_POST['class'];
//执行sql
$sql = "insert into student values ('$sno','$sname','$ssex','$sbirthday','$class',0)";
$res = $db->query($sql);
if($res){
echo "注册成功";
}else{
echo "注册失败";
}
}
?>
注册页
学号:
姓名:
性别:
生日:
班级:
注册
查看用户列表
后台页
//连接数据库
$db = new MySQLi('localhost','root','','z_1032');
!mysqli_connect_error() or die('连接失败');
$db->query('set names utf8');
//接收数据
$sname = $_POST['sname'];//账号
$sno = $_POST['sno'];//密码
//查询 审核状态为通过或者是管理员
$sql = "select sno from student where sname = $sname and status != 0";
$res = $db->query($sql);
$arr = $res->fetch_row(); //结果集专数组, 结果是一维数组
//判断给出结果
if($sno != '' && $arr == ''){
echo "账号密码错误或者未通过审核";
}else{
echo "登录成功";
}
?>