已知存在一个数据表user存放用户信息,编写6个php页面分别实现用户注册/用户登录/欢迎用户/修改用户信息/注销用户(用户表中有数据id、login、name、password、phone、mail、qq、pic)
时间: 2024-01-19 22:04:41 浏览: 30
好的,我可以给你提供一个简单的示例代码,但是需要注意的是,这只是一个示例,实际应用中还需要根据具体情况进行修改和完善,同时也需要进行安全性的考虑。
1. 用户注册 register.php
```
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// 获取用户提交的表单数据
$login = $_POST['login'];
$name = $_POST['name'];
$password = $_POST['password'];
$phone = $_POST['phone'];
$mail = $_POST['mail'];
$qq = $_POST['qq'];
$pic = $_POST['pic'];
// 对用户提交的数据进行验证,确保数据的正确性和安全性
// 连接数据库
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');
if (!$conn) {
die('数据库连接失败: ' . mysqli_connect_error());
}
// 检查用户是否已经存在
$sql = "SELECT * FROM user WHERE login = '$login'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
echo '用户名已经存在';
exit;
}
// 插入新用户数据
$sql = "INSERT INTO user (login, name, password, phone, mail, qq, pic) VALUES ('$login', '$name', '$password', '$phone', '$mail', '$qq', '$pic')";
if (mysqli_query($conn, $sql)) {
echo '注册成功';
} else {
echo '注册失败: ' . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>用户注册</title>
</head>
<body>
<form method="POST" action="register.php">
<label>用户名:</label><input type="text" name="login"><br>
<label>姓名:</label><input type="text" name="name"><br>
<label>密码:</label><input type="password" name="password"><br>
<label>电话:</label><input type="text" name="phone"><br>
<label>邮箱:</label><input type="text" name="mail"><br>
<label>QQ:</label><input type="text" name="qq"><br>
<label>头像:</label><input type="text" name="pic"><br>
<input type="submit" value="注册">
</form>
</body>
</html>
```
2. 用户登录 login.php
```
<?php
// 开启Session
session_start();
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// 获取用户提交的表单数据
$login = $_POST['login'];
$password = $_POST['password'];
// 连接数据库
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');
if (!$conn) {
die('数据库连接失败: ' . mysqli_connect_error());
}
// 检查用户是否存在
$sql = "SELECT * FROM user WHERE login = '$login'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
if ($row['password'] == $password) {
// 登录成功,将用户信息保存到Session中
$_SESSION['user_id'] = $row['id'];
$_SESSION['user_login'] = $row['login'];
$_SESSION['user_name'] = $row['name'];
$_SESSION['user_phone'] = $row['phone'];
$_SESSION['user_mail'] = $row['mail'];
$_SESSION['user_qq'] = $row['qq'];
$_SESSION['user_pic'] = $row['pic'];
echo '登录成功';
} else {
echo '密码错误';
}
} else {
echo '用户不存在';
}
mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>用户登录</title>
</head>
<body>
<form method="POST" action="login.php">
<label>用户名:</label><input type="text" name="login"><br>
<label>密码:</label><input type="password" name="password"><br>
<input type="submit" value="登录">
</form>
</body>
</html>
```
3. 欢迎用户 welcome.php
```
<?php
// 开启Session
session_start();
// 检查用户是否已经登录
if (!isset($_SESSION['user_id'])) {
header('Location: login.php');
exit;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>欢迎您,<?php echo $_SESSION['user_name']; ?></title>
</head>
<body>
<h1>欢迎您,<?php echo $_SESSION['user_name']; ?></h1>
<p>您的联系方式为:电话 <?php echo $_SESSION['user_phone']; ?>,邮箱 <?php echo $_SESSION['user_mail']; ?>,QQ <?php echo $_SESSION['user_qq']; ?></p>
<p><a href="update.php">修改用户信息</a></p>
<p><a href="logout.php">注销</a></p>
</body>
</html>
```
4. 修改用户信息 update.php
```
<?php
// 开启Session
session_start();
// 检查用户是否已经登录
if (!isset($_SESSION['user_id'])) {
header('Location: login.php');
exit;
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
// 获取用户提交的表单数据
$name = $_POST['name'];
$password = $_POST['password'];
$phone = $_POST['phone'];
$mail = $_POST['mail'];
$qq = $_POST['qq'];
$pic = $_POST['pic'];
// 对用户提交的数据进行验证,确保数据的正确性和安全性
// 连接数据库
$conn = mysqli_connect('localhost', 'username', 'password', 'database_name');
if (!$conn) {
die('数据库连接失败: ' . mysqli_connect_error());
}
// 更新用户数据
$user_id = $_SESSION['user_id'];
$sql = "UPDATE user SET name = '$name', password = '$password', phone = '$phone', mail = '$mail', qq = '$qq', pic = '$pic' WHERE id = $user_id";
if (mysqli_query($conn, $sql)) {
$_SESSION['user_name'] = $name;
$_SESSION['user_phone'] = $phone;
$_SESSION['user_mail'] = $mail;
$_SESSION['user_qq'] = $qq;
$_SESSION['user_pic'] = $pic;
echo '更新成功';
} else {
echo '更新失败: ' . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>修改用户信息</title>
</head>
<body>
<form method="POST" action="update.php">
<label>姓名:</label><input type="text" name="name" value="<?php echo $_SESSION['user_name']; ?>"><br>
<label>密码:</label><input type="password" name="password"><br>
<label>电话:</label><input type="text" name="phone" value="<?php echo $_SESSION['user_phone']; ?>"><br>
<label>邮箱:</label><input type="text" name="mail" value="<?php echo $_SESSION['user_mail']; ?>"><br>
<label>QQ:</label><input type="text" name="qq" value="<?php echo $_SESSION['user_qq']; ?>"><br>
<label>头像:</label><input type="text" name="pic" value="<?php echo $_SESSION['user_pic']; ?>"><br>
<input type="submit" value="保存">
</form>
</body>
</html>
```
5. 注销用户 logout.php
```
<?php
// 开启Session
session_start();
// 销毁Session
session_unset();
session_destroy();
// 跳转到登录页面
header('Location: login.php');
exit;
?>
```
以上就是简单的用户注册、登录、欢迎用户、修改用户信息、注销用户的示例代码。需要注意的是,这只是一个简单的示例,实际应用中还需要根据具体情况进行修改和完善,同时也需要进行安全性的考虑。