foreach with multiple variables

Question

I’m trying a foreach with several variables like?

$record = array();  
foreach($resultCustomers as $group)
{
    $record[$group['CODIGO_CLIENTE'].$group['RAZAOSOCIAL']][] = $group['NOME'];


}   

$output = array();  

foreach( $record as $id => $name)
{
    $output[] = array(
            'CODIGO_CLIENTE' => $id,
            'RAZAOSOCIAL' => $id,
            'NOME' => $name
    );

}

He’s leaving like this:

array (size=3)
  'CODIGO_CLIENTE' => string '1Empresa S/A' (length=38)
  'RAZAOSOCIAL' => string '1Empresa S/A' (length=38)
  'NOME' => 
    array (size=23)
      0 => string 'Cliente 1' (length=23)
      1 => string 'Cliente 2' (length=31)
      2 => string 'Cliente 3' (length=43)
      3 => string 'Cliente 4' (length=26)
      4 => string 'Cliente 5' (length=29)
      5 => string 'Cliente 6' (length=21)

I needed a comeback like this:

array (size=3)
  'CODIGO_CLIENTE' => string '1' (length=38)
  'RAZAOSOCIAL' => string 'Empresa S/A' (length=38)
  'NOME' => 
    array (size=23)
      0 => string 'Cliente 1' (length=23)
      1 => string 'Cliente 2' (length=31)
      2 => string 'Cliente 3' (length=43)
      3 => string 'Cliente 4' (length=26)
      4 => string 'Cliente 5' (length=29)
      5 => string 'Cliente 6' (length=21)

Anybody got an idea? Thanks in advance!

Answer 1

You’re creating a different key than you need. Instead of creating $record as you are generating, try:

$record = array();  
foreach($resultCustomers as $group) {
    $record[$group['CODIGO_CLIENTE']]['RAZAOSOCIAL'] = $group['RAZAOSOCIAL'];
    $record[$group['CODIGO_CLIENTE']]['nomes'][] = $group['NOME'];
}   

and retrieve the data as follows:

foreach( $record as $id => $dados) {
    $output[] = array(
            'CODIGO_CLIENTE' => $id,
            'RAZAOSOCIAL' => $dados['RAZAOSOCIAL'],
            'NOME' => $dados['nomes']
    );
}