老师你好,接下来要怎样做才能实现将注册的信息写入 loginuserinfo.sql 数据库呀:
//register.js
(function() {
$('.registBtn').click(function() {
//获取相关元素
var regist_username = $('.regist-username').val();
var regist_password = $('.regist-password').val();
var regist_password_again = $('.regist-password-again').val();
//判空操作
//trim() 去掉字符串两端的多余的空格
if (regist_username.trim().length == 0 || regist_password.trim().length == 0 || regist_password_again.trim().length == 0) {
alert('信息不能为空,请确认!');
return;
} else if (regist_password != regist_password_again) {
alert('两次密码不一致!');
return;
}
//发送Ajax请求
$.ajax({
type: 'post',
url: './php/register.php',
dataType: 'json',
data: { //发送的数据 uname、upass用来提交到后台
reuname: regist_username,
repassword: regist_password,
repassworda: regist_password_again
},
success: function(res) { //回调函数
switch (res.infoCode) {
case 0:
{
alert('恭喜你,注册成功!请登录!');
//注册成功后自动跳转到登录
location = '../php/loginFile.php';
}
break;
case 1:
{
alert('两次密码不一致!');
}
break;
case 2:
{
alert('登录失败!网络连接失败');
}
break;
case 3:
{
alert('登录失败!用户名已存在');
}
break;
default:
{
alert('未知错误');
}
}
}
})
//发送请求完毕后初始化输入框
$('.regist-username').val();
$('.regist-password').val();
$('.regist-password-again').val();
});
}());
//register.php
<?php
//获取用户从前端发来的数据
$username = $_POST['reuname'];
$password = $_POST['repassword'];
$passworda = $_POST['repassworda'];
$success = array('msg'=>'ok');
//连接数据库
$con = mysqli_connect('localhost','root','123456','lanmeipai');
if($con){
//修改字符集
mysqli_query($con,'set names utf8');
mysqli_query($con,'set character_set_client utf8');
mysqli_query($con,'set character_set_results utf8');
//查询数据并连接
$sql = 'select * from loginuserinfo where 1';
$result=$con->query($sql);
if(){
for(){
}
//判断用户传来的用户名和密码是否在数据库里有对应信息
$flag=false;//标示符,默认注册失败
//当循环结束后,判断$flag的值
if(!$flag){
$success['infoCode']=1;
}
}else{
$success['infoCode']=3;
}
}else{
$success['infoCode']=2;//0代表注册成功,1代表注册失败,2代表数据库连接失败,3代表用户名已存在
}
echo json_encode($success);
?>
