美化这个页面php$search = $_GETsearch;$page = isset$_GETpage $_GETpage 1;$page_web_max = 8;$page_web_min = 1;if $page = $page_web_max $page = $page_web_max;if $page = $page_web_min $page = $page_web_min;$n
<?php
$search = $_GET['search'];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$page_web_max = 8;
$page_web_min = 1;
if ($page >= $page_web_max) {
$page = $page_web_max;
}
if ($page <= $page_web_min) {
$page = $page_web_min;
}
$number = 100;
$page_max = $page * $number;
$page_min = ($page - 1) * $number;
$con = mysqli_connect("localhost", "s0811030", "xwDO18fsYS");
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
mysqli_set_charset($con, "utf8");
mysqli_select_db($con, "s0811030");
$total_view_query = mysqli_query($con, "SELECT SUM(view) AS total_view FROM chengyudaquan WHERE (chengyu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR pinyin LIKE '%" . $search . "%')");
$total_view = mysqli_fetch_array($total_view_query)['total_view'];
$result = mysqli_query($con, "SELECT *, (view / " . $total_view . ") AS view_ratio FROM chengyudaquan WHERE (chengyu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR pinyin LIKE '%" . $search . "%') ORDER BY view_ratio DESC LIMIT " . $page_min . ", " . $number);
$arr = array();
while ($row = mysqli_fetch_array($result)) {
$arr[] = $row;
}
$lianjie_count = mysqli_query($con, "SELECT COUNT(*) AS total_count FROM chengyudaquan WHERE (chengyu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR pinyin LIKE '%" . $search . "%')");
$row = mysqli_fetch_array($lianjie_count);
$total_count = $row['total_count'];
$numerator = $total_count; // 分子
$denominator = $number; // 分母
$page_count = ceil($numerator / $denominator);
?>
<html>
<head>
<meta charset="UTF-8">
<title>搜索系统</title>
<style>
body {
max-width: 500px;
margin: 0 auto;
}
<pre><code> form {
text-align: center;
margin-top: 20px;
}
input[type="text"] {
width: 200px;
padding: 5px;
margin-right: 10px;
}
input[type="submit"] {
padding: 5px 10px;
background-color: #337ab7;
border: none;
color: #fff;
cursor: pointer;
}
div.container {
margin-top: 20px;
}
a.page-link {
display: inline-block;
padding: 5px 10px;
background-color: #f5f5f5;
color: #333;
text-decoration: none;
border: 1px solid #ddd;
margin-right: 5px;
}
a.page-link.active {
background-color: #337ab7;
color: #fff;
}
</style>
</code></pre>
</head>
<body>
<div class="container">
<form action="" method="get">
<input type="text" name="search" placeholder="遵简一下">
<input type="submit" value="搜索">
</form>
<pre><code> <p>本站共有<?php echo $total_count; ?>条信息，总共被浏览<?php echo $total_view; ?>次</p>
<div>
<?php if ($page > 1) : ?>
<a class="page-link" href="?search=<?php echo $search; ?>&page=1">&lt;&lt;</a>
<a class="page-link" href="?search=<?php echo $search; ?>&page=<?php echo ($page - 1); ?>">&lt;</a>
<?php endif; ?>
<?php for ($i = 1; $i <= $page_count && $i <= $page_web_max; $i++) : ?>
<?php if ($i == $page) : ?>
<a class="page-link active" href="?search=<?php echo $search; ?>&page=<?php echo $i; ?>"><?php echo $i; ?></a>
<?php else : ?>
<a class="page-link" href="?search=<?php echo $search; ?>&page=<?php echo $i; ?>"><?php echo $i; ?></a>
<?php endif; ?>
<?php endfor; ?>
<?php if ($page < $page_count) : ?>
<a class="page-link" href="?search=<?php echo $search; ?>&page=<?php echo ($page + 1); ?>">&gt;</a>
<a class="page-link" href="?search=<?php echo $search; ?>&page=<?php echo $page_count; ?>">&gt;&gt;</a>
<?php endif; ?>
</div>
<?php foreach ($arr as $key => $value) : ?>
<button onclick="window.location.href='view.php?chengyu=<?php echo $value['chengyu']; ?>'"><?php echo $value['chengyu']; ?></button>
<?php endforeach; ?>
</div>
</code></pre>
</body>
</html
原文地址: https://www.cveoy.top/t/topic/iN1T 著作权归作者所有。请勿转载和采集!