php+mysql图书管理系统,拥有增删改查,登录退出功能
时间: 2023-10-09 11:05:16 浏览: 96
好的,根据你的需求,以下是一个简单的 PHP + MySQL 图书管理系统的实现示例,包含增删改查和登录退出功能:
1.先创建数据库和数据表
```
CREATE DATABASE IF NOT EXISTS book_management_system;
USE book_management_system;
CREATE TABLE IF NOT EXISTS users (
id INT(11) NOT NULL AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS books (
id INT(11) NOT NULL AUTO_INCREMENT,
book_name VARCHAR(50) NOT NULL,
author VARCHAR(50) NOT NULL,
price FLOAT NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
```
2.创建登录页面
```
<?php
session_start();
if(isset($_SESSION['username'])){
header("Location:index.php");
}
if(isset($_POST['submit'])){
$username = $_POST['username'];
$password = $_POST['password'];
$conn = mysqli_connect('localhost','root','','book_management_system');
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = mysqli_query($conn,$sql);
if(mysqli_num_rows($result)==1){
$_SESSION['username'] = $username;
header("Location:index.php");
}else{
echo "<script>alert('用户名或密码错误');</script>";
}
mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>登录</title>
</head>
<body>
<h2>图书管理系统登录</h2>
<form method="post" action="">
<label for="username">用户名:</label>
<input type="text" name="username" id="username"><br><br>
<label for="password">密码:</label>
<input type="password" name="password" id="password"><br><br>
<input type="submit" name="submit" value="登录">
</form>
</body>
</html>
```
3.创建主页
```
<?php
session_start();
if(!isset($_SESSION['username'])){
header("Location:login.php");
}
if(isset($_POST['add'])){
$book_name = $_POST['book_name'];
$author = $_POST['author'];
$price = $_POST['price'];
$conn = mysqli_connect('localhost','root','','book_management_system');
$sql = "INSERT INTO books (book_name, author, price) VALUES ('$book_name', '$author', $price)";
if(mysqli_query($conn,$sql)){
echo "<script>alert('添加成功');</script>";
}else{
echo "<script>alert('添加失败');</script>";
}
mysqli_close($conn);
}
if(isset($_POST['delete'])){
$book_id = $_POST['book_id'];
$conn = mysqli_connect('localhost','root','','book_management_system');
$sql = "DELETE FROM books WHERE id=$book_id";
if(mysqli_query($conn,$sql)){
echo "<script>alert('删除成功');</script>";
}else{
echo "<script>alert('删除失败');</script>";
}
mysqli_close($conn);
}
if(isset($_POST['update'])){
$book_id = $_POST['book_id'];
$book_name = $_POST['book_name'];
$author = $_POST['author'];
$price = $_POST['price'];
$conn = mysqli_connect('localhost','root','','book_management_system');
$sql = "UPDATE books SET book_name='$book_name', author='$author', price=$price WHERE id=$book_id";
if(mysqli_query($conn,$sql)){
echo "<script>alert('修改成功');</script>";
}else{
echo "<script>alert('修改失败');</script>";
}
mysqli_close($conn);
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>图书管理系统</title>
</head>
<body>
<h2>欢迎使用图书管理系统</h2>
<form method="post" action="">
<label for="book_name">书名:</label>
<input type="text" name="book_name" id="book_name"><br><br>
<label for="author">作者:</label>
<input type="text" name="author" id="author"><br><br>
<label for="price">价格:</label>
<input type="text" name="price" id="price"><br><br>
<input type="submit" name="add" value="添加">
<input type="submit" name="delete" value="删除">
<input type="submit" name="update" value="修改">
</form>
<br>
<h3>图书列表</h3>
<table border="1">
<tr>
<th>书名</th>
<th>作者</th>
<th>价格</th>
<th>操作</th>
</tr>
<?php
$conn = mysqli_connect('localhost','root','','book_management_system');
$sql = "SELECT * FROM books";
$result = mysqli_query($conn,$sql);
while($row = mysqli_fetch_assoc($result)){
echo "<tr>";
echo "<td>".$row['book_name']."</td>";
echo "<td>".$row['author']."</td>";
echo "<td>".$row['price']."</td>";
echo "<td><form method='post' action=''><input type='hidden' name='book_id' value='".$row['id']."'><input type='submit' name='delete' value='删除'><input type='submit' name='update' value='修改'></form></td>";
echo "</tr>";
}
mysqli_close($conn);
?>
</table>
<br>
<form method="post" action="logout.php">
<input type="submit" name="logout" value="退出登录">
</form>
</body>
</html>
```
4.创建退出页面
```
<?php
session_start();
session_destroy();
header("Location:login.php");
?>
```
以上示例仅供参考,需要根据实际需求进行修改和完善。