3v4l.org

run code in 300+ PHP versions simultaneously

@ 2020-09-09T11:36:38Z

<?php

$resultObject = [
    ['name' => 'Tom', 'value' => 15, 'year' => 2018],
    ['name' => 'Tom', 'value' => 4, 'year' => 2019],
    ['name' => 'Tom', 'value' => 6, 'year' => 2020],
    ['name' => 'Kate', 'value' => 18, 'year' => 2018],
    ['name' => 'Kate', 'value' => 20, 'year' => 2019],
];

$grouped = [];
$columns = [];

foreach ($resultObject as $row) {
    $grouped[$row['name']][$row['year']] = $row['value'];
    $columns[$row['year']] = $row['year'];
}

sort($columns);
$defaults = array_fill_keys($columns, '-');
array_unshift($columns, 'name');

echo "<table>\n";
    printf(
        "<tr><th>%s</th></tr>\n",
        implode('</th><th>', $columns)
    );
    foreach ($grouped as $name => $records) {
        printf(
            "<tr><td>%s</td><td>%s</td></tr>\n",
            $name,
            implode('</td><td>', array_replace($defaults, $records))
        );
    }
echo "</table>";

Output for 7.2.0 - 7.2.34, 7.3.0 - 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 - 8.3.7: <table> <tr><th>name</th><th>2018</th><th>2019</th><th>2020</th></tr> <tr><td>Tom</td><td>15</td><td>4</td><td>6</td></tr> <tr><td>Kate</td><td>18</td><td>20</td><td>-</td></tr> </table>
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 <table> <tr><th>name</th><th>2018</th><th>2019</th><th>2020</th></tr> <tr><td>Tom</td><td>15</td><td>4</td><td>6</td></tr> <tr><td>Kate</td><td>18</td><td>20</td><td>-</td></tr> </table>

preferences:dark modelive preview

165.51 ms | 402 KiB | 192 Q