dougehe2022 2018-12-29 19:47
浏览 52
已采纳

如何回显按组/列列出的PHP / HTML中的名称

I'm making a NASCAR league for my family, and I'm working on a roster page so they can add or remove drivers. How do I list the drivers from the rank they're in which can be found in the database? (A/B/C/D/E groups)

This is for my website's roster page, I've tried to look for the group they were in from their database group.

<div class="container">
<div class="row">
<div class="col-md-4" style="margin: 0px auto;float: none;">
<div class="card">
<div class="card-body">
<font style="font-size: 18px;">Add/Remove Drivers</font>
<div style="height:10px"></div>
<center><strong>Rank A</strong></center>

 </div>
</div>

I want Rank A to show the drivers in Rank A which is sorted like the picture linked. And then, b, c, d, e and so on. https://gyazo.com/8c5c987c9dc7202ff90913f1125057ce

Thank you!

  • 写回答

1条回答 默认 最新

  • dongshi3361 2018-12-29 20:00
    关注

    Here is an example of how you can output your data.

    $stmt = (new PDO('dsn here', 'username', 'password', [
                PDO::EMULATE_PREPARES => false
            ]))->Prepare('SELECT * FROM yourTable WHERE `group` = ?');
    
    $stmt->execute(array('B'), PDO::FETCH_ASSOC);
    
    foreach($stmt->fetchAll() as $row) {
        echo $row['driver_name']; # Kurt Busch
    }
    

    Here, each result is returned as an associative array when we execute \PDOResult::fetchAll. The keys of the multidimensional array hold your column names.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 evo评估时曲线出现问题
  • ¥15 eNSP拓扑图配置实验
  • ¥20 有没有兄弟会替换fmod studio的.bank文件内的音效?
  • ¥20 如何解决访问网址被屏蔽的情况
  • ¥15 本地运行的vue2项目,使用内网穿透,前端界面一直转圈圈
  • ¥20 powerbuilder datawindow控件导出Excel数据,可不可以不自动覆盖原数据,而是在后面新插入入数据。
  • ¥100 无轴承永磁同步电机控制
  • ¥15 eps里添加本地倾斜模型
  • ¥15 telegram 问题
  • ¥15 nrf52810-c三个a 程序