<?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);
- Output for 5.6.38, 7.1.0 - 7.1.24, 7.2.0 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
- converternumbers: 1, 2
---
1 contains: 1a, 23, 2a, feh, wr
1 - 1a: test007, test006, test0094, test0098, test010, test111, test 008, test112, test004, test002, test001
1 - 23: rg
1 - 2a: test001, test003
1 - feh: ndo
1 - wr: fxv
---
2 contains: 1a, b2
2 - 1a: test
2 - b2: gffff
---
----
The JSON OUTPUT:
{"1":{"1a":["test007","test006","test0094","test0098","test010","test111","test 008","test112","test004","test002","test001"],"23":["rg"],"2a":["test001","test003"],"feh":["ndo"],"wr":["fxv"]},"2":{"1a":["test"],"b2":["gffff"]}}
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
converternumbers: 1, 2
---
1 contains: 1a, 23, 2a, feh, wr
1 - 1a: test007, test006, test0094, test0098, test010, test111, test 008, test112, test004, test002, test001
1 - 23: rg
1 - 2a: test001, test003
1 - feh: ndo
1 - wr: fxv
---
2 contains: 1a, b2
2 - 1a: test
2 - b2: gffff
---
----
The JSON OUTPUT:
{"1":{"1a":["test007","test006","test0094","test0098","test010","test111","test 008","test112","test004","test002","test001"],"23":["rg"],"2a":["test001","test003"],"feh":["ndo"],"wr":["fxv"]},"2":{"1a":["test"],"b2":["gffff"]}}
preferences:
192.66 ms | 403 KiB | 175 Q