Adjust array format after converting from XML

Question

I try to parse xml into arrays. I have got 2 types of incoming data: 1)

<rows>
<item>
<a>A</a>
<b>B</b>
</item>
<item>
<c>C</c>
<d>D</d>
</item>
</rows>

2)

<rows>
<item>
<e>E</e>
<f>F</f>
</item>
</rows>

I create an object of SimpleXMLElement and then convert it in array as in Converting a SimpleXML Object to an Array using first answer. The result in first case is

[ '0' => ['a' => 'A', 'b' => 'B'], '1' => ['c' => 'C', 'd' => 'D']].

The result in second case is ['e' => 'E', 'f' => 'F']

But I need a numeric key in second case [ '0' => ['e' => 'E', 'f' => 'F']]

How to fix it?

You will have to handle this progrmmatically

Aefits
– Aefits

2018-03-05 10:01:17 +00:00
Commented Mar 5, 2018 at 10:01 — Aefits
– Aefits, Commented Mar 5, 2018 at 10:01
This may help you

Luc M
– Luc M

2018-03-05 12:04:24 +00:00
Commented Mar 5, 2018 at 12:04 — Luc M
– Luc M, Commented Mar 5, 2018 at 12:04

The fourth bird · Accepted Answer · 2018-03-05 13:43:25Z

1

For your given example, I think you could use array_values which (from the docs):

returns all the values from the array and indexes the array numerically.

$xml = simplexml_load_string($source);
$result = array_values(json_decode(json_encode($xml), true));
var_dump($result);

Will give you:

array(1) {
  [0]=>
  array(2) {
    ["e"]=>
    string(1) "E"
    ["f"]=>
    string(1) "F"
  }
}

Demo

answered Mar 5, 2018 at 13:43

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

Comments

Harvey Fletcher · Accepted Answer · 2018-03-05 11:48:02Z

1

If you have your e,f array (Which is the output of your second case, but i've generated it here. Just use your XML array from your second case)

$arr1 = array(
    'e' => 'E',
    'f' => 'F',
    'g' => 'G',
    'h' => 'H',
);

you can then do

$arr2 = array_chunk($arr1, 2);

which will give you the output ($arr2):

[0 => ['e' => 'E', 'f' => 'F'], 1=> ['g' => 'G', 'h' => 'H']]

and that will work assuming that you want your sub arrays to always be 2 items in length. You can change that by changing the second parameter of array_chunk().

edited Mar 5, 2018 at 11:48

answered Mar 5, 2018 at 11:43

Harvey Fletcher

1,1821 gold badge10 silver badges25 bronze badges

2 Comments

Nigel Ren Over a year ago

Not sure if this answers OP's question at all.

Harvey Fletcher Over a year ago

They wanted the output of the array to be split into seperate numerically keyed arrays, this does that, but I might have misunderstood the question.

Collectives™ on Stack Overflow

Adjust array format after converting from XML

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related