循环遍历多个数组并动态列出结果

I'm struggeling with this one. How can list all devices, their model and supplier from my database? The data is stored comma-separated in the fields device, model and supplier.

<?php
  while ($row = mysqli_fetch_array($result)) {
    $device_explode = explode(',', $row['device']);
    $model_explode = explode(',', $row['model']);
    $supplier_explode = explode(',', $row['supplier']);

    $device = array(array($device_explode[0]), //count function? How would I do that?
                    array($model_explode[0]),
                    array($supplier_explode[0])
                  );

    echo "<table border='1'>
        <tr>
            <th>Møterom</th>
            <th>Romnummer</th>
        <th>Lokasjon</th>
        <th>Antall sitteplasser</th>
        <th>Tilgjengelig utstyr</th>
        <th>Bilde av rommet</th>
        <th>Endre</th>
        <th>Slett</th>
        </tr>
      <tr>
        <td>".$row['name']."</td>
        <td>".$row['roomnbr']."</td>
        <td>".$row['location']."</td>
        <td>".$row['seats']."</td>
        <td>".$device[0][0]."<br>".$device[1][0]."<br>".$device[2][0]."<br></td> //also count?
        <td><img src='../img/uploads/".$row['img']."' width='150px' ></td>
        <td><a href='?p=editconfroomv2&id=".$row['id']."'>Endre</a></td>
        <td><a href='./index.php?p=deleteconfroomdb&id=".$row['id']."' class='delete'>Slett</a></td>
      </tr>
      </table>";
  }
?>

It can be done this way (if I understand correct your table structure). I assume, that $device_explode, $model_explode and $supplier_explode have equal number of elements:

<?php
  // Table Header
  echo "<table border='1'>
        <tr>
        <th>Møterom</th>
        <th>Romnummer</th>
        <th>Lokasjon</th>
        <th>Antall sitteplasser</th>
        <th>Tilgjengelig utstyr</th>
        <th>Bilde av rommet</th>
        <th>Endre</th>
        <th>Slett</th>
        </tr>";
  while ($row = mysqli_fetch_array($result)) {
    $device_explode = explode(',', $row['device']);
    $model_explode = explode(',', $row['model']);
    $supplier_explode = explode(',', $row['supplier']);

    // Table rows   
    $td = '';
    $td .= 
        "<tr>
            <td>".$row['name']."</td>
            <td>".$row['roomnbr']."</td>
            <td>".$row['location']."</td>
            <td>".$row['seats']."</td>
            <td>";

    for ($i = 0; $i < count($device_explode); $i++) {
        $td .=$device_explode[$i]." ".$model_explode[$i]." ".$supplier_explode[$i]."<br>";
    } 

    $td .= 
            "</td>
            <td><img src='../img/uploads/".$row['img']."' width='150px' ></td>
            <td><a href='?p=editconfroomv2&id=".$row['id']."'>Endre</a></td>
            <td><a href='./index.php?p=deleteconfroomdb&id=".$row['id']."' class='delete'>Slett</a></td>
        </tr>";
    echo $td;   
  }
  echo "</table>";
?>

I would suggest looping trough the arrays in the markup and generating the output using the html templating syntax and alternative control structures.

Some things i have done[not related directly to the question]:

• switched the array() syntax for the shorthand [can be done since version 5.4]
• switched from using a single echo to utilizing the html templating syntax [by expluding non dynamic parts from php and echoing the dynamic parts in]
• Switched from using the echo statement to using the shorthand
• Switched to alternative control structures

PHP documentation for strings

<?php

while ($row = mysqli_fetch_array($result)) {
    $device_explode = explode(',', $row['device']);
    $model_explode = explode(',', $row['model']);
    $supplier_explode = explode(',', $row['supplier']);

    //I am assuming you want to loop trough all exploded fields related to each row
    $devices = [
        $device_explode,
        $model_explode,
        $supplier_explode
    ];

?>


<?php while(($row = mysqli_fetch_array($result))) : ?>
    <table border='1'>
        <tr>
            <th>Møterom</th>
            <th>Romnummer</th>
            <th>Lokasjon</th>
            <th>Antall sitteplasser</th>
            <th>Tilgjengelig utstyr</th>
            <th>Bilde av rommet</th>
            <th>Endre</th>
            <th>Slett</th>
        </tr>
        <tr>
            <td><?= $row['name'] ?></td>
            <td><?= $row['roomnbr'] ?></td>
            <td><?= $row['location'] ?></td>
            <td><?= $row['seats'] ?></td>
            <td>
            <?php foreach ($devices as $deviceSpecs) :  //Here we loop trough the first dimension fo the array ?>
                <?php foreach ($deviceSpecs as $deviceSpec): //Here we loop trough the second dimension ?>
                <?= $deviceSpec ?><br>
                <?php endforeach; ?>
            <?php endforeach; ?>
            </td>
            <td><img src='../img/uploads/<?= $row['img'] ?>' width='150px' ></td>
            <td><a href='?p=editconfroomv2&id=<?= $row['id'] ?>>Endre</a></td>
            <td><a href='./index.php?p=deleteconfroomdb&id=<?= $row['id'] ?>' class='delete'>Slett</a></td>

        </tr>
    </table>
<?php endwhile; ?>