Parsing XML

[dngzone]

I need someone with XML knowledge to help me out. I forget everything and I have a rush project that needs done asap.

I have an XML file here (http://www.fidnet.com/xml/news.xml)
that I want to get into working variables or arrays. Every attempt I've completed does not allow me to create variable "loops" persay.

Here's the parsing job I've got so far. (http://www.fidnet.com/xml/newsheadlines.php)

Notice that for each headline, there is not a distinct variable/array name. (IE:
<?
echo $ary_parsed_file['CONTENT_SERVLET_RESULTS']['RESULT']['HEADLINE']['HEADLINE']
?>
- this is repeated and when I echo this to the screen, I just get the last elements??)

I've tried multiple parsing scripts and I'm not find any scripts available that will help me.

I'm stumped and need someone that can lend a tip or two???

I may even have a little prize to give out to the person that steps up to help!

[superwormy]

I think I see your problem, basically when you're putting it into an array, each time you write the next [HEADLINE][HEADLINE] element, you overwrite the previous one. What needs to happen is that first [HEADLINE] tag needs to get changed or something if its going to be put in array.

I wrote a function to change XML to an array a while back:

http://www.durdenwebapplications.com/durdenwebapplications_PHP/#XMLToArray_Better

http://www.durdenwebapplications.com/durdenwebapplications_PHP/Func/XMLToArray_Better.func.phps

BUT in looking at this XML doc. I found two problems. One you need to strip off the <?xml version="1.0" encoding="ISO-8859-1" ?>

And TWO, the function I wrote is having problems with having two levels of the same tag, ie the [HEADLINE][HEADLINE] is causing problems, but if it was [HEADLINE][HEADLINE_TITLE] it works fine.

You call my function with:
$array = XMLToArray_Better ($xml, array ("Headline"));

Which ensures that that first "Headline" tag gets changed to an incrementing integer key, instead of "Headline" so that it get overwritten every time.

If I get around to it I'll try and fix those first problems and post back here, or you're welcome to download my function and play withi t, see if you can get it to work.

[dngzone]

Stole a chuck of your code and after about 3 hours of cussing, was finally able to get things to work. Thanks for the comments and tips.

[superwormy]

Oh good, what did you haev to do to fix it?

[dngzone]

I used this code below to get the array loops not to clobber each other.

function GetChildren($vals, &$i) {

$children = array();

while (++$i < sizeof($vals)) {

    // compair type
    switch ($vals[$i]['type']) {

        case 'cdata':
            $children[] = $vals[$i]['value'];
            break;
        case 'complete':
            $children[] = array(
                'tag' => $vals[$i]['tag'],
                'attributes' => $vals[$i]['attributes'],
                'value' => $vals[$i]['value']
            );
            break;
        case 'open':
            $children[] = array(
                'tag' => $vals[$i]['tag'],
                'attributes' => $vals[$i]['attributes'],
                'value' => $vals[$i]['value'],
                'children' => GetChildren($vals, $i)
            );
            break;
        case 'close':
            return $children;
    }
}

}

function GetXMLTree($file) {

$data = implode('', file($file));

// by: [email][e-mail][/email] - trim space around tags not within
$data = eregi_replace(">"."[[:space:]]+"."<","><",$data);

// XML functions
$p = xml_parser_create();

// by: [email][e-mail][/email] - meets XML 1.0 specification
xml_parser_set_option($p, XML_OPTION_CASE_FOLDING, 0);
xml_parse_into_struct($p, $data, &$vals, &$index);
xml_parser_free($p);

$i = 0;
$tree = array();
$tree[] = array(
    'tag' => $vals[$i]['tag'],
    'attributes' => $vals[$i]['attributes'],
    'value' => $vals[$i]['value'],
    'children' => GetChildren($vals, $i)
);

return $tree;

}
#echo "<pre>";
$temp = array();
$temp = GetXMLTree($simple);
#print_r($temp);