php设计个人信息管理代码
时间: 2023-10-24 22:07:50 浏览: 109
好的,以下是一个简单的 PHP 个人信息管理系统的代码示例,包含用户登录和注册、个人信息录入、查询、修改和删除等功能:
1. 用户登录和注册功能:
login.php
```php
<?php
session_start();
if(isset($_SESSION['username'])) {
header("Location: index.php");
exit;
}
if(isset($_POST['login'])) {
$username = $_POST['username'];
$password = $_POST['password'];
// 将密码进行加密,避免明文存储
$password = md5($password);
// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "mydb");
// 查询用户信息
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
// 用户名和密码正确,将用户信息保存到 session 中
$_SESSION['username'] = $username;
header("Location: index.php");
exit;
} else {
// 用户名和密码不正确,提示错误信息
$error = "用户名或密码错误!";
}
}
if(isset($_POST['register'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
// 将密码进行加密,避免明文存储
$password = md5($password);
// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "mydb");
// 查询用户名是否已存在
$sql = "SELECT * FROM users WHERE username='$username'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
// 用户名已存在,提示错误信息
$error = "用户名已存在!";
} else {
// 插入新用户信息
$sql = "INSERT INTO users (username, password, email) VALUES ('$username', '$password', '$email')";
$result = mysqli_query($conn, $sql);
if($result) {
// 注册成功,跳转到登录页面
header("Location: login.php");
exit;
} else {
// 注册失败,提示错误信息
$error = "注册失败!";
}
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>登录和注册</title>
</head>
<body>
<?php if(isset($error)) { ?>
<p><?php echo $error; ?></p>
<?php } ?>
<h1>登录</h1>
<form method="post" action="">
<label>用户名:</label>
<input type="text" name="username" required>
<br><br>
<label>密码:</label>
<input type="password" name="password" required>
<br><br>
<input type="submit" name="login" value="登录">
</form>
<h1>注册</h1>
<form method="post" action="">
<label>用户名:</label>
<input type="text" name="username" required>
<br><br>
<label>密码:</label>
<input type="password" name="password" required>
<br><br>
<label>邮箱:</label>
<input type="email" name="email" required>
<br><br>
<input type="submit" name="register" value="注册">
</form>
</body>
</html>
```
2. 个人信息录入功能:
add.php
```php
<?php
session_start();
if(!isset($_SESSION['username'])) {
header("Location: login.php");
exit;
}
if(isset($_POST['submit'])) {
$name = $_POST['name'];
$gender = $_POST['gender'];
$birthday = $_POST['birthday'];
$phone = $_POST['phone'];
$email = $_POST['email'];
// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "mydb");
// 获取当前用户的用户名
$username = $_SESSION['username'];
// 插入个人信息
$sql = "INSERT INTO information (username, name, gender, birthday, phone, email) VALUES ('$username', '$name', '$gender', '$birthday', '$phone', '$email')";
$result = mysqli_query($conn, $sql);
if($result) {
// 个人信息录入成功,跳转到个人信息页面
header("Location: index.php");
exit;
} else {
// 个人信息录入失败,提示错误信息
$error = "个人信息录入失败!";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>个人信息录入</title>
</head>
<body>
<?php if(isset($error)) { ?>
<p><?php echo $error; ?></p>
<?php } ?>
<h1>个人信息录入</h1>
<form method="post" action="">
<label>姓名:</label>
<input type="text" name="name" required>
<br><br>
<label>性别:</label>
<input type="radio" name="gender" value="男" required>男
<input type="radio" name="gender" value="女" required>女
<br><br>
<label>出生日期:</label>
<input type="date" name="birthday" required>
<br><br>
<label>电话:</label>
<input type="tel" name="phone" required>
<br><br>
<label>邮箱:</label>
<input type="email" name="email" required>
<br><br>
<input type="submit" name="submit" value="提交">
</form>
</body>
</html>
```
3. 个人信息查询功能:
index.php
```php
<?php
session_start();
if(!isset($_SESSION['username'])) {
header("Location: login.php");
exit;
}
// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "mydb");
// 获取当前用户的用户名
$username = $_SESSION['username'];
// 查询个人信息
$sql = "SELECT * FROM information WHERE username='$username'";
$result = mysqli_query($conn, $sql);
?>
<!DOCTYPE html>
<html>
<head>
<title>个人信息查询</title>
</head>
<body>
<h1>个人信息查询</h1>
<table border="1">
<tr>
<th>姓名</th>
<th>性别</th>
<th>出生日期</th>
<th>电话</th>
<th>邮箱</th>
<th>操作</th>
</tr>
<?php while($row = mysqli_fetch_assoc($result)) { ?>
<tr>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['gender']; ?></td>
<td><?php echo $row['birthday']; ?></td>
<td><?php echo $row['phone']; ?></td>
<td><?php echo $row['email']; ?></td>
<td>
<a href="edit.php?id=<?php echo $row['id']; ?>">修改</a>
<a href="delete.php?id=<?php echo $row['id']; ?>">删除</a>
</td>
</tr>
<?php } ?>
</table>
<br>
<a href="add.php">个人信息录入</a>
<br><br>
<a href="password.php">密码修改</a>
<br><br>
<a href="logout.php">退出登录</a>
</body>
</html>
```
4. 密码修改功能:
password.php
```php
<?php
session_start();
if(!isset($_SESSION['username'])) {
header("Location: login.php");
exit;
}
if(isset($_POST['submit'])) {
$oldpassword = $_POST['oldpassword'];
$newpassword = $_POST['newpassword'];
// 将密码进行加密,避免明文存储
$oldpassword = md5($oldpassword);
$newpassword = md5($newpassword);
// 连接数据库
$conn = mysqli_connect("localhost", "root", "password", "mydb");
// 获取当前用户的用户名
$username = $_SESSION['username'];
// 验证旧密码是否正确
$sql = "SELECT * FROM users WHERE username='$username' AND password='$oldpassword'";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result) > 0) {
// 旧密码正确,将新密码保存到数据库中
$sql = "UPDATE users SET password='$newpassword' WHERE username='$username'";
$result = mysqli_query($conn, $sql);
if($result) {
// 密码修改成功,跳转到个人信息页面
header("Location: index.php");
exit;
} else {
// 密码修改失败,提示错误信息
$error = "密码修改失败!";
}
} else {
// 旧密码不正确,提示错误信息
$error = "旧密码不正确!";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>密码修改</title>
</head>
<body>
<?php if(isset($error)) { ?>
<p><?php echo $error; ?></p>
<?php } ?>
<h1>密码修改</h1>
<form method="post" action="">
<label>旧密码:</label>
<input type="password" name="oldpassword" required>
<br><br>
<label>新密码:</label>
<input type="password" name="newpassword" required>
<br><br>
<input type="submit" name="submit" value="提交">
</form>
</body>
</html>
```
以上是一个简单的 PHP 个人信息管理系统的代码示例,您可以根据自己的需求进行修改和扩展。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)