php - 按引用代码对图像进行分组

Question

我有一张图片表，我需要列出产品的所有图片以便能够在一行中显示它们:

我有这个问题:

<?php
require_once 'assets/files/meekrodb.php';

$results = DB::query("SELECT * FROM images");
foreach ($results as $row) {
  echo $row['imagen'] . "<br>";
}
?>

它向我展示了这个:

我想按字段“product”分组并像这样在一行中显示:

你能帮我吗，先谢谢了!

Answer 1

您可以在获取结果时按产品分组，如下所示:

$results = DB::query("SELECT * FROM images");

foreach ($results as $row) {
    // use product as key, add image to array at that key
    $products[$row['product']][] = $row['imagen'];
}

然后像这样输出组:

foreach ($products as $product => $images) {
    echo implode(', ', $images) . '<br>';
}