学生信息管理系统主页 - 分页显示学生数据 - 常规

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

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