以下是一个学生信息管理系统主页的示例代码,包含分页功能:

<!DOCTYPE html>
<html>
<head>
	<title>学生信息管理系统</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
	<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>
	<div class="container">
		<h1>学生信息管理系统</h1>
		<table class="table table-striped">
			<thead>
				<tr>
					<th>学号</th>
					<th>姓名</th>
					<th>性别</th>
					<th>年龄</th>
				</tr>
			</thead>
			<tbody>
				<?php
				//连接数据库
				$servername = "localhost";
				$username = "root";
				$password = "";
				$dbname = "student_db";
				$conn = new mysqli($servername, $username, $password, $dbname);
				if ($conn->connect_error) {
					die("连接失败: " . $conn->connect_error);
				}

				//查询数据
				$page = isset($_GET["page"]) ? $_GET["page"] : 1;
				$pagesize = 10;
				$start = ($page - 1) * $pagesize;
				$sql = "SELECT * FROM student_info LIMIT $start, $pagesize";
				$result = $conn->query($sql);
				if ($result->num_rows > 0) {
					while($row = $result->fetch_assoc()) {
						$id = $row["id"];
						$name = $row["name"];
						$gender = $row["gender"];
						$age = $row["age"];
						echo "<tr><td>$id</td><td>$name</td><td>$gender</td><td>$age</td></tr>";
					}
				} else {
					echo "<tr><td colspan='4'>没有数据</td></tr>";
				}
				$conn->close();
				?>
			</tbody>
		</table>
		<ul class="pagination">
			<?php
			//计算页数
			$conn = new mysqli($servername, $username, $password, $dbname);
			$sql = "SELECT COUNT(*) AS total FROM student_info";
			$result = $conn->query($sql);
			$row = $result->fetch_assoc();
			$total = $row["total"];
			$total_pages = ceil($total / $pagesize);

			//生成分页链接
			if ($page > 1) {
				echo "<li><a href='index.php?page=".($page-1)."'>上一页</a></li>";
			}
			for ($i=1; $i<=$total_pages; $i++) {
				if ($i == $page) {
					echo "<li class='active'><a href='index.php?page=$i'>$i</a></li>";
				} else {
					echo "<li><a href='index.php?page=$i'>$i</a></li>";
				}
			}
			if ($page < $total_pages) {
				echo "<li><a href='index.php?page=".($page+1)."'>下一页</a></li>";
			}
			$conn->close();
			?>
		</ul>
	</div>
</body>
</html>

注意:此示例代码仅供参考,实际情况可能需要根据具体需求进行修改


原文地址: https://www.cveoy.top/t/topic/fc9F 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录