搜索系统 - 查找您需要的信息 - 常规

搜索系统
<body>
	<div class="container">
		<div class="search-form">
			<form action="" method="get">
				<input class="search-input" type="text" name="search" placeholder="请输入搜索内容">
				<input class="search-button" type="submit" value="搜索">
			</form>
		</div>

		<div class="result">
			<?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 = 10;
			$page_max = $page * $number;
			$page_min = ($page - 1) * $number;

			$con = mysqli_connect("localhost", "efchp", "123456", "wenzhang");
			if (!$con) {
			    die('Could not connect: ' . mysqli_error($con));
			}
			mysqli_set_charset($con, "utf8");

			$total_view_query = mysqli_query($con, "SELECT SUM(time) AS total_view FROM tiku WHERE (timu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR beizhu LIKE '%" . $search . "%')");
			$total_view = mysqli_fetch_array($total_view_query)['total_view'];

			$result = mysqli_query($con, "SELECT *, (view / " . $total_view . ") AS view_ratio FROM tiku WHERE (timu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR beizhu 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 tiku WHERE (timu LIKE '%" . $search . "%' OR jieshi LIKE '%" . $search . "%' OR beizhu LIKE '%" . $search . "%')");
			$row = mysqli_fetch_array($lianjie_count);
			$total_count = $row['total_count'];

			$numerator = $total_count;   // 分子
			$denominator = $number;  // 分母
			$page_count = ceil($numerator / $denominator);
			?>
			
			<?php
			 echo "本站共有" . $total_count . "条信息，总共被浏览" . $total_view . "次";
			 foreach ($arr as $key => $value) {
			 ?>
			 <div class="result-item">
				 <a href="view.php?lianjie=<?php echo $value['lianjie']; ?>" target="_blank"><?php echo $value['name']; ?></a>
				 <br>
				 <?php echo $value['shows']; ?>
			 </div>
			 <?php
			 }
			 ?>
		</div>

		<div class="pagination">
			<?php
			 echo "<a href='?search=" . $search . "&page=1'><<</a>";
			 echo "<a href='?search=" . $search . "&page=" . ($page - 1) . "'><</a>";
			 for ($i = 1; $i <= $page_count && $i <= $page_web_max; $i++) {
				 echo "<a href='?search=" . $search . "&page=" . $i . "'>" . $i . "</a>";
				 $page = $i;
			 }
			 echo "<a href='?search=" . $search . "&page=" . ($page + 1) . "'>></a>";
			 echo "<a href='?search=" . $search . "&page=" . $page . "'>>></a>";
			 ?>
		</div>
	</div>
</body>