<?php
$sql = [['name' => 'Altex'], ['name' => 'ARSIS'], ['name' => 'Avon'], ['name' => 'Azerty'], ['name' => 'BADABUM'], ['name' => 'Boutique Mall'], ['name' => 'Brand Circus'], ['name' => 'CEL.ro'], ['name' => 'ClickShop.ro'],];
$current_letter = null;
foreach ($sql as $row) {
$name = $row['name'];
$first_letter = $name[0];
if ($first_letter != $current_letter) {
$i = 1;
if ($current_letter) { // close the previous DIV before starting new one
echo '</ul>'.PHP_EOL;
echo '</div>'.PHP_EOL;
}
$current_letter = $first_letter;
echo '<div class="store-wrapper">'.PHP_EOL;
echo '<div class="store-letter">Store Letter - '. $current_letter .'</div>'.PHP_EOL;
echo '<ul>'.PHP_EOL;
}
if ($i > 3) {
continue;
}
echo "\t<li>".$name.'</li>'.PHP_EOL;
$i++;
}
if ($current_letter) { // close the last DIV
echo '</ul>'.PHP_EOL;
echo '</div>'.PHP_EOL;
}
PD9waHAKCiRzcWwgPSBbWyduYW1lJyA9PiAnQWx0ZXgnXSwgWyduYW1lJyA9PiAnQVJTSVMnXSwgWyduYW1lJyA9PiAnQXZvbiddLCBbJ25hbWUnID0+ICdBemVydHknXSwgWyduYW1lJyA9PiAnQkFEQUJVTSddLCBbJ25hbWUnID0+ICdCb3V0aXF1ZSBNYWxsJ10sIFsnbmFtZScgPT4gJ0JyYW5kIENpcmN1cyddLCBbJ25hbWUnID0+ICdDRUwucm8nXSwgWyduYW1lJyA9PiAnQ2xpY2tTaG9wLnJvJ10sXTsKCiRjdXJyZW50X2xldHRlciA9IG51bGw7CmZvcmVhY2ggKCRzcWwgYXMgJHJvdykgewogICAgJG5hbWUgPSAkcm93WyduYW1lJ107CiAgICAkZmlyc3RfbGV0dGVyID0gJG5hbWVbMF07CiAgICBpZiAoJGZpcnN0X2xldHRlciAhPSAkY3VycmVudF9sZXR0ZXIpIHsKICAgICAgICAkaSA9IDE7CiAgICAgICAgaWYgKCRjdXJyZW50X2xldHRlcikgeyAvLyBjbG9zZSB0aGUgcHJldmlvdXMgRElWIGJlZm9yZSBzdGFydGluZyBuZXcgb25lCiAgICAgICAgICAgIGVjaG8gJzwvdWw+Jy5QSFBfRU9MOwogICAgICAgICAgICBlY2hvICc8L2Rpdj4nLlBIUF9FT0w7CiAgICAgICAgfQogICAgICAgICRjdXJyZW50X2xldHRlciA9ICRmaXJzdF9sZXR0ZXI7CiAgICAgICAgZWNobyAnPGRpdiBjbGFzcz0ic3RvcmUtd3JhcHBlciI+Jy5QSFBfRU9MOwogICAgICAgIGVjaG8gJzxkaXYgY2xhc3M9InN0b3JlLWxldHRlciI+U3RvcmUgTGV0dGVyIC0gJy4gJGN1cnJlbnRfbGV0dGVyIC4nPC9kaXY+Jy5QSFBfRU9MOwogICAgICAgIGVjaG8gJzx1bD4nLlBIUF9FT0w7CiAgICB9CiAgICBpZiAoJGkgPiAzKSB7CiAgICAgICAgY29udGludWU7CiAgICB9CiAgICBlY2hvICJcdDxsaT4iLiRuYW1lLic8L2xpPicuUEhQX0VPTDsKICAgICRpKys7Cn0KaWYgKCRjdXJyZW50X2xldHRlcikgeyAvLyBjbG9zZSB0aGUgbGFzdCBESVYKICAgIGVjaG8gJzwvdWw+Jy5QSFBfRU9MOwogICAgZWNobyAnPC9kaXY+Jy5QSFBfRU9MOwp9