tushuguan.zip
资源内容介绍
tushuguan.zip <?phpinclude('./conn.php');// 获取搜索关键词$search_keyword = '';if (!empty($_POST['search'])) { $search_keyword = $_POST['search'];}// 查询书籍信息$query = "SELECT * FROM books WHERE title LIKE '%$search_keyword%' OR author LIKE '%$search_keyword%'";$result = $conn->query($query);?><!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <link rel="stylesheet" href="./css/bootstrap.min.css"> <title>书籍管理</title> <style> body { background-color: #f8f9fa; } .container { margin-top: 50px; background-color: #ffffff; padding: 20px; border-radius: 8px; box-shadow: 0 0 10px rgba(0, 0, 0, 0.1); } .table th, .table td { vertical-align: middle; } .table img { display: block; margin: 0 auto; } .table-hover tbody tr:hover { background-color: #f1f1f1; } </style></head><body><?php include "header.php"; // 检查用户角色是否为管理员 if (!$_SESSION['username']) { echo "<script>alert('请先登录管理员账号'); window.location.href='login.php';</script>"; exit; } ?><div class="container"> <!-- 搜索框 --> <form method="POST" class="mb-4"> <div class="input-group"> <input type="text" class="form-control" placeholder="搜索书名或作者" name="search" value="<?php echo $search_keyword; ?>"> <div class="input-group-append"> <button class="btn btn-primary" type="submit">搜索</button> </div> </div> </form> <!-- 书籍表格 --> <div class="table-responsive"> <table class="table table-bordered table-hover"> <thead class="thead-dark"> <tr> <th>序号</th> <th>书名</th> <th>作者</th> <th>描述</th> <th>价格</th> <th style="width: 5%;">分类</th> <th>图片</th> <th>创建时间</th> <th style="width: 10%;">操作</th> </tr> </thead> <tbody> <?php if ($result->num_rows > 0) { $index = 1; while ($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td>" . $index++ . "</td>"; echo "<td>" . $row['title'] . "</td>"; echo "<td>" . $row['author'] . "</td>"; echo "<td>" . $row['description'] . "</td>"; echo "<td>" . $row['price'] . "</td>"; echo "<td>" . $row['category'] . "</td>"; echo "<td><img src='./" . $row['image_path'] . "' alt='书籍图片' style='width: 100px;'></td>"; echo "<td>" . $row['created_at'] . "</td>"; echo "<td>"; echo "<a href='edit_book.php?book_id=" . $row['book_id'] . "' class='btn btn-warning btn-sm'>编辑</a> "; echo "<a href='delete_book.php?book_id=" . $row['book_id'] . "' class='btn btn-danger btn-sm' onclick='return confirm(\"确定要删除这本书吗?\");'>删除</a>"; echo "</td>"; echo "</tr>"; } } else { echo "<tr><td colspan='9' class='text-center'>没有找到书籍信息</td></tr>"; } ?> </tbody> </table> </div></div><script src="./js/jquery.min.js"></script><script src="./js/bootstrap.min.js"></script></body></html><?php$conn->close();?>