给我提供一个学生信息管理系统的主页 需要有分页
以下是一个学生信息管理系统主页的示例代码,包含分页功能:
<!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 著作权归作者所有。请勿转载和采集!