建立用户数据库

请根据自己需要增加字段。
新建注册页面
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>用户登入&注册</title>
</head>
<body>
<h1>用户登入</h1>
<form method="post" action="login.php">
<div>用户名:<input type="text" name="username"></div>
<div>密码:<input type="password" name="password"></div>
<div><input type="submit" value="登入"></div>
</form>
<h1>用户注册</h1>
<form method="post" action="reg.php">
<div>用户名:<input type="text" name="username"></div>
<div>密码:<input type="password" name="password"></div>
<div><input type="submit" value="注册"></div>
</form>
</body>
</html>

注册 PHP
要将注册信息写入数据库,也就是 reg.php
<?php
$username = $_POST['username'];
$password = $_POST['password'];
if (empty($username)) {
echo "用户名为空!";
} else {
if (empty($password)) {
echo "密码为空!";
} else {
$time = time();
$servername = "localhost";
$sqlusername = "数据库用户名";
$sqlpassword = "数据库密码";
$dbname = "数据库名";
// 创建连接
$conn = new mysqli($servername, $sqlusername, $sqlpassword, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
// 准备插入数据的SQL语句
$sql = "INSERT INTO member (id, username, password, time) VALUES ('', '$username', '$password' ,'$time')";
// 执行SQL语句
if ($conn->query($sql) === TRUE) {
echo "注册成功";
} else {
echo "注册失败: " . $sql . "<br>" . $conn->error;
}
// 关闭数据库连接
$conn->close();
}
}
登录 PHP
先制作一个 member.php(用户中心,同样数据信息根据自己需要修改)
<?php session_start(); ?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>用户中心</title>
</head>
<body>
<div>您好:<?php echo $_SESSION['username']; ?>,密码:<?php echo $_SESSION['password']; ?></div>
</body>
</html>
login.php
<?php
session_start();
$username = $_POST['username'];
$password = $_POST['password'];
if (empty($username)) {
echo "用户名为空!";
} else {
if (empty($password)) {
echo "密码为空!";
} else {
$servername = "localhost";
$sqlusername = "数据库用户名";
$sqlpassword = "数据库密码";
$dbname = "数据库名";
$conn = new mysqli($servername, $sqlusername, $sqlpassword, $dbname);
$query = "SELECT * FROM member WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $query);
if (mysqli_num_rows($result) > 0) {
// 用户名和密码匹配,登入成功
while($row=mysqli_fetch_assoc($result)) {
$id = $row['id'];
$username = $row['username'];
$password = $row['password'];
$_SESSION['id'] = $id;
$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
header("Location: member.php");
}
} else { ?>
<script type="text/javascript">alert("用户名或密码错误");history.go(-1);</script>
<?php } } } mysqli_close($conn); ?>
如果用户名和密码从数据库中查询都正确则跳转至 member.php
否则出现 “用户名或密码错误”


590

被折叠的 条评论
为什么被折叠?



