如何通过PHP中的其他列获取表组中的数据

Question

我在数据库里有这样的记录：

section_id    description    level_id
1             Amethyst       1
2             Betelguise     1
3             Daisy          2
4             Rose           2

我希望它显示在我的php表中，如下所示：

Level 1      
Amethyst     
Betelguise   

Level 2
Daisy
Rose

有人能帮帮我吗？我是新来的。这是我的密码：

<table>
<thead>
<tr>
<th>Descriptions</th>
<th>Level</th>
</tr>
</thead>
                <?php $sql = "SELECT * FROM tbl_sectiontaken"; ?>
                <?php $result = $db->query($sql); ?>
                <?php if ($result->num_rows > 0) { ?>
                    <?php while($row = $result->fetch_assoc()) { ?>
                        <?php $id = $row['section_id'];
                        $desc = $row['description'];
                        $gr = $row['level_id']; ?>
 <tbody>
            <tr>
                <td style="text-transform:capitalized;">
                    <?php echo $desc; ?>
                </td>
                <td style="text-transform:capitalized;">
                    <?php echo $gr; ?>
                </td>
            </tr>
                <?php } ?>
                <?php } ?>
</tbody>
</table>

但它给了我这个表中的结果：

Descriptions    Level
Amethyst        1
Betelguise      1
Daisy           2
Rose            2

Answer 1

为此，您可以使用group_concat函数。如果适合您的要求，请使用下面的代码

<?php $sql = "SELECT level_id,GROUP_CONCAT(description) AS description FROM series group by level_id"; ?>
<?php $result = $db->query($sql); ?>
<?php if ($result->num_rows > 0) { ?>
    <?php while ($row = $result->fetch_assoc()) { ?>
        <?php
        $id = $row['section_id'];
        $desc = $row['description'];
        $gr = $row['level_id'];
        $leveArr[$gr][] = $desc;// Create an array with level and description
    }  } ?>
</tbody>

<table>
    <tr><!-- header-->
        <?php foreach ($leveArr as $key => $value) { ?>
            <td><?php echo "LEVEL " . $key ?></td>
        <?php } ?>
    </tr>

    <tr>
        <?php foreach ($leveArr as $key => $value) { 
            foreach ($value as $key_1 => $data) { ?>
                <td><?php
                $data = explode(",", $data);

                foreach ($data as $key_2 => $final) {
                    echo $final . "<br>";
                }
                ?></td>
                <?php }


             } ?>
    </tr>

</table>

Answer 2

更新的

检查沙箱示例

用GROUP_CONCAT更改查询

SELECT  GROUP_CONCAT(if (description ='', null, description)) as description,count(description) as heigher,level_id FROM yourtablename WHERE 1 GROUP BY level_id

和After.They返回数组如下

$arr=[['description'=>'a,b,c,d','level_id'=>'1','heigher'=>'4'],['description'=>'a,b,c,d','level_id'=>'2','heigher'=>'4']]; ?>

然后，最后创建如下表

$sql="SELECT  GROUP_CONCAT(if (description ='', null, description)) as description,count(description) as heigher,level_id FROM yourtablename WHERE 1 GROUP BY level_id";
$result = $conn->query($sql);
   $arr =[];
   if ($result->num_rows > 0) {
     while($row = $result->fetch_assoc()){
       $arr[]=$row;
     }
    }
        <table>
      <thead>
        <tr>
          <?php foreach ($arr as $key => $value): ?>
            <th><?='level'.$value['level_id']?></th>
          <?php endforeach; ?>
        </tr>
      </thead>
      <tbody>
        <?php
           $arr = array_filter($arr,function($a=[]){
             return $a['level_id'] != 0
            }) //filter level not a zero
        $h = max(array_map(function($a=[]){
          return $a['heigher']; //filter array['heigher only']
        },$arr)); // its get the heighest length of description value like [10,15,100]=>100
        foreach ($arr as $key => $value){
           $value['description'] = !empty($value['description']) ?explode(',',$value['description']):'';
           $arr[$key]=$value;
         }
         ?>
          <?php for ($i=0; $i < $h[0]; $i++) {?>
            <tr>
              <?php foreach ($arr as $key => $value): ?>
                <th><?=isset($value['description'][$i])? $value['description'][$i] :''?></th>
              <?php endforeach; ?>
            </tr>
        <?php }?>
      </tbody>
    </table>