php仅打印一行

如您所见,我正在从数据库中选择用户,但它只能打印一个!我有10位需要打印的用户。


<?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   }

      }

    }

      ?>


米脂
浏览 144回答 3
3回答

呼啦一阵风

请检查$ currentgroup的值。如果可以给出数据库表hjuma_users的屏幕快照以及$ currentgroup的值。我认为由于这种情况,您正在获得一种价值WHERE&nbsp;group1&nbsp;='$currentgroup'&nbsp;OR&nbsp;group2&nbsp;='$currentgroup'&nbsp;OR&nbsp;group3&nbsp;='$currentgroup'&nbsp;OR&nbsp;group4&nbsp;='$currentgroup'&nbsp;OR&nbsp;group5&nbsp;='$currentgroup
打开App,查看更多内容
随时随地看视频慕课网APP