<?php
header('content-type:text/html;charset="utf-8"');
$responseData = array("code" => 0, "msg" => "");
/*
在后台再进行一次数据校验
*/
$username = $_POST['username'];
$password = $_POST['password'];
$repassword = $_POST['repassword'];
$createTime = $_POST['createTime'];
//1、判断用户名是否存在
if(!$username){
$responseData['code'] = 1;
$responseData['msg'] = "用户名不能为空";
echo json_encode($responseData);
exit;
}
if(!$password){
$responseData['code'] = 2;
$responseData['msg'] = "密码不能为空";
echo json_encode($responseData);
exit;
}
if($password != $repassword){
$responseData['code'] = 3;
$responseData['msg'] = "两次输入不一致";
echo json_encode($responseData);
exit;
}
//天龙八部
//1、链接数据库
$link = mysqli_connect("127.0.0.1", "root", "root");
//2、判断数据库是否链接成功
if(!$link){
$responseData['code'] = 4;
$responseData['msg'] = "服务器忙";
echo json_encode($responseData);
exit;
}
//3、设置访问字符集
mysqli_set_charset($link, "utf8");
//4、选择我们要访问的数据库
mysqli_select_db($link, "nz");
//5、准备sql注册
$sql = "SELECT * FROM users WHERE username='{$username}'";
//mysql result
$res = mysqli_query($link, $sql);
//取出一行
$row = mysqli_fetch_assoc($res);
//已经注册
if($row){
$responseData['code'] = 5;
$responseData['msg'] = "用户名已经存在";
echo json_encode($responseData);
exit;
}
//加密
$str = md5(md5(md5($password).'qianfeng').'xiaoming');
//准备sql，插入
$sql2 = "INSERT INTO users (username,password,createTime) VALUES('{$username}','{$str}',{$createTime})";
$res = mysqli_query($link, $sql2);
if($res){
$responseData['msg'] = "注册成功";
echo json_encode($responseData);
}else{
$responseData['code'] = 6;
$responseData['msg'] = "注册失败";
echo json_encode($responseData);
exit;
}
mysqli_close($link);
?>
js+php+mysql实现的学生成绩管理系统
需积分: 44 79 浏览量
2020-07-14
19:47:23
上传
评论 5
收藏 255KB RAR 举报
stu.rar （15个子文件） 
stu 
update.php 481B ajax.js 2KB paging.php 1KB
login.html 4KB students.sql 2KB users.sql 3KB register.php 2KB login.php 2KB show.php 443B
bg.jpg 277KB register.html 4KB delete.php 425B update1.php 671B show.html 10KB insert.php 613B资源评论
