排序表和颜色列

bq9c1y66  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(199)

我用这个链接使我的表可以排序:link
有没有办法让目标列在接受的答案之后变成不同的颜色?所以你可以看到,哪一列被排序?
更新
这是我的密码:

<?php
$sql = "SELECT * FROM s5_players";    
if ($_GET['sort'] == 'matches')
{
    $sql .= " ORDER BY matches";
}
elseif ($_GET['sort'] == 'goals')
{
    $sql .= " ORDER BY goals";
}
elseif ($_GET['sort'] == 'assists')
{
    $sql .= " ORDER BY assists";
}
elseif($_GET['sort'] == 'cards')
{
    $sql .= " ORDER BY cards";
}
else
{
    $sql .= " ORDER BY goals";
}
$>

以及:

<td>Name:</td>
<td><a href="mypage.php?sort=matches">Matches:</td>
<td><a href="mypage.php?sort=goals">Goals:</a></td>
<td><a href="mypage.php?sort=assists">Assists:</a></td>
<td><a href="mypage.php?sort=cards">Cards:</a></td>

再往下看:

$number = 1;
foreach($results as $row){
echo '
<tr class="statistikker">
<td style="background: #666; text-align: center; color: white; font-weight: bold;">'.$number.'</td>
<td style="padding-left: 5px">'.$row->name.'</td>
<td class="center">'.$row->matches.'</td>
<td class="center">'.$row->goal.'</td>
<td class="center">'.$row->assist.'</td>
<td class="center">'.$row->cards.'</td>
</tr>';
$number++;
};
bxjv4tth

bxjv4tth1#

下面的代码不是优化的,而是您想要实现的。

$number = 1;

foreach($results as $row){
    echo '
        <tr class="statistikker">
            <td style="background: #666; text-align: center; color: white; font-weight: bold;">'.$number.'</td>
            <td style="padding-left: 5px">'.$row->name.'</td>
            <td class="center '.($_GET['sort'] == 'matches' ? 'selected' : '').'">'.$row->matches.'</td>
            <td class="center '.((!isset($_GET['sort']) || $_GET['sort'] == 'goal' ? 'selected' : '').'">'.$row->goal.'</td>
            <td class="center '.($_GET['sort'] == 'assist' ? 'selected' : '').'">'.$row->assist.'</td>
            <td class="center '.($_GET['sort'] == 'cards' ? 'selected' : '').'">'.$row->cards.'</td>
        </tr>';
    $number++;
};

更新:我添加了 !isset($_GET['sort']) 在球门上 td 用于反映以下op注解的元素stating goal是标准排序参数。
它增加了类 selected 到相关部门 td 元素。然后可以为此创建一个css规则 selected 类来更改 background-color 像这样的财产:

.selected {
    background-color: red;
}

相关问题