<?php
$resultset = [
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test007'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test006'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test0094'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test0098'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test010'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test111'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test 008'],
['converternumber' => '2', 'zonenumber' => '1a', 'codeid' => 'test'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test112'],
['converternumber' => '1', 'zonenumber' => '23', 'codeid' => 'rg'],
['converternumber' => '1', 'zonenumber' => '2a', 'codeid' => 'test001'],
['converternumber' => '1', 'zonenumber' => '2a', 'codeid' => 'test003'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test004'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test002'],
['converternumber' => '1', 'zonenumber' => '1a', 'codeid' => 'test001'],
['converternumber' => '2', 'zonenumber' => 'b2', 'codeid' => 'gffff'],
['converternumber' => '1', 'zonenumber' => 'feh', 'codeid' => 'ndo'],
['converternumber' => '1', 'zonenumber' => 'wr', 'codeid' => 'fxv']
];
foreach ($resultset as $row) {
$info[$row['converternumber']][$row['zonenumber']][] = $row['codeid'];
}
//var_export($info);
echo "converternumbers: " , implode(', ', array_keys($info));
echo "\n---\n";
foreach ($info as $c => $zonenos) {
echo "$c contains: " , implode(', ', array_keys($zonenos)) , "\n";
foreach ($zonenos as $zoneno => $codeids) {
echo "$c - $zoneno: " , implode(', ', $codeids) , "\n";
}
echo "---\n";
}
echo "\n----\nThe JSON OUTPUT:\n";
echo json_encode($info);
preferences:
25.35 ms | 406 KiB | 5 Q