<?php
session_start();
include "conn.php";
switch($_GET['a']){
//注册用户
case "register":
//获取用户提交的各项信息
$name = $_POST['name'];
$pass = $_POST['pass'];
$surepass = $_POST['surepass'];
$code=$_POST['code'];
$re_ip=getenv(REMOTE_ADDR);
$re_time=time();
//判断用户信息是否为空
if(empty($name)||empty($pass)||empty($surepass)){
echo "<script>alert('数据不能为空');window.location.href='register.php'</script>";
die;
}
//判断密码和确认密码是否一致
if($pass!=$surepass){
echo "<script>alert('密码不一致');window.location.href='register.php'</script>";
die;
}
//判断用户名是否存在
$sql="select * from tb_user where userName='{$name}';";
$result=mysqli_query($link,$sql);
if($result&& mysqli_num_rows($result)>0){
echo "<script>alert('用户名已存在');window.location.href='register.php'</script>";
die;
}
//4.定义sql语句并发送执行
$sql = "Insert Into bg_yang (username,userpwd,re_ip,re_time,authority) Values ('$name','$pass')";
$result = mysqli_query($link,$sql);
//5.判断是否添加成功
if($result && mysqli_affected_rows($link)>0){
$uid=mysqli_insert_id($link);
//获取用户id,添加进userdetail表
$sql="insert into `bg_yang`(`userid`)values({$uid});";
$result=mysqli_query($link,$sql);
if($result&&mysqli_affected_rows($link)>0){
$_SESSION['username']=$name;
$_SESSION['uid']=$uid;
echo "<script>alert('注册成功');window.location.href='主页.php'</script>";
}
}else{
echo ("<script>alert('注册失败!');history.go(-1);</script>");
exit();
}
//登录
case "主页":
//定义sql语句,并发送执行
//获取表单提交的信息
@$name=$_POST['name'];
@$pass=$_POST['pass'];
if(empty($name)||empty($pass)){
echo "<script>alert('账号或密码为空');window.location.href='登录.php'</script>";
die;
}
$sql="select * from bg_yang where username='{$name}'&& userpwd='{$pass}';";
$result=mysqli_query($link,$sql);
//解析结果集
if($result&& mysqli_num_rows($result)>0){
$row=mysqli_fetch_assoc($result);
// 设置session
$_SESSION['username']=$name;
$_SESSION['uid']=$row['id'];
//跳转到index.PHP
echo "<script>alert('登录成功');window.location.href='主页.php'</script>";
die;
}else{
echo "<script>alert('账号或密码错误');window.location.href='login.php'</script>";
die;
}
//释放
if ($result){
mysqli_free_result($result);
}
//6.关闭数据库
mysqli_close($link);
?>
|
|