php - 使用 php 获取行/列中的数据

Question

我想在表格中制作 4 列。在代码中，所有图像都是单行单列。但我想要一行包含 4 列和 4 个图像(从数据库获取图像)，然后创建另一行并自动添加接下来的 4 个图像等。我不知道如何做到这一点，任何人都可以建议我如何做到这一点。

  <form name="form">
    <select id="sorting" style="width:140px" onChange="optionCheck()">
      <option id="s">---Sort By----</option>
      <option value="bydate">Sort By Date</option>
      <option value="bytopic">Sort By Topic</option>
    </select>
  </form>
  <br />
</div>

<?php include 'connection.php'; ?>

<div id="showByDefault">
  <table style="width:60%">
  <tr>
    <?php   include 'connection.php';  ?>
<div id="showByDefault">
<!--<table style="width:60%"><tr>-->


 <?php
      $sql1=mysqli_query($con,"select * from `insert-n-retrive-pdf` ORDER BY date DESC") or die(mysqli_error($con));
      $i=0;
      echo "<table><tr>";

  while($row=mysqli_fetch_array($sql1))
  { 
   if($i != 0 && $i%4 == 0) {
        echo '<tr></tr>';
    }
    ?> <td style="padding:20px;">


     <a href="<?php echo $row["path"]; ?>" target="_blank"><img src="<?php echo $row["thumbnails"]; ?>" /></a></td><?php

        echo '</tr>';
    $i++;
  }   
?></tr></table>
</div>

<div id="hideall">
    <div id="topic1">
      <?php include 'pdf-sort-by-topic.php'; ?>
    </div>

    <div id="topic">
      <?php include 'pdf-sort-by-date.php'; ?>
    </div>
</div>

Answer 1

Try this one 100% working: Nice and easy.

    <?php

            $sql1=mysqli_query($con,"select * from `insert-n-retrive-pdf` ORDER BY date DESC") or die(mysqli_error($con));
            $i = 0;
            echo "<tr>";
            while($row=mysqli_fetch_array($sql1)) { 
                if($i != 0 && $i%4 == 0) {
                    echo "</tr><tr>";
                }

    ?>          
                <td style="padding:20px;"><a href="<?php echo $row["path"]; ?>" target="_blank"><img src="<?php echo $row["thumbnails"]; ?>" /></a></td>
    <?php       
                $i++;
            }
    ?>

希望这有帮助!