添加一个分页系统phpincludeconfigphp; 连接数据库$search = $_POSTsearch;$str =SELECT FROM wenzhang WHERE wenzhang_name LIKE $search OR wenzhang_neirong LIKE $search OR wenzhang_miaoshu LIKE $search and

这是一个简单的分页系统示例，你可以根据自己的需求进行修改和适配。

<?php
include('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);  // 总页数
$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 LIMIT $offset, $page_size";  // 分页查询的 SQL
$result = mysqli_query($con, $sql);
$arr = array();
while ($row = mysqli_fetch_array($result)) {
    $arr[] = $row;
    $user_id = $row['user_login_id'];
    $sql = "SELECT * FROM user WHERE user_login_id = '$user_id'";
    $result2 = mysqli_query($con, $sql);
    $user_info = mysqli_fetch_assoc($result2);
}
?>

<!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;
        }

        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>
</head>
<body>
<h1>查询中心</h1>
<div>
    <form id="searchForm" method="post">
        <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='ge.php?wenzhang_id=<?php echo $value['wenzhang_id'];?>';">
                <h3><?php echo $value['wenzhang_name'];?></h3>
                <p><?php echo $value['wenzhang_miaoshu'];?></p>
                <div class="metrics">
                    <p class="likes"><?php echo $user_info['user_name'];?></p>
                    <p class="views">浏览: <?php echo $value['wenzhang_view'];?>点赞: <?php echo $value['wenzhang_dianzan'];?></p>
                </div>
            </div>
        <?php } ?>
    </div>
    <div class="pagination">
        <?php if ($page > 1) { ?>
            <a href="?page=<?php echo $page - 1; ?>">上一页</a>
        <?php } ?>
        <?php for ($i = 1; $i <= $total_pages; $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>

在上述代码中，我们添加了以下内容：

添加了 $page 和 $page_size 变量来控制分页。通过 $_GET['page'] 获取当前页码，默认为第一页。
根据当前页码计算出偏移量 $offset 和总页数 $total_pages。
修改 SQL 查询语句，使用 $offset 和 $page_size 进行分页查询。
在页面底部添加了分页导航，点击上一页和下一页时会根据当前页码重新加载页面