php - 对表格输出的循环进行分页
问题描述
我有 2 个表,我加入了一个 sql 查询。然后我为每个表拉一次该 sql 查询并将其限制为前 10 个结果
我试图通过限制提取的数据量来对查询进行分页,但它破坏了我的表输出。
这是当前代码
<?php
$a = 1;
$b = 1;
for( $i = 0; $i < 300; $i++){
$sql = "SELECT player.ID, player.Login, localrecord.map_id , localrecord.score FROM player JOIN localrecord ON player.ID = localrecord.Player_Id WHERE map_id = $a Order By score ASC LIMIT 10";
$result = $conn->query($sql);
$sql2 = "SELECT file FROM map WHERE ID = $a";
$mapName = $conn->query($sql2);
$mapNamerow = $mapName->fetch_assoc();
if ($result->num_rows > 0) {
// output data of each row
$WRQuery = "SELECT time_author FROM map WHERE ID =$a";
$WRResults = $conn->query($WRQuery);
$WRrow = $WRResults->fetch_assoc();
$WRtime = $WRrow['time_author'];
$WRmilliseconds = $WRtime % 1000;
$WRtime = floor($WRtime / 1000);
$WRseconds = $WRtime % 60;
$WRtime = floor($WRtime / 60);
$WRminutes = $WRtime % 60;
$WRtime = floor($WRtime / 60);
echo "<p class='mapTitle'> " . substr($mapNamerow['file'],11);
echo "<br/>Author's Time: " . $WRminutes . ":". $WRseconds.".". $WRmilliseconds . "</p>";
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Score <br/> Min:Sec.Mil</th>
</tr>";
while($row = $result->fetch_assoc()) {
$time = $row['score'];
$milliseconds = $time % 1000;
$time = floor($time / 1000);
$seconds = $time % 60;
$time = floor($time / 60);
$minutes = $time % 60;
$time = floor($time / 60);
echo "<tr>";
echo "<td>" . $row['Login'] . "</td>";
echo "<td>" . $minutes.':'.$seconds.'.'.$milliseconds . "</td>";
echo "</tr>";
}
echo "</table>";
echo "<br/>";
}
$a++;
}
?>
millisecond-tm-121.Gbx
Author's Time: 0:14.344
Name Score Min:Sec.Mil
mattman0123 0:18.309
millisecond-tm-107.Gbx
Author's Time: 0:16.966
Name Score Min:Sec.Mil
mattman0123 0:17.202
这是当前的输出;
我有大约 200 个要显示的表格,但我不希望它们一次显示所有表格。
有任何想法吗?
解决方案
推荐阅读
- python - 使用 seaborn displot 我无法指定色调来分隔 kde 图的三个类别
- sqlalchemy - 将现有类定义与现有数据库 sqlalchemy 一起使用
- c# - 为什么创建这些线程不会释放内存?
- python - 使用python弹性搜索包访问aws弹性搜索角色
- angular - 将 Salesforce Login Soap Api 与 Angular 集成
- c# - 使用 C# SDK SSR_DeleteEnrollData 的 ZK / ESSL 生物识别集成
- swift5 - iOS CoreML如何强制图像分类模型不贪心?
- javascript - 如何计算列表中添加的相同项目的出现?
- postgresql - 时间戳可以在剩余字段中占用系统时间吗?
- shapefile - Momepy Geodataframe to Shapefile Error with Class 'list'