想问一下,我这边连接了数据库,但是在注册的时候,数据库没有写入注册信息。
registeraction.php
<?php
//声明变量
$username = isset($_POST['username'])?$_POST['username']:"";
$password = isset($_POST['password'])?$_POST['password']:"";
$re_password = isset($_POST['re_password'])?$_POST['re_password']:"";
$sex = isset($_POST['sex'])?$_POST['sex']:"";
$qq = isset($_POST['qq'])?$_POST['qq']:"";
$email = isset($_POST['email'])?$_POST['email']:"";
$phone = isset($_POST['phone'])?$_POST['phone']:"";
$address = isset($_POST['address'])?$_POST['address']:"";
if($password == $re_password) {
//建立连接
$conn = mysqli_connect('101.42.246.250','uehsystem_eu_org','pHAE5p6cTjPaxLey','uehsystem_eu_org');
//准备SQL语句,查询用户名
$sql_select="SELECT username FROM User WHERE username = '$username'";
//执行SQL语句
$ret = mysqli_query($conn,$sql_select);
//判断用户名是否已存在
if($username == $row['username']) {
//用户名已存在,显示提示信息
header("Location:register.php?err=1");
} else {
//用户名不存在,插入数据
//准备SQL语句
$sql_insert = "INSERT INTO User(username,password,sex,qq,email,phone,address) VALUES('$username','$password','$sex','$qq','$email','$phone','$address')";
//执行SQL语句
mysqli_query($conn,$sql_insert);
header("Location:register.php?err=3");
}
//关闭数据库
mysqli_close($conn);
} else {
header("Location:register.php?err=2");
}
?>
loginaction.php
<?php
//声明变量
$username = isset($_POST['username'])?$_POST['username']:"";
$password = isset($_POST['password'])?$_POST['password']:"";
$remember = isset($_POST['remember'])?$_POST['remember']:"";
//判断用户名和密码是否为空
if(!empty($username)&&!empty($password)) {
//建立连接
$conn = mysqli_connect('101.42.246.250','uehsystem_eu_org','pHAE5p6cTjPaxLey','uehsystem_eu_org');
//准备SQL语句
$sql_select = "SELECT username,password FROM User WHERE username = '$username' AND password = '$password'";
//执行SQL语句
$ret = mysqli_query($conn,$sql_select);
//判断用户名或密码是否正确
if($username==$row['username']&&$password==$row['password']) {
//选中“记住我”
if($remember=="on") {
//创建cookie
setcookie("wang", $username, time()+7*24*3600);
}
//开启session
session_start();
//创建session
$_SESSION['user']=$username;
//写入日志
$ip = $_SERVER['REMOTE_ADDR'];
$date = date('Y-m-d H:m:s');
$info = sprintf("当前访问用户:%s,IP地址:%s,时间:%s \n",$username, $ip, $date);
$sql_logs = "INSERT INTO Logs(username,ip,date) VALUES('$username','$ip','$date')";
//日志写入文件,如实现此功能,需要创建文件目录logs
$f = fopen('./logs/'.date('Ymd').'.log','a+');
fwrite($f,$info);
fclose($f);
//跳转到loginsucc.php页面
header("Location:loginsucc.php");
//关闭数据库
mysqli_close($conn);
}else {
//用户名或密码错误,赋值err为1
header("Location:login.php?err=1");
}
}else {
//用户名或密码为空,赋值err为2
header("Location:login.php?err=2");
}
?>