Parsing XML data in PHP array

Question

I have this format of xml which is created automatically and was wondering how to iterate through it and save data into mysql

<sales>

  <site_id="000001" sale_id="80" end_date="20170826" end_time="112420" />

  <site_id="000002" sale_id="81" end_date="20170828" end_time="101001" />

  <site_id="000003" sale_id="82" end_date="20170828" end_time="101001" />

</sales>

I am okay with inserting into database, however it is the iteration and capturing in a variable that I am kind of stuck with

this is not a valid XML, you need to parse like html but isn't valid HTML neither — ZiTAL
– ZiTAL, Commented Nov 16, 2017 at 10:58
It is valid - just use SimpleXML: php.net/manual/de/simplexml.examples-basic.php — derdida
– derdida, Commented Nov 16, 2017 at 11:01
it's NOT valid XML, the tag is closed as HTML, and the nodename is used as an attribute — ZiTAL
– ZiTAL, Commented Nov 16, 2017 at 11:08
Indeed, should be <site side_id="000" etc <site_id="000" is not valid XML so won't be parsed. Also need a closing tag </site> — Alan Kael Ball
– Alan Kael Ball, Commented Nov 16, 2017 at 11:11

ZiTAL · Accepted Answer · 2017-11-16 14:16:20Z

1

If you can't edit the source you can use regex:

<?php
$xml = <<<XML
<sales>

  <site_id="000001" sale_id="80" end_date="20170826" end_time="112420" />

  <site_id="000002" sale_id="81" end_date="20170828" end_time="101001" />

  <site_id="000003" sale_id="82" end_date="20170828" end_time="101001" />

</sales>
XML;

$lines = preg_split("/\n/", $xml);

$results = array();
foreach($lines as $line)
{
    $line = trim($line);
    if(preg_match("/^<[^$]+\ \/>$/", $line))
    {
        preg_match_all("/([^=<\s]+)=\"([^\"]+)\"/", $line, $m);
        $result = array();
        foreach($m as $n)
        {
            $count = count($n);
            for($i=0;$i<$count;$i++)
                $result[$m[1][$i]] = $m[2][$i];
        }
        $results[] = $result;
    }
}

print_r($results);

PD: KILL THE XML SOURCE DEVELOPER

answered Nov 16, 2017 at 14:16

ZiTAL

3,6019 gold badges38 silver badges52 bronze badges

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

2 Comments

user1430825 Over a year ago

One last question, what is the best way to capture the values into variables? [given that the xmls will be different in sizes and will constantly be changing, but the values must be stored in mysql ]

ZiTAL Over a year ago

the code is prepared to have X attributes in the XML by each node, you have all the keys and values in the array, you only need to iterate it and insert the values in the correspondent key codes.

ZiTAL · Accepted Answer · 2017-11-16 11:16:06Z

1

It's a not valid XML, it will be something like this:

<sales>

  <sale site_id="000001" sale_id="80" end_date="20170826" end_time="112420"></sale>

  <sale site_id="000002" sale_id="81" end_date="20170828" end_time="101001"></sale>

  <sale site_id="000003" sale_id="82" end_date="20170828" end_time="101001"></sale>

</sales>

$dom = new DOMDocument('1.0', 'utf-8');
$dom->loadXML($xml);

$xpath = new DOMXpath($dom);
$a = $xpath->query("//sale");

$result = array();
$i = 0;
foreach($a as $b)
{
    if ($b->hasAttributes())
    {
        $j = 0;
        $tmp = array();
        foreach ($b->attributes as $attr)
        {
            $tmp[$attr->nodeName] = $attr->nodeValue;
            $j++;
        }
        $result[] = $tmp;
    }
    $i++;
}

print_r($result);

`

output:

Array
(
    [0] => Array
        (
            [site_id] => 000001
            [sale_id] => 80
            [end_date] => 20170826
            [end_time] => 112420
        )

    [1] => Array
        (
            [site_id] => 000002
            [sale_id] => 81
            [end_date] => 20170828
            [end_time] => 101001
        )

    [2] => Array
        (
            [site_id] => 000003
            [sale_id] => 82
            [end_date] => 20170828
            [end_time] => 101001
        )

)

answered Nov 16, 2017 at 11:16

ZiTAL

3,6019 gold badges38 silver badges52 bronze badges

5 Comments

Alan Kael Ball Over a year ago

Deleted my answer as this is much better.

ZiTAL Over a year ago

I can't write multiline php var, sorry

user1430825 Over a year ago

This file comes remotely, so you are saying I may have to write a code that formats it into a correct xml before it can be parsed?

ZiTAL Over a year ago

Yes, there is other alternative, that is read it as HTML instead of XML but, I can't read the "site_id"-s value because it looks like attribute but really is the name of node. Anyway I will try with regex.

user1430825 Over a year ago

One last question, what is the best way to capture the values into variables? given that the xmls will be different in sizes and will constantly be changing, but the values must be stored in mysql

Collectives™ on Stack Overflow

Parsing XML data in PHP array

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related