Achieving same array structure when converting from JSON and XML

Question

I'm trying to build my first public API, which is going pretty fine, but i ran into some trouble converting different data formats that will get POSTed. Basically, the API should accept both JSON and XML, and now i'm trying to convert those into a common PHP array structure.

For JSON my example looks like this:

$people = array( array('name' => 'casper',
                       'shoesize' => 41
                 ),
                 array('name' => 'christine',
                       'shoesize' => 37
                 )
);

$data = json_encode($people);
return json_decode($data);

This will result in:

[{"name":"casper","shoesize":"41"},{"name":"charlotte","activated":"1"}]

The XML example is as follows:

$xml = '<?xml version="1.0"?>'.
       '<people>'.
           '<person>'.
               '<name>casper</name>'.
               '<shoesize>41</shoesize>'.
           '</person>'.
           '<person>'.
               '<name>christine</name>'.
               '<shoesize>37</name>'.
           '</person>'.
       '</people>';

$xml = simplexml_load_string($xml);
$data = json_encode($xml);
return json_decode($data);

This will result in:

{"person":[{"name":"casper","shoesize":"42"},{"name":"christina","shoesize":"12"}]}

Can anyone figure out how i will be able to achieve the same array structure in both examples?

Rajeev Ranjan · Accepted Answer · 2013-07-16 12:27:55Z

1

i think this could help you :-

 $xml = '<?xml version="1.0"?>'.
   '<people>'.
       '<person>'.
           '<name>casper</name>'.
           '<shoesize>41</shoesize>'.
       '</person>'.
       '<person>'.
           '<name>christine</name>'.
           '<shoesize>37</shoesize>'.
       '</person>'.
   '</people>';
 $xml = simplexml_load_string($xml);
 $data = json_encode($xml);
echo '<pre>';
 $dataarray=(json_decode($data,true));
$requiredarray=$dataarray['person'];
print_r($requiredarray);

Output :-

Array
(
    [0] => Array
        (
            [name] => casper
            [shoesize] => 41
        )

    [1] => Array
        (
            [name] => christine
            [shoesize] => 37
        )

)

answered Jul 16, 2013 at 12:27

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

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

1 Comment

Stromgren Over a year ago

Thanks Rajeev Ranjan. This works! Will i be able to achieve this result by changing the initial XML structure instead?

Collectives™ on Stack Overflow

Achieving same array structure when converting from JSON and XML

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related