如何使用用户名添加计数？

Question

大家好，我正在做一个像服务这样的水龙头清单

现在，我只是想知道如何显示他们的用户名与创建和最后更新的列表与他们的总水龙头根据他们的用户名。

我有一张我喜欢的照片，我只是不知道如何让它工作:/

我喜欢它看起来像什么

​

用户数据库表

​

​

列表的数据库表

​

​

代码

<?php
     $sql = "SELECT * FROM list  ";
     $result = mysqli_query($link, $sql);
     if( $result )    
     while($user = mysqli_fetch_assoc($result)) {
    ?> 
           <table class="table table-striped" id="faucetlist" width="100%" cellspacing="0">
                <thead>
                <tr>
                <th><center>Faucetlist</center></th>    
                <th><center>Created</center></th>                          
                <th><center>Last updated</center></th>
                <th><center>faucets</center></th> 
                 </tr>
                </thead>                      
             <tr>             
            <td><center><?php echo $user["username"]; ?></center></td>   
             <td><center><?php echo date('l jS F Y' , strtotime($user['Published']));?></center></td>              
            <td><center><?php echo date('h:i A' , strtotime($user['last_update']));?> </center></td>   
             <td><center>FAUCETS COUNT GO HERE </center></td>   

              </table>                    
       <?php } ?>

Answer 1

更改查询并遵循以下代码

<?php
         $sql = "SELECT list.*,count(username) as faucet  FROM list  GROUP BY username";
         $result = mysqli_query($link, $sql);
         if( $result )    
         while($user = mysqli_fetch_assoc($result)) {
        ?> 
               <table class="table table-striped" id="faucetlist" width="100%" cellspacing="0">
                    <thead>
                    <tr>
                    <th><center>Faucetlist</center></th>    
                    <th><center>Created</center></th>                          
                    <th><center>Last updated</center></th>
                    <th><center>faucets</center></th> 
                     </tr>
                    </thead>                      
                 <tr>             
                <td><center><?php echo $user["username"]; ?></center></td>   
                 <td><center><?php echo date('l jS F Y' , strtotime($user['Published']));?></center></td>              
                <td><center><?php echo date('h:i A' , strtotime($user['last_update']));?> </center></td>   
                 <td><center>FAUCETS COUNT GO HERE </center><?php echo $user['faucet'];   ?></td>   

                  </table>                    
           <?php } ?>