php简单实现了图书管理系统,包括的功能:
1.列表展示所有图书,支持分页。
2.新增图书
3.编辑图书
4.搜索图书
5.删除
相关代码已打包 毕业设计图书管理系统php-PHP文档类资源-CSDN下载
看下效果图:
下面是代码部分
index.php
<?php
include './conn.php';
function book_list($pageSize, $currentPage){
global $conn;
$pageSize = $pageSize > 0 ? $pageSize: 10;
$currentPage = $currentPage > 0 ? $currentPage : 1;
$sql = "select * from book limit " . ($currentPage - 1) * $pageSize . ", " . $pageSize;
return mysqli_query($conn, $sql);
}
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$bookno_arr = $_POST['bookno'];
for($i = 0; $i < count($bookno_arr); $i++) {
if($i > 0) {
$bookno .= ",";
}
$bookno .= "'" . $bookno_arr[$i] . "'";
}
$list = mysqli_query("delete from book where bookno in (" . $bookno . ")", MYSQLI_ASSOC);
}
$pageSize = 10;
$currentPage = (int)$_GET['p'];
$currentPage = $currentPage ? $currentPage : 1;
$list = book_list($pageSize, $currentPage);
$counts = mysqli_fetch_array(mysqli_query($conn, "select count(1) from book"))[0];
$prePage = $currentPage > 1 ? $currentPage - 1 : 1;
$totalPage = ceil($counts/$pageSize);
$nextPage = $currentPage < $totalPage ? $currentPage + 1 : $totalPage;
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>图书管理</title>
<style>
#main{margin:50px;}
.header a{margin-right: 20px;}
.page a {margin-right: 10px;}
</style>
</head>
<body>
<div id="main">
<div class="header"><a href="addform.php">添加记录</a> <a href="searchform.php">查找记录</a></div>
<table border="1" width="80%"><form method="POST">
<tr bgcolor="#23afca"><th>书号</th><th>作者</th><th>书名</th><th>出版社</th><th>书籍介绍</th><th>出版日期</th><th>定价</th><th>删除</th><th>更新</th></tr>
<?php
while($v = mysqli_fetch_array($list)){
?>
<tr><td><?php echo $v['bookno'];?></td>
<td><?php echo $v['author'];?></td>
<td><?php echo $v['bookname'];?></td>
<td><?php echo $v['publisher'];?></td>
<td><?php echo $v['intro'];?></td>
<td><?php echo $v['time'];?></td>
<td><?php echo $v['price'];?></td>
<td><input type="checkbox" name="bookno[]" value="<?php echo $v['bookno'];?>" /></td>
<td><a href="editform.php?id=<?php echo $v['bookno'];?>">更新</a></td>
</tr>
<?php
}
?>
<tr bgcolor="#23afca"><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th><input type="submit" value="删除" /></th><th></th></tr></form>
</table>
<div>共有 <?php echo $cou