PHP - foreach loop not return all keys and values [duplicate]

Question

I have an array in my php code


$list = array(
'RETAIL' => 'SUPERMARKET'
'RETAIL' => 'BAR'
'RETAIL' => 'DEP. MARKET'
'BUSINESS' => 'HOTEL'
'BUSINESS' => 'PUB'
'OTHER' => 'GROCERY'
'OTHER' => 'BUTCHERY'
// I have 20+ items
);

foreach( $list as $type => $name ){
  var_dump($type,$name);
}

//var_dump() output 
// RETAIL SUPERMARKET
// BUSINESS HOTEL
// OTHER BUTCHERY

I'm facing the problem that when I try to loop the array only three values will be returned and the rest are ignored. How I can fix this? I'm trying to loop the array to save the data into a custom wordpress database. With the same way I've successfully looped another array inserted the keys and values into the db.

PHP arrays cannot have multiple entries with the same key, but you could have each key as an array containing multiple types. ['retail' => ['bar', 'shop']] — Dale
– Dale, Commented Oct 14, 2022 at 12:59
Can you add more details where is this $list array being retrieved from? — Plamen Nikolov
– Plamen Nikolov, Commented Oct 14, 2022 at 13:00
@Dale ok. If you provide an answer with example I will accept it. Thanks for the help — newbiedev
– newbiedev, Commented Oct 14, 2022 at 13:03
@newbiedev can you add the code you use to extract the data from the excel file? — Plamen Nikolov
– Plamen Nikolov, Commented Oct 14, 2022 at 13:05
What @Dale means is that this array cannot in fact exist. One key will overwrite the other. — Juan
– Juan, Commented Oct 14, 2022 at 13:12

Dale · Accepted Answer · 2022-10-14 13:07:18Z

1

I think a better structure for your array would something like this

$list = [
    'RETAIL' => [
        'BAR',
        'RESTAURANT'
    ]
];

And you could loop over like so

foreach ($list as $businessType => $businesses) {
    foreach ($businesses as $business) {
         echo "<li>{$business}</li>";
    }
}

Just an example

answered Oct 14, 2022 at 13:07

Dale

10.5k23 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

newbiedev Over a year ago

I'm testing the solution and seems working. Just a question about the keys, can I have for example RETAIL used as a value to insert in my db query?

Dale Over a year ago

If I understand you correctly, after the first foreach in the above code you have the variable $businessType which is that first key RETAIL

Snor · Accepted Answer · 2022-10-14 13:28:13Z

As a general way of handling instances where you have more than one element to each piece of data (even when it's not in a tree structure like this may be), you should structure each item in the list as either an array or object, eg:

$list_of_arrays = [
    ['RETAIL', 'SUPERMARKET'],
    ['RETAIL', 'BAR'],
    ['RETAIL', 'DEP. MARKET'],
];

foreach( $list_of_arrays as $array ){
    echo "<li>{$array[0]} {$array[1]}</li>";
}

or

$list_of_objects = [
    (object)['type' => 'RETAIL', 'subtype' => 'SUPERMARKET'],
    (object)['type' => 'RETAIL', 'subtype' => 'BAR'],
    (object)['type' => 'RETAIL', 'subtype' => 'DEP. MARKET'],
];

foreach( $list_of_objects as $object ){
    echo "<li>{$object->type} {$object->subtype}</li>";
}

Juan · Accepted Answer · 2022-10-14 13:34:00Z

1

Maybe I show heavily but as you only have two data for each entity, why your table is not built like this at the base...?

$list = array(
'SUPERMARKET'=>'RETAIL',
'BAR'=>'RETAIL',
'DEP. MARKET'=>'RETAIL',
'HOTEL'=>'BUSINESS',
'PUB'=>'BUSINESS',
'GROCERY'=>'OTHER',
'BUTCHERY'=>'OTHER'
// I have 20+ items
);

You do have keys that uniquely identify entities.

answered Oct 14, 2022 at 13:34

Juan

8327 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP - foreach loop not return all keys and values [duplicate]

3 Answers 3

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Linked

Related