dongrenshi0889 2019-04-21 14:32
浏览 111

Php只打印一行

As you can see, i'm selecting user from data base, but its only printing one! I have like 10 users that needs to be printed.

<?php
      session_start();
      $currentgroup = $_SESSION['groupname'];
      $sql1 = "SELECT * FROM hjuma_users WHERE group1 ='$currentgroup' OR group2 ='$currentgroup' OR group3 ='$currentgroup' OR group4 ='$currentgroup' OR group5 ='$currentgroup';";
      if($result1 = mysqli_query($conn, $sql1)){
        if(mysqli_num_rows($result1) > 0){
            while($row1 = mysqli_fetch_array($result1)){ ?>


<div id="id01" class="modal">
  <form class="modal-content animate" action="/action_page.php">
    <div class="imgcontainer">
      <span onclick="document.getElementById('id01').style.display='none'" class="close" title="Close Modal">&times;</span>
    </div>
    <div class="container">
      <?php echo $row1['username']; ?>

    </div>


  </form>
</div>
<?php   }
      }
    }
      ?>
  • 写回答

3条回答 默认 最新

  • dongweishi2028 2019-04-21 14:37
    关注

    You should use mysqli_fetch_assoc as below code:

    session_start();
    $currentgroup = $_SESSION['groupname'];
    $sql1 = "SELECT * FROM hjuma_users WHERE group1 ='$currentgroup' OR group2 ='$currentgroup' OR group3 ='$currentgroup' OR group4 ='$currentgroup' OR group5 ='$currentgroup';";
    if ($result1 = mysqli_query($conn, $sql1)) {
        if (mysqli_num_rows($result1) > 0) {
            $modalId = 1;
            while ($row1 = mysqli_fetch_assoc($result1)) { ?>
                <div id="id<?php echo $modalId; ?>" class = "modal">
                <form class = "modal-content animate" action = "/action_page.php">
                <div class = "imgcontainer">
                <span onclick = "document.getElementById('id<?php echo $modalId; ?>').style.display='none'" class = "close" title = "Close Modal">&times;
                </span>
                </div>
                <div class = "container">
                <?php echo $row1['username'];
    ?>
    
                </div>
    
    
                </form>
                </div>
            <?php
            $modalId++;
            }
        }
    }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 matlab中使用gurobi时报错
  • ¥15 WPF 大屏看板表格背景图片设置
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
  • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
  • ¥16 mybatis的代理对象无法通过@Autowired装填
  • ¥15 可见光定位matlab仿真
  • ¥15 arduino 四自由度机械臂