PHP - Need help to handle array output-CodePudding

I need some help figuring out how to get the array looking how I want it.It's basically a list of services that my client delivers and they want to have all clients under the services. I have an array looking like this:

What I want it to look like is this:

Array
(
    [0] => Array
        (
            [service] => Venturi flowmeters
            [name] => Gina Krogh - Flow Packages
            [name] => Johan Sverdrup
        )

    [1] => Array
        (
            [service] => Thermowells
            [name] => Gina Krogh - Flow Packages
            [name] => Aasta Hansteen
            [name] => Johan Sverdrup
        )

    [2] => Array
        (
            [service] => Flow orifices
            [name] => Gina Krogh - Flow Packages
            [name] => Aasta Hansteen
        )

    [3] => Array
        (
            [service] => Instrument Enclosure Systems
            [name] => Gina Krogh - Flow Packages
        )

    [4] => Array
        (
            [service] => Transmitters
            [name] => Gina Krogh - Flow Packages
        )


    [5] => Array
        (
            [service] => Restriction orifices
            [name] => Aasta Hansteen
        )

    [6] => Array
        (
            [service] => Temperature sensors 
            [name] => Aasta Hansteen
            [name] => Johan Sverdrup
        )


    [7] => Array
        (
            [service] => PG/ TG 
            [name] => Aasta Hansteen
        )

    [8] => Array
        (
            [service] => Venturi tubes 
            [name] => Aasta Hansteen
        )

    [9] => Array
        (
            [service] => Chemical injection Flowmeters 
            [name] => Aasta Hansteen
        )

    [10] => Array
        (
            [service] => Ultrasonic flowmeters
            [name] => Johan Sverdrup
        )

    [1] => Array
        (
            [service] => Instrument weather enclosure for meetering
            [name] => Johan Sverdrup
        )
)

And I am stuck on how I can do this so any help is appreciated :)

CodePudding user response：

This is impossible. You simply cannot have multiple elements inside an array that share the same key. For obvious reasons. What you can do instead is use an embedded array to hold all those colliding entries:

<?php
$input = [
    [
        'service' => "Venturi flowmeters",
        'name' => "Gina Krogh - Flow Packages"
    ],
    [
        'service' => "Thermowells",
        'name' => "Gina Krogh - Flow Packages"
    ],
    [
        'service' => "Flow orifices",
        'name' => "Gina Krogh - Flow Packages"
    ],
    [
        'service' => "Instrument Enclosure Systems",
        'name' => "Gina Krogh - Flow Packages"
    ],
    [
        'service' => "Transmitters",
        'name' => "Gina Krogh - Flow Packages"
    ],
    [
        'service' => "Flow orifices",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Restriction orifices",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Temperatur sensors ",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Thermowells ",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "PG/ TG ",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Venturi tubes ",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Chemical injection Flowmeters ",
        'name' => "Aasta Hansteen"
    ],
    [
        'service' => "Ultrasonic flowmeters",
        'name' => "Johan Sverdrup"
    ],
    [
        'service' => "Venturi flowmeters",
        'name' => "Johan Sverdrup"
    ],
    [
        'service' => "Instrument weather enclosure for meetering",
        'name' => "Johan Sverdrup"
    ],
    [
        'service' => "Temperatur sensors",
        'name' => "Johan Sverdrup"
    ],
    [
        'service' => "Thermowells",
        'name' => "Johan Sverdrup"
    ],
];

$output = [];
array_walk($input, function($entry) use (&$output) {
    $service = trim($entry['service']);
    $name = trim($entry['name']);
    if (array_key_exists($service, $output)) {
        $output[$service]['name'][] = $name;
    } else {
        $output[$service] = [
            'service' => $service,
            'name' => [
                $name
            ]
        ];
    }
});

print_r($output);

The output is:

CodePudding user response：

As @arkascha has stated, the output you want is not possible. Here is an alternative approach to @arkascha's solution:

$input = [
    [ 'service' => 'Venturi flowmeters', 'name' => 'Gina Krogh - Flow Packages' ],
    [ 'service' => 'Thermowells', 'name' => 'Gina Krogh - Flow Packages' ],
    [ 'service' => 'Flow orifices', 'name' => 'Gina Krogh - Flow Packages' ],
    [ 'service' => 'Instrument Enclosure Systems', 'name' => 'Gina Krogh - Flow Packages' ],
    [ 'service' => 'Transmitters', 'name' => 'Gina Krogh - Flow Packages' ],
    [ 'service' => 'Flow orifices', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Restriction orifices', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Temperatur sensors', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Thermowells', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'PG/ TG', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Venturi tubes', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Chemical injection Flowmeters', 'name' => 'Aasta Hansteen' ],
    [ 'service' => 'Ultrasonic flowmeters', 'name' => 'Johan Sverdrup' ],
    [ 'service' => 'Venturi flowmeters', 'name' => 'Johan Sverdrup' ],
    [ 'service' => 'Instrument weather enclosure for meetering', 'name' => 'Johan Sverdrup' ],
    [ 'service' => 'Temperatur sensors', 'name' => 'Johan Sverdrup' ],
    [ 'service' => 'Thermowells', 'name' => 'Johan Sverdrup' ],
];

$result = [];
foreach ($input as $item) {
  $result[trim($item['service'])][] = $item['name'];
}
print_r($result);

$thermowells = $result['Thermowells'];
echo "Names for service 'Thermowells': \n";
print_r($thermowells);

Output:

Array
(
    [Venturi flowmeters] => Array
        (
            [0] => Gina Krogh - Flow Packages
            [1] => Johan Sverdrup
        )

    [Thermowells] => Array
        (
            [0] => Gina Krogh - Flow Packages
            [1] => Aasta Hansteen
            [2] => Johan Sverdrup
        )

    [Flow orifices] => Array
        ...
)
Names for service 'Thermowells': 
Array
(
    [0] => Gina Krogh - Flow Packages
    [1] => Aasta Hansteen
    [2] => Johan Sverdrup
)