php - Player Ranks look really bad, how to optimize
问题描述
I want to make 3 tables with player rankings (I want to add a picture of the class and some other information there), but after taking the working tables and adding information from 1 database, I see that there is a lot of no needed code, which I don't know how to remove ...
I also have a problem, because under the tables I have a gray line that looks terribly ugly.
Thank you for all the help!
<?php include_once "settings.php";
//Ranking
//p1
$query0 = "
SELECT name, honor
FROM players
ORDER BY honor DESC
LIMIT 0,1
";
$result0 = mysqli_query($db, $query0);
$row0 = mysqli_fetch_row($result0);
//p2
$query1 = "
SELECT name, honor
FROM players
ORDER BY honor DESC
LIMIT 1,1
";
$result1 = mysqli_query($db, $query1);
$row1 = mysqli_fetch_row($result1);
//p3
$query2 = "
SELECT name, honor
FROM players
ORDER BY honor DESC
LIMIT 2,1
";
$result2 = mysqli_query($db, $query2);
$row2 = mysqli_fetch_row($result2);
//p4
$query3 = "
SELECT name, honor
FROM players
ORDER BY honor DESC
LIMIT 3,1
";
$result3 = mysqli_query($db, $query3);
$row3 = mysqli_fetch_row($result3);
//p5
$query4 = "
SELECT name, honor
FROM players
ORDER BY honor DESC
LIMIT 4,1
";
$result4 = mysqli_query($db, $query4);
$row4 = mysqli_fetch_row($result4);
//Strona
head("Ranking");
?>
<table style="width: 100%;" border="0">
<tbody>
<tr>
<td style="vertical-align: top; padding-left: 20px;">
<div class="btn_main">
<div class="btn_before"> </div>
<div class="btn_center"><span>Ranking graczy:</span></div>
<div class="btn_after"> </div>
</div>
<br>
<br>
<table align="center">
<tr>
<td>
<table>
<tr>
<td>
<div class="container">
<header>
<div class="btn_main">
<div class="btn_before"> </div>
<div class="btn_center"><span>Easy:</span></div>
<div class="btn_after"> </div>
</div>
</header>
<div class="wrapper">
<table align="center" class="tablea" border="1"
style="border-color:#343434" cellpadding="0"
cellspacing="1">
<thead>
<tr>
<th> P</th>
<th> Gracz</th>
<th> Cześć</th>
</tr>
</thead>
<tbody>
<tr>
<td class="poz">1</td>
<td class="Gracz"><?=$row0[0]?></td>
<td class="Cześć"><?=$row0[1]?></td>
</tr>
<tr>
<td class="poz">2</td>
<td class="Gracz"><?=$row1[0]?></td>
<td class="Cześć"><?=$row1[1]?></td>
</tr>
<tr>
<td class="poz">3</td>
<td class="Gracz"><?=$row2[0]?></td>
<td class="Cześć"><?=$row2[1]?></td>
</tr>
<tr>
<td class="poz">4</td>
<td class="Gracz"><?=$row3[0]?></td>
<td class="Cześć"><?=$row3[1]?></td>
</tr>
<tr>
<td class="poz">5</td>
<td class="Gracz"><?=$row4[0]?></td>
<td class="Cześć"><?=$row4[1]?></td>
</tr>
</tbody>
</table>
</div>
</div>
</td>
</tr>
</table>
</td>
<td>
<table>
<tr>
<td>
<div class="container">
<header>
<div class="btn_main">
<div class="btn_before"> </div>
<div class="btn_center"><span>Medium:</span></div>
<div class="btn_after"> </div>
</div>
</header>
<div class="wrapper">
<table align="center" class="tablea" border="1"
style="border-color:#343434" cellpadding="0"
cellspacing="1">
<thead>
<tr>
<th> P</th>
<th> Gracz</th>
<th> Cześć</th>
</tr>
</thead>
<tbody>
<tr>
<td class="poz">1</td>
<td class="Gracz"><?=$row0[0]?></td>
<td class="Cześć"><?=$row0[1]?></td>
</tr>
<tr>
<td class="poz">2</td>
<td class="Gracz"><?=$row1[0]?></td>
<td class="Cześć"><?=$row1[1]?></td>
</tr>
<tr>
<td class="poz">3</td>
<td class="Gracz"><?=$row2[0]?></td>
<td class="Cześć"><?=$row2[1]?></td>
</tr>
<tr>
<td class="poz">4</td>
<td class="Gracz"><?=$row3[0]?></td>
<td class="Cześć"><?=$row3[1]?></td>
</tr>
<tr>
<td class="poz">5</td>
<td class="Gracz"><?=$row4[0]?></td>
<td class="Cześć"><?=$row4[1]?></td>
</tr>
</tbody>
</table>
</div>
</div>
</td>
</tr>
</table>
</td>
<td>
<table>
<tr>
<td>
<div class="container">
<header>
<div class="btn_main">
<div class="btn_before"> </div>
<div class="btn_center"><span>Hard:</span></div>
<div class="btn_after"> </div>
</div>
</header>
<div class="wrapper">
<table align="center" class="tablea" border="1"
style="border-color:#343434" cellpadding="0"
cellspacing="1">
<thead>
<tr>
<th> P</th>
<th> Gracz</th>
<th> Cześć</th>
</tr>
</thead>
<tbody>
<tr>
<td class="poz">1</td>
<td class="Gracz"><?=$row0[0]?></td>
<td class="Cześć"><?=$row0[1]?></td>
</tr>
<tr>
<td class="poz">2</td>
<td class="Gracz"><?=$row1[0]?></td>
<td class="Cześć"><?=$row1[1]?></td>
</tr>
<tr>
<td class="poz">3</td>
<td class="Gracz"><?=$row2[0]?></td>
<td class="Cześć"><?=$row2[1]?></td>
</tr>
<tr>
<td class="poz">4</td>
<td class="Gracz"><?=$row3[0]?></td>
<td class="Cześć"><?=$row3[1]?></td>
</tr>
<tr>
<td class="poz">5</td>
<td class="Gracz"><?=$row4[0]?></td>
<td class="Cześć"><?=$row4[1]?></td>
</tr>
</tbody>
</table>
</div>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<BR>
<BR>
</td>
</tr>
</tbody>
</table>
<?php
foot()
?>
解决方案
做这样的事情:
$thisquery = "SELECT name, honor FROM players ORDER BY honor DESC LIMIT 0,4";
$query = mysqli_query($con,$thisquery);
while ($result = mysqli_fetch_array($query)) {
$resultArr[] = array($result["name"],$result["honor"]);
}
echo "<table id='mytable'>";
echo "<tr><td>Position</td><td>name</td><td>honor</td></tr>";
$i=0;
foreach($resultArr[] as $key => $value) {
$i++;
echo "<tr><td class=\"poz\">$i</td>
<td class=\"Gracz\"><?= $value[0] ?></td>
<td class=\"Cześć\"><?= $value[1] ?></td>
</tr>";
}
echo "</table>";
在您的 CSS 中,您可以像这样设置样式:
table #mytable td {
background: #eee;
}
(代码未经测试,只是输入,所以要小心拼写错误。)
推荐阅读
- android-mediaplayer - 播放 h.265 文件 android
- session - Symfony5:为功能测试准备会话内容
- css - 在 Gatsby.js 开发模式下使用 PostCSS 时 CSS 不保存
- sql - 优化存储过程
- mysql - 外键可以帮助我,还是我应该考虑一个新的数据库模式?
- amazon-web-services - 是否有适用于 AWS 数据管道的 Azure 集成运行时的等效项?
- javascript - 如何将删除按钮列附加到每个表行
- teamcity - 无论如何要同时更改多个工作目录?
- dataframe - 在 Julia 中检查 Dataframe 多列中的元素
- python - 我无法运行这个 .py 文件。收到很多错误。无法弄清楚发生了什么