修改错误phprequire_once configphp;$search = $_POSTsearch;$page = isset$_GETpage $_GETpage 1; 获取当前页码默认为第一页$page_size = 20; 每页显示的记录数$offset = $page - 1 $page_size; 计算偏移量$count_sql = SELECT COUNT FR
<?php
require_once '../../config.php';
$search = $_POST['search'];
$page = isset($_GET['page']) ? $_GET['page'] : 1; // 获取当前页码，默认为第一页
$page_size = 20; // 每页显示的记录数
$offset = ($page - 1) * $page_size; // 计算偏移量
$count_sql = "SELECT COUNT(*) FROM wenzhang WHERE (wenzhang_name LIKE '%" . $search . "%' OR wenzhang_neirong LIKE '%" . $search . "%' OR wenzhang_miaoshu LIKE '%" . $search . "%') and wenzhang_shenhe = '已通过'"; // 获取总记录数的 SQL
$result = mysqli_query($con, $count_sql);
$total = mysqli_fetch_row($result)[0]; // 总记录数
$total_pages = ceil($total / $page_size); // 总页数
if ($page > $total_pages) { // 如果当前页码超过总页码数，则跳转到最后一页
header("Location: ?page=" . $total_pages);
exit;
}
$sql = "SELECT * FROM wenzhang WHERE (wenzhang_name LIKE '%" . $search . "%' OR wenzhang_neirong LIKE '%" . $search . "%' OR wenzhang_miaoshu LIKE '%" . $search . "%') and wenzhang_shenhe = '已通过' order by wenzhang_new DESC LIMIT $offset, $page_size"; // 分页查询的 SQL
$result = mysqli_query($con, $sql);
$arr = array();
while ($row = mysqli_fetch_array($result)) {
$arr[] = $row;
$user_login_id = $row['user_login_id'];
$wenzhang_id = $row['wenzhang_id'];
$wenzhang_name = $row['wenzhang_name'];
$wenzhang_neirong = $row['wenzhang_neirong'];
$wenzhang_miaoshu = $row['wenzhang_miaoshu'];
$wenzhang_view = $row['wenzhang_view'];
$wenzhang_dianzan = $row['wenzhang_dianzan'];
$sql1 = "SELECT * FROM user WHERE user_login_id = '$user_login_id'";
$result2 = mysqli_query($con, $sql1);
$user_info = mysqli_fetch_assoc($result2);
$user_name = $user_info['user_name'];
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询中心</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0">
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<style>
body {
font-family: Arial, sans-serif;
background-color: #f2f2f2;
margin: 0;
padding: 0;
}
<pre><code> h1 {
color: #333333;
text-align: center;
padding: 20px;
background-color: #ffffff;
margin: 0;
}
form {
max-width: 600px;
margin: 20px auto;
background-color: #ffffff;
padding: 20px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
}
label {
display: block;
margin-bottom: 10px;
font-weight: bold;
}
input[type="text"],
textarea {
width: 100%;
padding: 10px;
font-size: 16px;
border: 1px solid #cccccc;
border-radius: 4px;
}
input[type="submit"] {
background-color: #333333;
color: #ffffff;
padding: 10px 20px;
font-size: 16px;
border: none;
border-radius: 4px;
cursor: pointer;
}
input[type="submit"]:hover {
background-color: #555555;
}
.searchResult {
max-width: 600px;
margin: 20px auto;
}
.result {
background-color: #ffffff;
padding: 20px;
box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
display: flex;
flex-direction: column;
justify-content: space-between;
align-items: flex-start;
margin-bottom: 20px;
}
.result h3 {
margin-bottom: 10px;
}
.result p {
margin-bottom: 5px;
}
.result .author {
align-self: flex-start;
}
.result .metrics {
display: flex;
justify-content: space-between;
align-items: center;
width: 100%;
}
.result .metrics .likes {
text-align: right;
}
.result .metrics .views {
text-align: right;
}
.pagination {
margin-top: 20px;
text-align: center;
}
.pagination a {
display: inline-block;
padding: 5px 10px;
margin: 0 5px;
background-color: #333333;
color: #ffffff;
text-decoration: none;
border-radius: 4px;
}
.pagination a:hover {
background-color: #555555;
}
.pagination .active {
background-color: #555555;
}
</style>
<script>
$(document).ready(function() {
$("#searchInput").on("input", function() {
var searchValue = $(this).val();
$.ajax({
type: "POST",
url: "search.php", // 修改为您的搜索处理页面
data: { search: searchValue },
success: function(response) {
$(".result").remove(); // 清除之前的搜索结果
$(".searchResult").append(response); // 添加新的搜索结果
}
});
});
});
</script>
</code></pre>
</head>
<body>
<div>
<form id="searchForm" method="post" action="/fen/share/index.php">
<input type="text" name="search" id="searchInput" value="" placeholder="">
</form>
<div class="searchResult">
<?php foreach ($arr as $key=>$value) { ?>
<div class="result" onclick="location.href='/fen/share/ge.php?wenzhang_id=<?php echo $value['wenzhang_id'];?>';">
<h3><?php echo $value['wenzhang_name'];?></h3>
<?php echo $value['wenzhang_miaoshu'];?>
<div class="metrics">
<p class="author"><?php echo $user_name;?></p>
<p class="views">浏览: <?php echo $value['wenzhang_view'];?> 点赞: <?php echo $value['wenzhang_dianzan'];?></p>
</div>
</div>
<?php } ?>
</div>
<div class="pagination" align="center">
<?php if ($page > 1) { ?>
<a href="?page=<?php echo $page - 1; ?>">上一页</a>
<?php } ?>
<?php for ($i = 1; $i <= min($total_pages, 100); $i++) { ?>
<a href="?page=<?php echo $i; ?>" <?php if ($i == $page) echo 'class="active"'; ?>><?php echo $i; ?></a>
<?php } ?>
<?php if ($page < $total_pages) { ?>
<a href="?page=<?php echo $page + 1; ?>">下一页</a>
<?php } ?>
</div>
</div>
</body>
</html
原文地址: https://www.cveoy.top/t/topic/hXja 著作权归作者所有。请勿转载和采集!