Parse XML string to JSON array

Question

$xmlString = '<?xml version="1.0" encoding="UTF-8" ?>
<corpsms>
    <transaction id="44444774">
        <status num="923337896466" date="14-11-2017 10:02:58">Successful</status>
        <status num="923337897246" date="14-11-2017 10:02:59">Successful</status>
    </transaction>
</corpsms>';

Failed to catch 'status num="923337896466"' And failed to catch date="14-11-2017 10:02:58"

JSON output should be like:

{
    "transaction id": "44444774",
    "Total status num": "02",
    "status": [
        {
            "status num": "923337896466",
            "date": "14-11-2017 10:02:58",
            "output": "Successful"
        },
        {
            "status num": "923337897246",
            "date": "14-11-2017 10:02:59",
            "output": "Successful"
        }
    ]
}

SimpleXMLElement Object ( [transaction] => SimpleXMLElement Object ( [@attributes] => Array ( [id] => 44444774 ) [status] => Array ( [0] => Successful [1] => Successful ) ) ) — Malik Irfan, Nov 14 '17 at 05:28
Show us an attempt at code, so far we're seeing what you have and what you want. — Scuzzy, Nov 14 '17 at 05:32
Possible duplicate of [How to convert xml into array in php?](https://stackoverflow.com/questions/6578832/how-to-convert-xml-into-array-in-php) — Gunaseelan, Nov 14 '17 at 05:44

Gunaseelan · Answer 1 · 2017-11-15T12:01:39.210

0

$xmlString = '<?xml version="1.0" encoding="UTF-8" ?>
<corpsms>
    <transaction id="44444774">
        <status num="923337896466" date="14-11-2017 10:02:58">Successful</status>
        <status num="923337897246" date="14-11-2017 10:02:59">Successful</status>
    </transaction>
</corpsms>';

$xml = simplexml_load_string($xmlString, "SimpleXMLElement", LIBXML_NOCDATA);
$json = json_encode($xml);
$array = json_decode($json,TRUE);

The output will be

{
    "transaction id": "44444774",
    "Total status num": "02",
    "status": [
        {
            "num": "923337896466",
            "date": "14-11-2017 10:02:58",
            "output": "Successful"
        },
        {
            "num": "923337897246",
            "date": "14-11-2017 10:02:59",
            "output": "Successful"
        }
    ]
}

edited Nov 15 '17 at 12:01

answered Nov 14 '17 at 06:21

Gunaseelan

2,494
5
36
43

failed to get "status num" – Malik Irfan Nov 14 '17 at 06:25
Space between `status` and `num` maybe the issue, Change it to `statusnum` or `status_num`. You will get the result. – Gunaseelan Nov 14 '17 at 12:14
cant change anything because response is coming from 3rd party . where we do not have access . – Malik Irfan Nov 15 '17 at 05:16
@MalikIrfan `num` attribute of `status` element. so you can get the value of `num` – Gunaseelan Nov 15 '17 at 10:19
but how ? i failed to get – Malik Irfan Nov 15 '17 at 11:08
@MalikIrfan What you are getting? Kindly update your question – Gunaseelan Nov 15 '17 at 12:02

Parse XML string to JSON array

1 Answers1