PHPize Online / SQLize Online  /  SQLtest Online

<?php $csv = <<<'_CSV' ArtNo,Name,Color,Size DEF270, Fingal, Stellar, 3XL DEF270, Fingal, White, 4XL; _CSV; $csv_handle = fopen('php://memory', 'rw'); $fwrite = fwrite($csv_handle, $csv); fseek($csv_handle, 0); $articles = []; while (($data = fgetcsv($csv_handle)) !== false) { [$articleNumber, $name, $color, $size] = array_map('trim', $data); if (!isset($articles[$articleNumber])) { $articles[$articleNumber] = [ 'names' => [$name], 'colors' => [$color], 'sizes' => [$size], ]; continue; } $article = &$articles[$articleNumber]; if (!in_array($name, $article['names'])) { $article['names'][] = $name; } if (!in_array($color, $article['colors'])) { $article['colors'][] = $color; } if (!in_array($size, $article['sizes'])) { $article['sizes'][] = $size; } unset ($article); } fclose($csv_handle); echo "<table>\n"; foreach ($articles as $articleNumber => $article) { $name = implode(', ', $article['names']); $colors = implode(', ', $article['colors']); $sizes = implode(', ', $article['sizes']); echo "<tr><td>$articleNumber</td><td>$name</td><td>$colors</td><td>$sizes</tr>\n"; } echo "</table>\n";